eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_NETTING1_PKG dependencies on MSC_PMF_PKG

Line 174: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP3, --exception type

170: sd1.supplier_site_name,
171: sd1.supplier_item_name,
172: sd1.supplier_item_description,
173: sd1.creation_date,
174: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP3, --exception type
175: sd1.supplier_id, --p_company_id
176: sd1.supplier_site_id, --p_company_site_id
177: sd1.inventory_item_id, --p_inventory_item_id
178: null, --p_supplier_company_id

Line 183: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP4,

179: null, --p_supplier_company_site_id
180: sd1.publisher_id, --p_customer_company_id
181: sd1.publisher_site_id, --p_customer_company_site_id
182: sd1.key_date),
183: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP4,
184: sd1.publisher_id,
185: sd1.publisher_site_id,
186: sd1.inventory_item_id,
187: sd1.supplier_id,

Line 683: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP1,

679: t_trxid2_list,
680: t_date1_list,
681: t_date2_list);
682:
683: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP1,
684: b_publisher_id(j),
685: b_publisher_site_id(j),
686: b_item_id(j),
687: null,

Line 871: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP2,

867: ------------------------------------------------
868: if (b_po_last_refnum(j) <= p_refresh_number) then
869: --detected exception 1.2
870:
871: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP2,
872: b_customer_id(j),
873: b_customer_site_id(j),
874: b_item_id(j),
875: b_publisher_id(j),

Line 1104: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP2,

1100: t_date1_list,
1101: t_date2_list);
1102:
1103:
1104: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP2,
1105: b_publisher_id(j),
1106: b_publisher_site_id(j),
1107: b_item_id(j),
1108: b_supplier_id(j),

Line 1286: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP1,

1282: -- generate complement exception
1283: -----------------------------------------------
1284: if (b_so_last_refnum(j) <= p_refresh_number) then
1285: --dbms_output.put_line('There is complement exception for ex2');
1286: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP1,
1287: b_supplier_id(j),
1288: b_supplier_site_id(j),
1289: b_item_id(j),
1290: null,

Line 2119: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP23,

2115: t_date1_list,
2116: t_date2_list);
2117:
2118:
2119: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP23,
2120: b_publisher_id(j),
2121: b_publisher_site_id(j),
2122: b_item_id(j),
2123: null,

Line 2306: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP24,

2302:
2303: IF (b_po_last_refnum(j) <= p_refresh_number) then
2304: --detected exception 1.2
2305: --dbms_output.put_line('There is complement exception for ex23');
2306: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP24,
2307: b_customer_id(j),
2308: b_customer_site_id(j),
2309: b_item_id(j),
2310: b_publisher_id(j),

Line 2533: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP24,

2529: t_trxid2_list,
2530: t_date1_list,
2531: t_date2_list);
2532:
2533: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP24,
2534: b_publisher_id(j),
2535: b_publisher_site_id(j),
2536: b_item_id(j),
2537: b_supplier_id(j),

Line 2715: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP23,

2711: -- generate complement exception
2712: ----------------------------------------------------
2713: if (b_so_last_refnum(j) <= p_refresh_number) then
2714: --dbms_output.put_line('There is complement exception for ex23');
2715: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP23,
2716: b_supplier_id(j),
2717: b_supplier_site_id(j),
2718: b_item_id(j),
2719: null,

Line 3085: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP19,

3081: t_date2_list);
3082:
3083:
3084:
3085: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP19,
3086: b_publisher_id(j),
3087: b_publisher_site_id(j),
3088: b_item_id(j),
3089: null,

Line 3094: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP20,

3090: null,
3091: b_customer_id(j),
3092: b_customer_site_id(j),
3093: null);
3094: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP20,
3095: b_publisher_id(j),
3096: b_publisher_site_id(j),
3097: b_item_id(j),
3098: null,

Line 3354: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP22,

3350: l_inserted_record := l_inserted_record + 1;
3351:
3352: if l_generate_complement then
3353: --dbms_output.put_line('in 19 complement');
3354: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP22,
3355: b_customer_id(j),
3356: b_customer_site_id(j),
3357: b_item_id(j),
3358: b_publisher_id(j),

Line 3625: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP21,

3621: a_exception_basis);
3622: l_inserted_record := l_inserted_record + 1;
3623:
3624: if l_generate_complement then
3625: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP21,
3626: b_customer_id(j),
3627: b_customer_site_id(j),
3628: b_item_id(j),
3629: b_publisher_id(j),

Line 3856: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP21,

3852: t_date1_list,
3853: t_date2_list);
3854:
3855:
3856: l_threshold1 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP21,
3857: b_publisher_id(j),
3858: b_publisher_site_id(j),
3859: b_item_id(j),
3860: b_supplier_id(j),

Line 3865: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP22,

3861: b_supplier_site_id(j),
3862: null,
3863: null,
3864: null);
3865: l_threshold2 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP22,
3866: b_publisher_id(j),
3867: b_publisher_site_id(j),
3868: b_item_id(j),
3869: b_supplier_id(j),

Line 4126: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP19,

4122: a_exception_basis);
4123: l_inserted_record := l_inserted_record + 1;
4124: if l_generate_complement then
4125: --dbms_output.put_line('In complement exception 22');
4126: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP19,
4127: b_supplier_id(j),
4128: b_supplier_site_id(j),
4129: b_item_id(j),
4130: null,

Line 4400: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP20,

4396: l_inserted_record := l_inserted_record + 1;
4397:
4398: if l_generate_complement then
4399: --dbms_output.put_line('In complement exception 21');
4400: l_complement_threshold:= msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP20,
4401: b_supplier_id(j),
4402: b_supplier_site_id(j),
4403: b_item_id(j),
4404: null,