APPS.MSC_X_NETTING3_PKG dependencies on MSC_PMF_PKG

Line 39: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP11,

35: sd.supplier_site_name,
36: sd.supplier_item_name,
37: sd.supplier_item_description,
38: sd.creation_date,
39: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP11,
40: sd.supplier_id,
41: sd.supplier_site_id,
42: sd.inventory_item_id,
43: null,

Line 48: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP31,

44: null,
45: sd.publisher_id,
46: sd.publisher_site_id,
47: sd.key_date),
48: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP31,
49: sd.publisher_id,
50: sd.publisher_site_id,
51: sd.inventory_item_id,
52: sd.supplier_id,

Line 109: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP12,

105: sd.customer_site_name,
106: sd.customer_item_name,
107: sd.customer_item_description,
108: sd.creation_date ,
109: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP12,
110: sd.publisher_id,
111: sd.publisher_site_id,
112: sd.inventory_item_id,
113: null,

Line 118: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP32,

114: null,
115: sd.customer_id,
116: sd.customer_site_id,
117: sd.key_date),
118: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP32,
119: sd.customer_id,
120: sd.customer_site_id,
121: sd.inventory_item_id,
122: sd.publisher_id,

Line 281: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,

277: sd2.order_number,
278: sd2.release_number,
279: sd2.line_number,
280: sd2.creation_date,
281: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,
282: sd1.publisher_id,
283: sd1.publisher_site_id,
284: sd1.inventory_item_id,
285: sd1.supplier_id,

Line 309: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,

305: nvl(sd2.end_order_rel_number,-1)
306: AND nvl(sd1.line_number,-1) =
307: nvl(sd2.end_order_line_number,-1)
308: AND trunc(sd2.key_date) > trunc(sd1.key_date) +
309: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,
310: sd1.publisher_id,
311: sd1.publisher_site_id,
312: sd1.inventory_item_id,
313: sd1.supplier_id,

Line 2329: l_threshold50 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP50,

2325: b_supplier_id(j-1) <> b_supplier_id(j) or
2326: b_supplier_site_id(j-1) <> b_supplier_site_id(j) or
2327: b_item_id(j-1) <> b_item_id(j) ) THEN
2328:
2329: l_threshold50 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP50,
2330: b_customer_id(j),
2331: b_customer_site_id(j),
2332: b_item_id(j),
2333: b_supplier_id(j),

Line 2339: l_threshold51 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP51,

2335: null,
2336: null,
2337: b_po_key_date(j));
2338:
2339: l_threshold51 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP51,
2340: b_customer_id(j),
2341: b_customer_site_id(j),
2342: b_item_id(j),
2343: b_supplier_id(j),

Line 3368: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP14,

3364: b_publisher_site_id(j-1) <> b_publisher_site_id(j) or
3365: b_supplier_id(j-1) <> b_supplier_id(j) or
3366: b_supplier_site_id(j-1) <> b_supplier_site_id(j) or
3367: b_item_id(j-1) <> b_item_id(j) ) THEN
3368: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP14,
3369: b_publisher_id(j),
3370: b_publisher_site_id(j),
3371: b_item_id(j),
3372: b_supplier_id(j),

Line 3705: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP16,

3701: b_publisher_site_id(j-1) <> b_publisher_site_id(j) or
3702: b_customer_id(j-1) <> b_customer_id(j) or
3703: b_customer_site_id(j-1) <> b_customer_site_id(j) or
3704: b_item_id(j-1) <> b_item_id(j) ) THEN
3705: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP16,
3706: b_publisher_id(j),
3707: b_publisher_site_id(j),
3708: b_item_id(j),
3709: null,