[Home] [Help]
36: v_location_id NUMBER ;
37: v_batch_source_id NUMBER ;
38: v_register_code VARCHAR2(50);
39: v_order_number VARCHAR2(30);
40: v_order_type ra_customer_trx_all.interface_header_attribute2%type;
41: v_org_id NUMBER(15); -- added by sriram because the orgid value is not going into temp_lines_insert table
42:
43: --v_ORDER_PRICE_EXCISE_INCLUSIVE JAI_CMN_INVENTORY_ORGS.ORDER_PRICE_EXCISE_INCLUSIVE%type; ---- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22, TD18
44:
43: --v_ORDER_PRICE_EXCISE_INCLUSIVE JAI_CMN_INVENTORY_ORGS.ORDER_PRICE_EXCISE_INCLUSIVE%type; ---- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22, TD18
44:
45: ln_inv_curr_precision NUMBER; /* added by CSahoo - bug# 5364120*/
46: --commented by kunkumar for bug#6066813
47: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type; /* bug# 6012570 (5876390) */
48:
49: /* added by CSahoo - bug# 5364120*/
50: CURSOR c_inv_curr_precision(cp_currency_code varchar2)
51: IS
88: SELECT set_of_books_id, primary_salesrep_id, org_id , invoice_currency_code, exchange_rate_type,
89: exchange_date, exchange_rate
90: --commented by kunkumar for Bug#6066813
91: ,interface_header_context /* 6012570 (5876390) */
92: FROM RA_CUSTOMER_TRX_ALL
93: WHERE customer_trx_id = v_customer_trx_id;
94:
95: --Commented for bug#4468353
96: /*
102:
103: /* Added by Ramananda for bug#4468353 , start */
104: CURSOR ORG_CUR IS
105: SELECT ORG_ID
106: FROM RA_CUSTOMER_TRX_ALL
107: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;
108:
109: lv_tax_regime_code zx_rates_b.tax_regime_code%type ;
110: ln_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type ;
118: WHERE B.tax_id = p_tax_id ;
119:
120: CURSOR CREATED_FROM_CUR IS
121: SELECT created_from, interface_header_attribute1,interface_header_attribute2
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
156: * Removed cursor set_of_books_cur and c_opr_set_of_books_id
157: * and implemented caching logic.
158: */
159: CURSOR trx_num(v_cust_trx_id NUMBER) IS SELECT
160: trx_number FROM ra_customer_trx_all WHERE
161: customer_trx_id = v_cust_trx_id;
162:
163: -- following cursor added by sriram -3266982
164:
195: lv_error_message VARCHAR2(4000) ;
196: -- End of bug 4089440
197:
198: v_err_mesg VARCHAR2(250) ;
199: v_trx_num ra_customer_trx_all.trx_number%TYPE ;
200:
201: /* Bug 5243532. Added by Lakshmi Gopalsami
202: * Defined variable for implementing caching logic
203: */
259: Also , a join between oe_order_headers_all and oe_transaction_types_tl has been added.
260: Without this join, if the same sales order number is associated to multiple order types,
261: there is scope for the wrong order number to be chosen and comparison done on that basis.
262:
263: With this join condition, the value in the ra_customer_trx_all.interface_header_attribute2 is
264: compared to the 'Name' field in the oe_transaction_types_tl.
265:
266: 11. 2005/27/01 aiyer - Bug # 4089440 File Version 115.1
267: Issue:-
842: v_location_id NUMBER ;
843: v_batch_source_id NUMBER ;
844: v_register_code VARCHAR2(50);
845: -- added by sriram - bug # 2779967
846: v_org_id ra_customer_trx_all.org_id%type;
847: -- added by sriram - bug # 2779967
848:
849: /*Commented by kunkumar for bug#6066813 start Bug 6012570 (5876390) */
850: /*cursor c_get_hdr_ctx
849: /*Commented by kunkumar for bug#6066813 start Bug 6012570 (5876390) */
850: /*cursor c_get_hdr_ctx
851: is
852: select interface_header_context
853: from ra_customer_trx_all
854: where customer_trx_id = pr_new.customer_trx_id;*/
855: /*commented the above cursor and added the following for bug#5597146*/
856: cursor c_get_hdr_ctx
857: is
861: and customer_trx_line_id = pr_new.customer_trx_line_id --added for bug#5597146
862: and interface_line_context is not null
863: and rownum = 1;
864:
865: lv_intf_hdr_ctx ra_customer_trx_all.interface_header_context%type ;
866: /* End commented by kunkumar for bug#6066813 */
867: /*end Bug 6012570 (5876390) */
868:
869: -- Deleted by Jia Li for Tax inclusive Computations on 2007/11/22 Begin
928:
929: /* Added by Ramananda for bug#4468353 , start
930: CURSOR ORG_CUR IS
931: SELECT ORG_ID
932: FROM RA_CUSTOMER_TRX_ALL
933: WHERE CUSTOMER_TRX_ID = pr_new.customer_trx_id;*/
934:
935: --commented the above org_cur cursor and added the following org_cur cursor for bug#5597146
936: CURSOR ORG_CUR IS
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
1041: 6. 2002/05/09 Sriram
1042: Added the if condition at the bottom of the trigger to conditionally call the concurrent
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