DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_TRX_INS_LINES_T

Line 1269: || Check whether the JAI_AR_TRX_INS_LINES_T table still has the row corresponding to the current

1265:
1266: -- Start of bug 4185033
1267: /*
1268: || Cursor added by aiyer for the bug 4185033
1269: || Check whether the JAI_AR_TRX_INS_LINES_T table still has the row corresponding to the current
1270: || customer_trx_id
1271: */
1272: CURSOR cur_chk_temp_lines_exist( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE ) /* changed the RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE for the bug 5364288 */
1273: IS

Line 1277: JAI_AR_TRX_INS_LINES_T

1273: IS
1274: SELECT
1275: 1
1276: FROM
1277: JAI_AR_TRX_INS_LINES_T
1278: WHERE
1279: customer_trx_id = cp_customer_trx_id ;
1280:
1281: -- End of bug 4185033

Line 2695: INSERT INTO JAI_AR_TRX_INS_LINES_T ( paddr,

2691: TAX_TYPE_REC.tax_amt := 0;
2692: END IF;
2693:
2694:
2695: INSERT INTO JAI_AR_TRX_INS_LINES_T ( paddr,
2696: extended_amount,
2697: customer_trx_line_id,
2698: customer_trx_id,
2699: set_of_books_id,