APPS.MSC_X_NETTING1_PKG dependencies on MSC_X_EXCEPTION_DETAILS

Line 465: from msc_x_exception_details

461: company_site_id,
462: exception_group,
463: exception_type,
464: count(*)
465: from msc_x_exception_details
466: where plan_id =msc_x_netting_pkg.G_PLAN_ID
467: and version = 'X'
468: and exception_type in (3,4)
469: group by plan_id,

Line 540: l_exception_basis msc_x_exception_details.exception_basis%type;

536: l_item_type Varchar2(20);
537: l_item_key Varchar2(100);
538: l_row Number;
539: l_shipping_control Number;
540: l_exception_basis msc_x_exception_details.exception_basis%type;
541: l_inserted_record Number;
542:
543:
544: --------------------------------------------------------

Line 1412: update msc_x_exception_details

1408: Set version = 'CURRENT'
1409: And archive the msc_item_exceptions
1410: =====================================================*/
1411:
1412: update msc_x_exception_details
1413: set version = 'X'
1414: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1415: and exception_type in (3,4);
1416:

Line 1519: update msc_x_exception_details

1515: IF (l_exception_detail_id1 > 0) THEN --detail already exist
1516:
1517: --dbms_output.put_line('----Detail exist for trx_id '||b_trx_id1(j));
1518: --reset version=null indicate no need to resend notification
1519: update msc_x_exception_details
1520: set version = null,
1521: date1 = b_po_receipt_date(j),
1522: date2 = b_po_ship_date(j),
1523: number1 = b_tp_po_qty(j)

Line 1683: update msc_x_exception_details

1679: IF (l_exception_detail_id2 > 0) THEN --detail already exist
1680:
1681: --dbms_output.put_line('----Detail exist for trx_id '||b_trx_id1(j));
1682: --reset version=null indicate no need to resend notification
1683: update msc_x_exception_details
1684: set version = null,
1685: date1 = b_po_receipt_date(j),
1686: date2 = b_po_ship_date(j),
1687: number1 = b_po_qty(j)

Line 1805: --The old exceptions with version = 'X' in msc_x_exception_details table

1801:
1802: --===========================================================================================
1803: --Archive all the exception notifications sent out in previous engine runs
1804: --and are not re-occurr in this run
1805: --The old exceptions with version = 'X' in msc_x_exception_details table
1806: --=======================================================================================
1807: BEGIN
1808: delete msc_x_exception_details
1809: where plan_id = msc_x_netting_pkg.G_PLAN_ID

Line 1808: delete msc_x_exception_details

1804: --and are not re-occurr in this run
1805: --The old exceptions with version = 'X' in msc_x_exception_details table
1806: --=======================================================================================
1807: BEGIN
1808: delete msc_x_exception_details
1809: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1810: and exception_type in (3,4)
1811: and version = 'X';
1812:

Line 1997: l_exception_basis msc_x_exception_details.exception_basis%type;

1993: l_exception_exists Number;
1994: l_so_exist Number;
1995: l_row Number;
1996: l_shipping_control Number;
1997: l_exception_basis msc_x_exception_details.exception_basis%type;
1998: l_inserted_record Number;
1999:
2000: BEGIN
2001:

Line 2970: l_exception_basis msc_x_exception_details.exception_basis%type;

2966: l_exception_type_name fnd_lookup_values.meaning%type;
2967: l_exception_group_name fnd_lookup_values.meaning%type;
2968: l_sum Number;
2969: l_shipping_control Number;
2970: l_exception_basis msc_x_exception_details.exception_basis%type;
2971: l_inserted_record Number;
2972:
2973: BEGIN
2974: l_sum := 0;