APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ORG_AGGR_IBUC

Line 5389: lv_tbl:= 'MSC_ORG_AGGR_IBUC';

5385:
5386: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
5387: lv_tbl:= 'ORG_AGGR_IBUC_'||MSC_CL_COLLECTION.v_instance_code;
5388: ELSE
5389: lv_tbl:= 'MSC_ORG_AGGR_IBUC';
5390:
5391: SELECT LAST_IBUC_COLL_DATE INTO lv_last_ibuc_coll_date
5392: FROM MSC_APPS_INSTANCES
5393: WHERE INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;

Line 5395: DELETE FROM MSC_ORG_AGGR_IBUC

5391: SELECT LAST_IBUC_COLL_DATE INTO lv_last_ibuc_coll_date
5392: FROM MSC_APPS_INSTANCES
5393: WHERE INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
5394:
5395: DELETE FROM MSC_ORG_AGGR_IBUC
5396: WHERE SAMPLE_DATE = trunc(lv_last_ibuc_coll_date);
5397:
5398: END IF;
5399:

Line 5440: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ORG_AGGR_IBUC',

5436:
5437:
5438: IF (MSC_CL_COLLECTION.v_is_complete_refresh
5439: OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
5440: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ORG_AGGR_IBUC',
5441: MSC_CL_COLLECTION.v_instance_id, null);
5442:
5443: END IF;
5444:

Line 5465: 'MSC_ORG_AGGR_IBUC',

5461:
5462: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
5463: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
5464: lv_retcode,
5465: 'MSC_ORG_AGGR_IBUC',
5466: MSC_CL_COLLECTION.v_INSTANCE_CODE,
5467: MSC_UTIL.G_ERROR);
5468:
5469: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 5486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');

5482: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
5483: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5484: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5485: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5486: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5488: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
5489: RAISE;
5490: ELSE

Line 5495: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');

5491: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
5492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '==============================');
5493: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5494: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_IB_CONTRACTS');
5495: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ORG_AGGR_IBUC');
5496: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5497:
5498: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5499: FND_MESSAGE.SET_TOKEN('COLUMN', 'INVENTORY_ITEM_ID');

Line 5556: ' UPDATE MSC_ORG_AGGR_IBUC MOAI '

5552: SELECT IBUCCP_LCID, lcid INTO n1, n2
5553: FROM MSC_APPS_INSTANCES WHERE instance_id = lv_instance_id ;
5554:
5555: lv_sql_stmt :=
5556: ' UPDATE MSC_ORG_AGGR_IBUC MOAI '
5557: ||' set MOAI.SUPPLYING_ORG_ID =('
5558: ||' select MSSO.SOURCE_ORGANIZATION_ID'
5559: ||' from MSC_SR_ASSIGNMENTS MSA,'
5560: ||' MSC_SOURCING_RULES MSR,'