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.JAI_AP_ST_REVERSE_PROCESS dependencies on PO_LINES_ALL

Line 3568: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;

3564: ln_source VARCHAR2(50);
3565:
3566: ln_precision fnd_currencies.precision%type; -- added by sssumaith - bug# 3127834
3567: ln_tax_precision jai_cmn_taxes_all.rounding_factor%type;
3568: v_po_unit_meas_lookup_code po_lines_all.unit_meas_lookup_code%type;
3569: r_tax_lines_rec r_tax_lines_cur%ROWTYPE;
3570: /* r_cur_items_rec r_cur_items%ROWTYPE; Bug#4095234*/
3571: vPoUomCode mtl_units_of_measure.unit_of_measure%TYPE;
3572: vReceiptUomCode mtl_units_of_measure.unit_of_measure%TYPE;

Line 3662: cursor c_po_lines_all(p_po_line_id number) is

3658: from rcv_transactions
3659: where transaction_id = p_transaction_id;
3660:
3661:
3662: cursor c_po_lines_all(p_po_line_id number) is
3663: select item_id
3664: from po_lines_all
3665: where po_line_id = p_po_line_id;
3666:

Line 3664: from po_lines_all

3660:
3661:
3662: cursor c_po_lines_all(p_po_line_id number) is
3663: select item_id
3664: from po_lines_all
3665: where po_line_id = p_po_line_id;
3666:
3667: /* Bug 5358788. Added by Lakshmi Gopalsami
3668: * Added parameter cp_regime_code instead of

Line 3688: r_po_lines_all c_po_lines_all%rowtype;

3684: and attribute_code = cp_tax_type;
3685:
3686:
3687: r_rcv_transactions c_rcv_transactions%rowtype;
3688: r_po_lines_all c_po_lines_all%rowtype;
3689: r_jai_regimes c_jai_regimes%rowtype;
3690: r_service_regime_tax_type c_regime_tax_type%rowtype;
3691: lv_is_item_an_expense varchar2(20); /* Service */
3692: lv_accounting_method_option varchar2(20); /* Service */

Line 4052: open c_po_lines_all(from_po_distributions_rec.po_line_id);

4048: FETCH from_po_distributions INTO from_po_distributions_rec;
4049: CLOSE from_po_distributions;
4050:
4051:
4052: open c_po_lines_all(from_po_distributions_rec.po_line_id);
4053: fetch c_po_lines_all into r_po_lines_all;
4054: close c_po_lines_all;
4055:
4056: lv_is_item_an_expense := null;

Line 4053: fetch c_po_lines_all into r_po_lines_all;

4049: CLOSE from_po_distributions;
4050:
4051:
4052: open c_po_lines_all(from_po_distributions_rec.po_line_id);
4053: fetch c_po_lines_all into r_po_lines_all;
4054: close c_po_lines_all;
4055:
4056: lv_is_item_an_expense := null;
4057: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense

Line 4054: close c_po_lines_all;

4050:
4051:
4052: open c_po_lines_all(from_po_distributions_rec.po_line_id);
4053: fetch c_po_lines_all into r_po_lines_all;
4054: close c_po_lines_all;
4055:
4056: lv_is_item_an_expense := null;
4057: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4058: (

Line 4060: p_item_id => r_po_lines_all.item_id

4056: lv_is_item_an_expense := null;
4057: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4058: (
4059: p_organization_id => r_rcv_transactions.organization_id,
4060: p_item_id => r_po_lines_all.item_id
4061: );
4062:
4063: /*lv_accounting_method_option := jai_general_pkg.get_accounting_method
4064: (

Line 4207: 'ln_ship_to_organization_id='||ln_ship_to_organization_id ||', r_po_lines_all.item_id='||r_po_lines_all.item_id

4203: close c_get_ship_to_org_loc;
4204:
4205:
4206: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
4207: 'ln_ship_to_organization_id='||ln_ship_to_organization_id ||', r_po_lines_all.item_id='||r_po_lines_all.item_id
4208: );
4209: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4210: (
4211: p_organization_id => ln_ship_to_organization_id,

Line 4212: p_item_id => r_po_lines_all.item_id

4208: );
4209: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4210: (
4211: p_organization_id => ln_ship_to_organization_id,
4212: p_item_id => r_po_lines_all.item_id
4213: );
4214:
4215: if r_service_regime_tax_type.tax_type is not null then
4216: /* Service type of tax */

Line 4777: 'ln_ship_to_organization_id='||ln_ship_to_organization_id ||', r_po_lines_all.item_id='||r_po_lines_all.item_id

4773: close c_get_ship_to_org_loc;
4774:
4775:
4776: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_STATEMENT, GV_MODULE_PREFIX || '.' || l_api_name,
4777: 'ln_ship_to_organization_id='||ln_ship_to_organization_id ||', r_po_lines_all.item_id='||r_po_lines_all.item_id
4778: );
4779: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4780: (
4781: p_organization_id => ln_ship_to_organization_id,

Line 4782: p_item_id => r_po_lines_all.item_id

4778: );
4779: lv_is_item_an_expense := jai_general_pkg.is_item_an_expense
4780: (
4781: p_organization_id => ln_ship_to_organization_id,
4782: p_item_id => r_po_lines_all.item_id
4783: );
4784:
4785:
4786: if r_service_regime_tax_type.tax_type is not null then

