DBA Data[Home] [Help]

APPS.CST_PRJMFG_ACCT_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 99

 |                               called during the WIP Cost update accounting |
 |                               which is the only case were WT will exist    |
 |                               at the time the hook has been used, in other |
 |                               cases only WCTI will be there                |
 |       OUTPUT:                                                              |
 |	 -x_return_status_call						      |
 |	 -x_msg_count_call      					      |
 |	 -x_msg_data_call        					      |
 |                                                                            |
 |                                                                            |
 | CALLED FROM							              |
 |	 CST_XLA_PVT.Create_INVXLAEvent                                       |
 |	 CST_XLA_PVT.Create_WIPXLAEvent                                       |
 |	                                                                      |
 | RETURN VALUES                                                              |
 |       integer    1   Create SLA events in blue print org for this txn      |
 |                 -1   Error in the hook                                     |
 |                  0 or any other number                                     |
 |                      Do not create SLA events in blue print org for this   |
 |                      transaction  (Default)                                |
 | HISTORY                                                                    |
 |    	 04-Jan-2010   Ivan Pineda   Created                                  |
 *----------------------------------------------------------------------------*/
  FUNCTION  blueprint_sla_hook(p_transaction_id	                    NUMBER,
                               p_table_source                       VARCHAR2,
                               x_return_status       OUT NOCOPY     VARCHAR2,
                               x_msg_count           OUT NOCOPY     NUMBER,
                               x_msg_data            OUT NOCOPY     VARCHAR2)

  RETURN integer IS
  l_action_id NUMBER :=0;
Line: 160

        ONLY IN THE CASE OF  WIP COST UPDATE ACCOUNTING WT WILL EXIST
        AT THE TIME OF CALLING THIS HOOK, FOR OTHER TRANSACTIONS WCTI
        SHOULD BE USED*/
          return 0;