APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_AR_TRXS

Line 221: FROM JAI_AR_TRXS

217:
218: CURSOR SO_AR_HDR_INFO IS
219: SELECT organization_id, location_id, batch_source_id /*uncommented for bug#8775345*/
220: -- SELECT batch_source_id
221: FROM JAI_AR_TRXS
222: WHERE Customer_Trx_ID = v_customer_trx_id;
223:
224:
225: --cursor added for bug 8775345

Line 228: FROM JAI_AR_TRXS

224:
225: --cursor added for bug 8775345
226: CURSOR get_batch_src_id IS
227: SELECT batch_source_id
228: FROM JAI_AR_TRXS
229: WHERE Customer_Trx_ID = v_customer_trx_id;
230:
231:
232: --start additions for bug#7661892

Line 385: FROM JAI_AR_TRXS

381: lv_enable_gst_flag VARCHAR2(1);
382: CURSOR get_gst_organization_location(cn_customer_trx_id IN NUMBER)--v_customer_trx_line_id
383: IS
384: SELECT ORGANIZATION_ID,LOCATION_ID
385: FROM JAI_AR_TRXS
386: WHERE CUSTOMER_TRX_ID = cn_customer_trx_id;
387: lv_log VARCHAR2(1000);
388: x number;
389: CURSOR GET_COUNT(cn_customer_trx_line_id IN NUMBER)is

Line 1465: FROM JAI_AR_TRXS

1461: lv_enable_gst_flag VARCHAR2(1);
1462: CURSOR get_gst_organization_location(cn_customer_trx_id IN NUMBER)--v_customer_trx_line_id
1463: IS
1464: SELECT ORGANIZATION_ID,LOCATION_ID
1465: FROM JAI_AR_TRXS
1466: WHERE CUSTOMER_TRX_ID = cn_customer_trx_id;
1467:
1468: lv_log VARCHAR2(1000);
1469: x number;

Line 1513: FROM JAI_AR_TRXS

1509: */
1510:
1511: CURSOR BOOKS_TRX_CUR IS
1512: SELECT set_of_books_id, primary_salesrep_id, invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
1513: FROM JAI_AR_TRXS
1514: WHERE customer_trx_id = v_customer_trx_id;
1515:
1516:
1517: --Commented for bug#4468353

Line 1557: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636

1553: WHERE CUSTOMER_TRX_LINE_ID = pr_old.customer_trx_line_id;
1554:
1555: CURSOR CREATED_FROM_CUR IS
1556: SELECT created_from
1557: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636
1558: WHERE customer_trx_id = v_customer_trx_id;
1559:
1560: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
1561: SELECT INSERT_UPDATE_FLAG

Line 1569: FROM JAI_AR_TRXS

1565: ORDER BY CUSTOMER_TRX_LINE_ID;
1566:
1567: CURSOR SO_AR_HDR_INFO IS
1568: SELECT organization_id, location_id, batch_source_id
1569: FROM JAI_AR_TRXS
1570: WHERE Customer_Trx_ID = v_customer_trx_id;
1571:
1572: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
1573: SELECT register_code

Line 1668: with unhandled exception.This has been changed to point to JAI_AR_TRXS

1664: only if is a manual invoice.
1665: 7. 2003/01/02 Ssumaith Bug # 2728636 File Version 615.2
1666: Reference to table RA_CUSTOMER_TRX_ALL was present in the cursor Created_from_cur
1667: Which was causing a mutating error and causing the transaction to error out
1668: with unhandled exception.This has been changed to point to JAI_AR_TRXS
1669: table instead which takes care of the issue.
1670: 8. 2003/04/07 SSUMAITH.Bug # 2779967
1671: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
1672: inserted in the table , because when processing the records using the 'India Local Concurrent'

Line 2509: FROM JAI_AR_TRXS

2505: fetch bind_cur into l_org_id, l_bill_to_customer_id, l_bill_to_site_use_id, ln_trx_date;
2506: close bind_cur;
2507:
2508: SELECT organization_id into ln_organization_id
2509: FROM JAI_AR_TRXS
2510: WHERE customer_trx_id = pr_new.customer_trx_id;
2511:
2512: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2513: ( p_regime_id => ln_tcs_regime_id