Hi,
I’m looking at creating an external file template to import project misc. parts demand. I’d like to be able to enter a date that would then update the field ‘Required Date’.
The value for this field is fetched (it’s a proper column in the logical unit), below is the SQL column detail:
NVL(&AO.PROJECT_MISC_PROCUREMENT_API.Calculate_Required_Date(PROJECT_ID,ACTIVITY_SEQ,&AO.ACTIVITY_API.Get_Early_Finish(ACTIVITY_SEQ),OFFSET),&AO.ACTIVITY_API.Get_Early_Finish(ACTIVITY_SEQ)).
I’ve created the external file template and I have added a field/column called ‘Require_Date’
Columns 2 to 7 are mandatory.
Without anything else, the template works but (obviously) the date keyed in in that column is not taken into account to update either ‘Required Date’ or ‘Offset’ - but this is something I’d like to happen.
I’ve looked at using either detail functions or calling an API After Unpack (calling PROJECT_MISC_PROCUREMENT_API.Caclculate_Offset; with the following details PROJECT_MISC_PROCUREMENT_API.Caclculate_Offset(PROJECT_ID,ACTIVITY_SEQ,ACTIVITY_API.Get_Early_Finish(ACTIVITY_SEQ),REQUIRE_DATE)) but no success.
Coming up to the question:
Is there a way to use the methods from an API, using the values that will be entered in each row/columns as parameters?
Methods I’m looking at using are either:
PROJECT_MISC_PROCUREMENT_API.Caclculate_Offset
PROJECT_MISC_PROCUREMENT_API.Calculate_Offset__