Line 5724: cursor c_po_lines_all(p_po_line_id number) is

5720: select po_line_id, organization_id
5721: from rcv_transactions
5722: where transaction_id = p_transaction_id;
5723:
5724: cursor c_po_lines_all(p_po_line_id number) is
5725: select item_id
5726: from po_lines_all
5727: where po_line_id = p_po_line_id;
5728:

Line 5726: from po_lines_all

5722: where transaction_id = p_transaction_id;
5723:
5724: cursor c_po_lines_all(p_po_line_id number) is
5725: select item_id
5726: from po_lines_all
5727: where po_line_id = p_po_line_id;
5728:
5729: /* Bug 5358788. Added by Lakshmi Gopalsami
5730: * Added parameter cp_regime_code instead of

Line 5757: r_po_lines_all c_po_lines_all%rowtype;

5753: where tax_id = cp_tax_id ;
5754: /*End, Added by kunkumar for bug#5593895*/
5755:
5756: r_rcv_transactions c_rcv_transactions%rowtype;
5757: r_po_lines_all c_po_lines_all%rowtype;
5758: r_jai_regimes c_jai_regimes%rowtype;
5759: r_service_regime_tax_type c_regime_tax_type%rowtype;
5760: lv_is_item_an_expense varchar2(20); /* Service */
5761: lv_accounting_method_option varchar2(20); /* Service */

Line 5964: open c_po_lines_all(po_dist_id);

5960: open c_rcv_transactions(rcv_tran_id);
5961: fetch c_rcv_transactions into r_rcv_transactions;
5962: close c_rcv_transactions;
5963:
5964: open c_po_lines_all(po_dist_id);
5965: fetch c_po_lines_all into r_po_lines_all;
5966: close c_po_lines_all;
5967:
5968: lv_is_item_an_expense :=

Line 5965: fetch c_po_lines_all into r_po_lines_all;

5961: fetch c_rcv_transactions into r_rcv_transactions;
5962: close c_rcv_transactions;
5963:
5964: open c_po_lines_all(po_dist_id);
5965: fetch c_po_lines_all into r_po_lines_all;
5966: close c_po_lines_all;
5967:
5968: lv_is_item_an_expense :=
5969: jai_general_pkg.is_item_an_expense

Line 5966: close c_po_lines_all;

5962: close c_rcv_transactions;
5963:
5964: open c_po_lines_all(po_dist_id);
5965: fetch c_po_lines_all into r_po_lines_all;
5966: close c_po_lines_all;
5967:
5968: lv_is_item_an_expense :=
5969: jai_general_pkg.is_item_an_expense
5970: (

Line 5972: p_item_id => r_po_lines_all.item_id

5968: lv_is_item_an_expense :=
5969: jai_general_pkg.is_item_an_expense
5970: (
5971: p_organization_id => r_rcv_transactions.organization_id,
5972: p_item_id => r_po_lines_all.item_id
5973: );
5974:
5975: lv_accrue_on_receipt_flag :=
5976: jai_rcv_trx_processing_pkg.get_accrue_on_receipt(p_po_distribution_id => po_dist_id);