[Home] [Help]
122: FROM ra_customer_trx_all
123: WHERE customer_trx_id = v_customer_trx_id;
124: CURSOR SO_AR_HDR_INFO IS
125: SELECT organization_id, location_id, batch_source_id
126: FROM JAI_AR_TRXS
127: WHERE Customer_Trx_ID = v_customer_trx_id;
128: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER,
129: p_batch_source_id IN NUMBER) IS
130: SELECT register_code
912: */
913:
914: CURSOR BOOKS_TRX_CUR IS
915: SELECT set_of_books_id, primary_salesrep_id, invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
916: FROM JAI_AR_TRXS
917: WHERE customer_trx_id = v_customer_trx_id;
918:
919:
920: --Commented for bug#4468353
956: WHERE CUSTOMER_TRX_LINE_ID = pr_old.customer_trx_line_id;
957:
958: CURSOR CREATED_FROM_CUR IS
959: SELECT created_from
960: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636
961: WHERE customer_trx_id = v_customer_trx_id;
962:
963: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
964: SELECT INSERT_UPDATE_FLAG
968: ORDER BY CUSTOMER_TRX_LINE_ID;
969:
970: CURSOR SO_AR_HDR_INFO IS
971: SELECT organization_id, location_id, batch_source_id
972: FROM JAI_AR_TRXS
973: WHERE Customer_Trx_ID = v_customer_trx_id;
974:
975: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
976: SELECT register_code
1043: only if is a manual invoice.
1044: 7. 2003/01/02 Ssumaith Bug # 2728636 File Version 615.2
1045: Reference to table RA_CUSTOMER_TRX_ALL was present in the cursor Created_from_cur
1046: Which was causing a mutating error and causing the transaction to error out
1047: with unhandled exception.This has been changed to point to JAI_AR_TRXS
1048: table instead which takes care of the issue.
1049: 8. 2003/04/07 SSUMAITH.Bug # 2779967
1050: column Org id was not inserted in the JAI_AR_TRX_INS_LINES_T table. This needs to be
1051: inserted in the table , because when processing the records using the 'India Local Concurrent'