APPS.MSC_CL_POST_PUBLISH dependencies on MSC_ITEM_EXCEPTIONS

Line 84: update msc_item_exceptions

80: BEGIN
81:
82: FORALL i in 1..a_plan_id.COUNT
83:
84: update msc_item_exceptions
85: set exception_count = a_count(i)
86: where plan_id = a_plan_id(i)
87: and company_id = a_company_id(i)
88: and company_site_id = a_company_site_id(i)

Line 223: delete msc_item_exceptions mie

219: --==================================
220:
221: BEGIN
222:
223: delete msc_item_exceptions mie
224: where
225: plan_id = -1
226: and exception_group in (1,2,4,6,7,8)
227: and not exists( select 1

Line 241: LOG_MESSAGE('Error while deleting msc_item_exceptions');

237: COMMIT;
238:
239:
240: EXCEPTION WHEN OTHERS THEN
241: LOG_MESSAGE('Error while deleting msc_item_exceptions');
242: LOG_MESSAGE(SQLERRM);
243: p_status := G_ERROR;
244: ROLLBACK;
245: RETURN;

Line 283: update msc_item_exceptions

279: BEGIN
280:
281: FORALL i in 1..a_plan_id.COUNT
282:
283: update msc_item_exceptions
284: set exception_count = a_count(i)
285: where plan_id = a_plan_id(i)
286: and company_id = a_company_id(i)
287: and company_site_id = a_company_site_id(i)