[Home] [Help]
841: ------------------------------------------------------------------------
842: --This procedure sets the Workflow attributes required to initialize the
843: --XNB IB Ownership change workflow process.
844: --This procedure is called from the workflow process.
845: --The arguments correspond to the standard workflow function arguments.
846: --Returns status through OUT parameter resultout. True on Success, False on error.
847: -----------------------------------------------------------------------
848: PROCEDURE set_owner_attributes(itemtype IN VARCHAR2,
849: itemkey IN VARCHAR2,
949: --is Provisionable. The current check involves only checking if the item is non-invoicable. Only non-invoicable
950: --items need be sent to the external billing application.
951: --Checks Inventory MTL_SYSTEM_ITEMS_B to see if, for the item
952: -- INVOICEABLE_ITEM_FLAG = "N" - If TRUE the item is to be invoiced by an external biller.
953: --Arguments: Standard workflow function args
954: --Returns: resultout. TRUE if the instance is provisionable (i.e INVOICEABLE_ITEM_FLAG = "N" )
955: -- FALSE if the instance is not provisionable (i.e INVOICEABLE_ITEM_FLAG = "N" )
956: --Called by the workflow process: XNBFLOWS/OWNER_CHANGE_PROCESS
957: --Errors: Are not handled. Would halt the workflow that calls this.
997: --Retrieves the Inventory Master Org ID from CSI_ITEM_INSTANCES corresponding to the Instance ID in workflow
998: --The retrieved Org ID is set as a worfflow Attribute. (Required by the next Workflow Activity)
999: --Checks for a customer account collaboration with document number = ACCOUNT_NUMBER
1000: -- has been successfully completed with every biller sending atleast one SUCCESS CBOD to the message.
1001: --Arguments: Standard workflow function args
1002: --Returns: resultout. TRUE if the account is published and confirmed SUCCESS by all billers.
1003: -- FALSE if the account-publish is not confirmed SUCCESS by all billers.
1004: --Exceptions: Left unhandled until proper error handling is introduced in the workflow
1005: --Called by the Workflow Item Type: XNBFLOWS, Process: OWNER_CHANGE_PROCESS
1118:
1119: ---------------------------------------------------------------------------------------------------
1120: --This procedure checks to see if a collaboration exists for this instance for OWNER CHANGE
1121: --Calls the util procedure 'validate_document'
1122: --Arguments: Standard workflow function args.
1123: --Returns status through result_out: FND_API.G_TRUE if exists, FND_API.G_FALSE if it does not exist.
1124: ---------------------------------------------------------------------------------------------------
1125: PROCEDURE check_owner_change_cln(
1126: itemtype IN VARCHAR2,