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_AR_TRX_LINES_PKG dependencies on JAI_AR_TRXS

Line 135: FROM JAI_AR_TRXS

131: WHERE customer_trx_id = v_header_id;
132:
133: CURSOR localization_header_info_cur IS
134: SELECT organization_id
135: FROM JAI_AR_TRXS
136: WHERE customer_trx_id = v_header_id;
137: BEGIN
138: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
139: FND_LOG.STRING(G_LEVEL_PROCEDURE,

Line 274: Update JAI_AR_TRXS

270: IF PV_RETURN_CODE <> JAI_CONSTANTS.successful THEN
271: RAISE le_error;
272: END IF;
273:
274: Update JAI_AR_TRXS
275: Set line_amount = nvl(line_amount, 0) + nvl(v_line_amount, 0)
276: Where Customer_Trx_Id = v_header_id;
277:
278: ELSIF v_line_type in ('FREIGHT', 'TAX') THEN

Line 334: Update JAI_AR_TRXS

330: v_last_updated_by,
331: v_last_update_login);
332:
333: IF rec.tax_type in ('Excise', 'Addl. Excise', 'Other Excise') THEN
334: Update JAI_AR_TRXS
335: Set total_amount = nvl(total_amount, 0) +
336: nvl(pr_new.extended_amount, 0),
337: tax_amount = nvl(tax_amount, 0) +
338: nvl(pr_new.extended_amount, 0)

Line 547: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B

543: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
544:
545: CURSOR organization_cur IS
546: SELECT A.organization_id, location_id
547: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B
548: WHERE A.trx_number = B.recurred_from_trx_number
549: AND B.customer_trx_id = v_header_id;
550:
551: CURSOR CREATED_FROM_CUR IS

Line 560: FROM JAI_AR_TRXS

556: ld_trx_date ra_customer_trx_all.trx_Date%type;
557:
558: CURSOR ONCE_COMPLETE_FLAG_CUR IS
559: SELECT once_completed_flag
560: FROM JAI_AR_TRXS
561: WHERE customer_trx_id = v_header_id;
562:
563: CURSOR ROW_ID_CUR IS
564: SELECT rowid

Line 684: UPDATE JAI_AR_TRXS

680: OPEN old_line_amount_cur;
681: FETCH old_line_amount_cur
682: INTO v_old_line_amount;
683: CLOSE old_line_amount_cur;
684: UPDATE JAI_AR_TRXS
685: SET line_amount = nvl(line_amount, 0) -
686: nvl(v_old_line_amount, 0),
687: tax_amount = nvl(tax_amount, 0) - nvl(v_old_tax_tot, 0),
688: total_amount = nvl(total_amount, 0) -

Line 872: UPDATE JAI_AR_TRXS

868: v_tax_tot := nvl(v_excise, 0) + nvl(v_other, 0) +
869: nvl(v_additional, 0);
870: v_tot_amt := nvl(v_line_amount, 0) + nvl(v_total_tax_amount, 0);
871:
872: UPDATE JAI_AR_TRXS
873: SET line_amount = NVL(line_amount, 0) + NVL(v_line_amount, 0),
874: total_amount = NVL(total_amount, 0) + NVL(v_tot_amt, 0),
875: tax_amount = NVL(tax_amount, 0) + NVL(v_total_tax_amount, 0)
876: WHERE JAI_AR_TRXS.customer_trx_id = v_header_id;

Line 876: WHERE JAI_AR_TRXS.customer_trx_id = v_header_id;

872: UPDATE JAI_AR_TRXS
873: SET line_amount = NVL(line_amount, 0) + NVL(v_line_amount, 0),
874: total_amount = NVL(total_amount, 0) + NVL(v_tot_amt, 0),
875: tax_amount = NVL(tax_amount, 0) + NVL(v_total_tax_amount, 0)
876: WHERE JAI_AR_TRXS.customer_trx_id = v_header_id;
877:
878: OPEN c_get_address_details(v_header_id);
879: FETCH c_get_address_details
880: into r_add;

Line 1143: FROM JAI_AR_TRXS

1139: SELECT organization_id FROM JAI_AR_TRX_APPS_RELS_T;
1140:
1141: CURSOR organization_cur IS
1142: SELECT organization_id
1143: FROM JAI_AR_TRXS
1144: WHERE trx_number =
1145: (SELECT recurred_from_trx_number
1146: FROM RA_CUSTOMER_TRX_ALL
1147: WHERE customer_trx_id = v_header_id);

Line 1302: UPDATE JAI_AR_TRXS

