APPS.MSC_WS_SNO_PUBLISH dependencies on MSC_EXCEPTION_DETAILS

Line 21: -- delete records from MSC_EXCEPTION_DETAILS table for the given PlanId, if any

17: -- init global variables
18: g_ErrorCode := '';
19:
20:
21: -- delete records from MSC_EXCEPTION_DETAILS table for the given PlanId, if any
22: BEGIN
23: DELETE FROM MSC_EXCEPTION_DETAILS WHERE PLAN_ID=PlanIdVar;
24: EXCEPTION WHEN others THEN
25: NULL; -- do nothing

Line 23: DELETE FROM MSC_EXCEPTION_DETAILS WHERE PLAN_ID=PlanIdVar;

19:
20:
21: -- delete records from MSC_EXCEPTION_DETAILS table for the given PlanId, if any
22: BEGIN
23: DELETE FROM MSC_EXCEPTION_DETAILS WHERE PLAN_ID=PlanIdVar;
24: EXCEPTION WHEN others THEN
25: NULL; -- do nothing
26: END;
27:

Line 30: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,

26: END;
27:
28: BEGIN
29: -- CODE GOES HERE Part 1A - for Demand category and organizationId <> -1
30: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,
31: SR_INSTANCE_ID,
32: ORGANIZATION_ID,
33: INVENTORY_ITEM_ID,
34: DEPARTMENT_ID,

Line 57: MSC_EXCEPTION_DETAILS_S.NEXTVAL,

53: MSC_INT_ASCP_EXCEPTION_DETAILS.Organization_Id,
54: MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID,
55: DepartmentID,
56: -1,
57: MSC_EXCEPTION_DETAILS_S.NEXTVAL,
58: MSC_INT_ASCP_EXCEPTION_DETAILS.ViolationCode, -- Used to be: 28,
59: MSC_INT_ASCP_EXCEPTION_DETAILS.Quantity,
60: MSC_INT_ASCP_EXCEPTION_DETAILS.Percentage,
61: TO_DATE(PeriodStart, 'YYYY-MM-DD'),

Line 110: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,

106: raise;
107: END;
108: BEGIN
109: -- CODE GOES HERE Part 1B - for Demand category and organizationId = -1
110: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,
111: SR_INSTANCE_ID,
112: ORGANIZATION_ID,
113: INVENTORY_ITEM_ID,
114: DEPARTMENT_ID,

Line 137: MSC_EXCEPTION_DETAILS_S.NEXTVAL,

133: MSC_INT_ASCP_EXCEPTION_DETAILS.Organization_Id,
134: MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID,
135: DepartmentID,
136: -1,
137: MSC_EXCEPTION_DETAILS_S.NEXTVAL,
138: MSC_INT_ASCP_EXCEPTION_DETAILS.ViolationCode, -- Used to be: 28,
139: MSC_INT_ASCP_EXCEPTION_DETAILS.Quantity,
140: MSC_INT_ASCP_EXCEPTION_DETAILS.Percentage,
141: TO_DATE(PeriodStart, 'YYYY-MM-DD'),

Line 202: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,

198: END;
199: BEGIN
200: -- CODE GOES HERE Part 2, for Supply category. Need to
201: -- use MSC_PLANS to find owning org and instance
202: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,
203: SR_INSTANCE_ID,
204: ORGANIZATION_ID,
205: INVENTORY_ITEM_ID,
206: DEPARTMENT_ID,

Line 229: MSC_EXCEPTION_DETAILS_S.NEXTVAL,

225: MSC_PLANS.organization_id,
226: MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID,
227: -1,
228: -1,
229: MSC_EXCEPTION_DETAILS_S.NEXTVAL,
230: MSC_INT_ASCP_EXCEPTION_DETAILS.ViolationCode, -- Used to be: 28,
231: MSC_INT_ASCP_EXCEPTION_DETAILS.Quantity,
232: MSC_INT_ASCP_EXCEPTION_DETAILS.Percentage,
233: TO_DATE(PeriodStart, 'YYYY-MM-DD'),

Line 282: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,

278: END;
279:
280: BEGIN
281: -- CODE GOES HERE Part 3
282: INSERT INTO MSC_EXCEPTION_DETAILS (PLAN_ID,
283: SR_INSTANCE_ID,
284: ORGANIZATION_ID,
285: INVENTORY_ITEM_ID,
286: DEPARTMENT_ID,

Line 346: MSC_EXCEPTION_DETAILS_S.NEXTVAL,

342: ) > 0 ) )
343: then MSC_INT_ASCP_EXCEPTION_DETAILS.ItemID
344: else -1
345: end,
346: MSC_EXCEPTION_DETAILS_S.NEXTVAL,
347: MSC_INT_ASCP_EXCEPTION_DETAILS.ViolationCode, -- Used to be: 28,
348: MSC_INT_ASCP_EXCEPTION_DETAILS.Quantity,
349: MSC_INT_ASCP_EXCEPTION_DETAILS.Percentage,
350: TO_DATE(PeriodStart, 'YYYY-MM-DD'),