DBA Data[Home] [Help]

APPS.MSC_X_NETTING2_PKG dependencies on MSC_PMF_PKG

Line 1053: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP5,

1049: t_trxid2_list,
1050: t_date1_list,
1051: t_date2_list);
1052:
1053: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP5,
1054: b_publisher_id(j),
1055: b_publisher_site_id(j),
1056: b_item_id(j),
1057: null,

Line 1659: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP6,

1655: t_date1_list,
1656: t_date2_list);
1657:
1658:
1659: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP6,
1660: b_publisher_id(j),
1661: b_publisher_site_id(j),
1662: b_item_id(j),
1663: b_supplier_id(j),

Line 2281: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP7,

2277: t_trxid2_list,
2278: t_date1_list,
2279: t_date2_list);
2280:
2281: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP7,
2282: b_publisher_id(j),
2283: b_publisher_site_id(j),
2284: b_item_id(j),
2285: null,

Line 2640: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP8,

2636: l_inserted_record := l_inserted_record + 1;
2637:
2638: if (b_po_last_refnum(j) <= p_refresh_number) then
2639: --dbms_output.put_line('In complement exception7 ');
2640: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP8,
2641: b_customer_id(j),
2642: b_customer_site_id(j),
2643: b_item_id(j),
2644: b_publisher_id(j),

Line 2871: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP8,

2867: t_date1_list,
2868: t_date2_list);
2869:
2870:
2871: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP8,
2872: b_publisher_id(j),
2873: b_publisher_site_id(j),
2874: b_item_id(j),
2875: b_supplier_id(j),

Line 3236: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP7,

3232:
3233: if (b_so_last_refnum(j) <= p_refresh_number) then
3234: --dbms_output.put_line('In complement 8');
3235:
3236: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP7,
3237: b_supplier_id(j),
3238: b_supplier_site_id(j),
3239: b_item_id(j),
3240: null,

Line 3615: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP25,

3611: t_date1_list,
3612: t_date2_list);
3613:
3614:
3615: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP25,
3616: b_publisher_id(j),
3617: b_publisher_site_id(j),
3618: b_item_id(j),
3619: null,

Line 4218: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP26,

4214: t_date1_list,
4215: t_date2_list);
4216:
4217:
4218: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP26,
4219: b_publisher_id(j),
4220: b_publisher_site_id(j),
4221: b_item_id(j),
4222: b_supplier_id(j),

Line 4846: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP27,

4842: t_date1_list,
4843: t_date2_list);
4844:
4845:
4846: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP27,
4847: b_publisher_id(j),
4848: b_publisher_site_id(j),
4849: b_item_id(j),
4850: null,

Line 5212: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP28,

5208: -------------------------------------------------
5209: if (b_po_last_refnum(j) <= p_refresh_number) then
5210: --dbms_output.put_line('In complement 27');
5211:
5212: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP28,
5213: b_customer_id(j),
5214: b_customer_site_id(j),
5215: b_item_id(j),
5216: b_publisher_id(j),

Line 5446: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP28,

5442: t_date1_list,
5443: t_date2_list);
5444:
5445:
5446: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP28,
5447: b_publisher_id(j),
5448: b_publisher_site_id(j),
5449: b_item_id(j),
5450: b_supplier_id(j),

Line 5815: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP27,

5811: if (b_so_last_refnum(j) <= p_refresh_number) then
5812: --dbms_output.put_line('In complement28');
5813:
5814: --dbms_output.put_line('generate complement ex');
5815: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP27,
5816: b_supplier_id(j),
5817: b_supplier_site_id(j),
5818: b_item_id(j),
5819: null,