1298: END LOOP;
1299: v_tax_tot := v_excise + v_other + v_additional;
1300: v_tot_amt := v_line_amount + v_tax_tot;
1301:
1302: UPDATE JAI_AR_TRXS
1303: SET line_amount = NVL(line_amount, 0) + NVL(v_line_amount, 0) -
1304: NVL(v_old_amount, 0),
1305: total_amount = NVL(total_amount, 0) + NVL(v_tot_amt, 0) -
1306: nvl(v_old_amount, 0) - NVL(v_old_tax_tot, 0),

Line 1394: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;

1390: le_error EXCEPTION;
1391: --Added by Zhiwei for JAI Trigger elimination begin
1392: ---------------------------------------------------------
1393: cursor c_get_rec(cn_customer_trx_id number) is
1394: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1395:
1396: t_rec_new jai_ar_trxs%rowtype;
1397: t_rec_old jai_ar_trxs%rowtype;
1398:

Line 1396: t_rec_new jai_ar_trxs%rowtype;

1392: ---------------------------------------------------------
1393: cursor c_get_rec(cn_customer_trx_id number) is
1394: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1395:
1396: t_rec_new jai_ar_trxs%rowtype;
1397: t_rec_old jai_ar_trxs%rowtype;
1398:
1399: ---------------------------------------------------------
1400: --Added by Zhiwei for JAI Trigger elimination end

Line 1397: t_rec_old jai_ar_trxs%rowtype;

1393: cursor c_get_rec(cn_customer_trx_id number) is
1394: select * from jai_ar_trxs where customer_trx_id = cn_customer_trx_id;
1395:
1396: t_rec_new jai_ar_trxs%rowtype;
1397: t_rec_old jai_ar_trxs%rowtype;
1398:
1399: ---------------------------------------------------------
1400: --Added by Zhiwei for JAI Trigger elimination end
1401:

Line 1491: FROM JAI_AR_TRXS

1487: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
1488:
1489: CURSOR organization_cur IS
1490: SELECT organization_id, location_id
1491: FROM JAI_AR_TRXS
1492: WHERE trx_number =
1493: (SELECT recurred_from_trx_number
1494: FROM RA_CUSTOMER_TRX_ALL
1495: WHERE customer_trx_id = v_header_id);

Line 1504: FROM JAI_AR_TRXS

1500: WHERE customer_trx_id = v_header_id;
1501:
1502: CURSOR ONCE_COMPLETE_FLAG_CUR IS
1503: SELECT once_completed_flag
1504: FROM JAI_AR_TRXS
1505: WHERE customer_trx_id = v_header_id;
1506:
1507: Cursor transaction_type_cur IS
1508: Select a.type

Line 1696: UPDATE JAI_AR_TRXS

1692:
1693: v_tax_tot := v_excise + v_other + v_additional;
1694: v_tot_amt := v_line_amount + v_tax_tot;
1695:
1696: UPDATE JAI_AR_TRXS
1697: SET line_amount = NVL(line_amount, 0) + NVL(v_line_amount, 0) -
1698: NVL(v_old_amount, 0),
1699: total_amount = NVL(total_amount, 0) + NVL(v_tot_amt, 0) -
1700: nvl(v_old_amount, 0) - NVL(v_old_tax_tot, 0),

Line 1803: FROM JAI_AR_TRXS

1799: AND CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
1800:
1801: CURSOR ONCE_COMPLETE_FLAG_CUR IS
1802: SELECT once_completed_flag
1803: FROM JAI_AR_TRXS
1804: WHERE customer_trx_id = v_customer_trx_id;
1805:
1806: v_trans_type Varchar2(30);
1807:

Line 1840: UPDATE JAI_AR_TRXS

1836: FETCH old_line_amount_cur
1837: INTO v_old_line_amount, v_old_tax_tot;
1838: CLOSE old_line_amount_cur;
1839:
1840: UPDATE JAI_AR_TRXS
1841: SET line_amount = nvl(line_amount, 0) - nvl(v_old_line_amount, 0),
1842: tax_amount = nvl(tax_amount, 0) - nvl(v_old_tax_tot, 0),
1843: total_amount = nvl(total_amount, 0) -
1844: (nvl(v_old_line_amount, 0) + nvl(v_old_tax_tot, 0))

Line 1847: DELETE FROM JAI_AR_TRXS trx

1843: total_amount = nvl(total_amount, 0) -
1844: (nvl(v_old_line_amount, 0) + nvl(v_old_tax_tot, 0))
1845: WHERE customer_trx_id = v_customer_trx_id;
1846:
1847: DELETE FROM JAI_AR_TRXS trx
1848: WHERE customer_trx_id = v_customer_trx_id
1849: AND EXISTS (SELECT 1
1850: FROM ra_interface_lines_all il
1851: WHERE il.customer_trx_id = v_customer_trx_id