APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_SAFETY_STOCKS

Line 32: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);

28: BEGIN
29:
30: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
31:
32: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
33:
34: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
35: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
36: ELSE

Line 35: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);

31:
32: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
33:
34: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
35: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
36: ELSE
37: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
38: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
39: END IF;

Line 38: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);

34: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
35: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1);
36: ELSE
37: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
38: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SAFETY_STOCKS', MSC_CL_COLLECTION.v_instance_id, -1,MSC_CL_COLLECTION.v_sub_str);
39: END IF;
40:
41: END IF;
42: -- SRP enhancement

Line 58: UPDATE MSC_SAFETY_STOCKS

54: BEGIN
55:
56: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
57:
58: UPDATE MSC_SAFETY_STOCKS
59: SET
60: SAFETY_STOCK_QUANTITY= c_rec.SAFETY_STOCK_QUANTITY,
61: UPDATED= c_rec.UPDATED,
62: STATUS= c_rec.STATUS,

Line 78: INSERT INTO MSC_SAFETY_STOCKS

74: END IF;
75:
76: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
77:
78: INSERT INTO MSC_SAFETY_STOCKS
79: ( PLAN_ID,
80: ORGANIZATION_ID,
81: INVENTORY_ITEM_ID,
82: PERIOD_START_DATE,

Line 135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');

131:
132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
133: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
134: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
135: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
137:
138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
139: RAISE;

Line 147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');

143:
144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
145: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
146: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SAFETY_STOCK');
147: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SAFETY_STOCKS');
148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
149:
150: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
151: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.ITEM_NAME');