APPS.MSC_X_NETTING4_PKG dependencies on MSC_ITEM_EXCEPTIONS

Line 950: update msc_item_exceptions

946:
947: l_row := SQL%ROWCOUNT;
948: ----dbms_output.put_line('detail row delete ' || l_row);
949:
950: update msc_item_exceptions
951: set exception_count = exception_count - l_row,
952: last_update_date = sysdate
953: where plan_id = msc_x_netting_pkg.G_PLAN_ID
954: and exception_type = 33

Line 1783: update msc_item_exceptions

1779: delete msc_x_exception_details
1780: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1781: and exception_type in (35,36);
1782:
1783: update msc_item_exceptions
1784: set version = version + 1,
1785: last_update_date = sysdate
1786: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1787: and exception_type in (35,36);

Line 2285: update msc_item_exceptions

2281: delete msc_x_exception_details
2282: where plan_id = msc_x_netting_pkg.G_PLAN_ID
2283: and exception_type in (39,40,43,44,45,46,47,48);
2284:
2285: update msc_item_exceptions
2286: set version = version + 1,
2287: last_update_date = sysdate
2288: where plan_id = msc_x_netting_pkg.G_PLAN_ID
2289: and exception_type in (39,40,43,44,45,46,47,48);