DBA Data[Home] [Help]

APPS.MSC_X_NETTING3_PKG dependencies on MSC_ITEM_EXCEPTIONS

Line 884: And archive the msc_item_exceptions

880: is exist, then no need to send notification and reset
881: version = null. If the exception detail not exist, create
882: a new exception detail and send the notification.
883: Set version = 'CURRENT'
884: And archive the msc_item_exceptions
885: =====================================================*/
886:
887: update msc_x_exception_details
888: set version = 'X'

Line 892: update msc_item_exceptions

888: set version = 'X'
889: where plan_id = msc_x_netting_pkg.G_PLAN_ID
890: and exception_type in (11,12,31,32);
891:
892: update msc_item_exceptions
893: set version = version + 1
894: where plan_id = msc_x_netting_pkg.G_PLAN_ID
895: and exception_type in (11,12,31,32);
896:

Line 1577: update msc_item_exceptions

1573:
1574: CLOSE excepSummary;
1575: IF u_plan_id.COUNT > 0 THEN
1576: FORALL i in 1..u_plan_id.COUNT
1577: update msc_item_exceptions
1578: set exception_count = u_count(i)
1579: where plan_id = u_plan_id(i)
1580: and company_id = u_company_id(i)
1581: and company_site_id = u_company_site_id(i)