DBA Data[Home] [Help]

APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on MSC_CL_SUPPLY_ODS_LOAD

Line 1: PACKAGE BODY MSC_CL_SUPPLY_ODS_LOAD AS -- body

1: PACKAGE BODY MSC_CL_SUPPLY_ODS_LOAD AS -- body
2: /*$Header: MSCLSUPB.pls 120.32.12020000.7 2013/02/06 10:02:23 swundapa ship $*/
3: -- G_JOB_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_DONE;
4: -- G_JOB_NOT_DONE NUMBER := MSC_CL_COLLECTION.G_JOB_NOT_DONE;
5: -- G_JOB_ERROR NUMBER := MSC_CL_COLLECTION.G_JOB_ERROR;

Line 2229: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN

2225: /* analyze msc_supplies here */
2226: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
2227: IF MSC_CL_COLLECTION.v_exchange_mode= MSC_UTIL.SYS_YES THEN
2228: /* create temporay index */
2229: IF MSC_CL_SUPPLY_ODS_LOAD.create_supplies_tmp_ind THEN
2230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table successful.');
2231: ELSE
2232: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
2233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Index creation on Temp Supplies table failed.');

Line 4737: END MSC_CL_SUPPLY_ODS_LOAD;

4733: COMMIT;
4734: END LOAD_PAYBACK_SUPPLIES;
4735:
4736:
4737: END MSC_CL_SUPPLY_ODS_LOAD;