DBA Data[Home] [Help]

APPS.MSC_X_NETTING1_PKG dependencies on MSC_ITEM_EXCEPTIONS

Line 1409: And archive the msc_item_exceptions

1405: is exist, then no need to send notification and reset
1406: version = null. If the exception detail not exist, create
1407: a new exception detail and send the notification.
1408: Set version = 'CURRENT'
1409: And archive the msc_item_exceptions
1410: =====================================================*/
1411:
1412: update msc_x_exception_details
1413: set version = 'X'

Line 1417: update msc_item_exceptions

1413: set version = 'X'
1414: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1415: and exception_type in (3,4);
1416:
1417: update msc_item_exceptions
1418: set version = version + 1
1419: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1420: and exception_type in (3,4);
1421:

Line 1839: update msc_item_exceptions

1835:
1836: CLOSE excepSummary;
1837: IF u_plan_id.COUNT > 0 THEN
1838: FORALL i in 1..u_plan_id.COUNT
1839: update msc_item_exceptions
1840: set exception_count = u_count(i)
1841: where plan_id = u_plan_id(i)
1842: and company_id = u_company_id(i)
1843: and company_site_id = u_company_site_id(i)