APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_SETUP_TRANSITIONS

Line 176: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1);

172: BEGIN
173:
174: IF ((MSC_CL_COLLECTION.v_is_complete_refresh) OR (MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh)) THEN
175: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
176: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1);
177: ELSE
178: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
179: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
180: END IF;

Line 179: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

175: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
176: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1);
177: ELSE
178: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
179: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_SETUP_TRANSITIONS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
180: END IF;
181:
182:
183: c_count := 0;

Line 187: INSERT INTO MSC_SETUP_TRANSITIONS

183: c_count := 0;
184: total_count := 0;
185: FOR c_rec IN res_transitions LOOP
186: BEGIN
187: INSERT INTO MSC_SETUP_TRANSITIONS
188: ( PLAN_ID,
189: RESOURCE_ID,
190: ORGANIZATION_ID ,
191: SR_INSTANCE_ID,

Line 237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');

233:
234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
235: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
236: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
237: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
239:
240: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
241: RAISE;

Line 248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');

244:
245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
246: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
247: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SETUP_TRANSITION');
248: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SETUP_TRANSITIONS');
249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
250:
251: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
252: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');