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

Line 96: FROM JAI_AR_TRXS

92: WHERE order_type_id = pr_new.batch_source_id and order_flag = 'N');
93:
94: Cursor organization_cur IS
95: SELECT organization_id,location_id
96: FROM JAI_AR_TRXS
97: WHERE trx_number = v_parent_trx_number;
98:
99: Cursor transaction_type_cur IS
100: Select type

Line 107: From JAI_AR_TRXS

103: And NVL(org_id,0) = NVL(pr_new.org_id,0);
104:
105: Cursor localization_header_info IS
106: Select organization_id, location_id, update_rg_flag
107: From JAI_AR_TRXS
108: Where customer_trx_id= pr_new.previous_customer_trx_id;
109:
110: v_currency_code gl_sets_of_books.currency_code%type;
111: CURSOR curr(c_sob NUMBER) IS

Line 234: INSERT INTO JAI_AR_TRXS

230: END IF;
231: END IF;
232:
233: -------
234: INSERT INTO JAI_AR_TRXS
235: (
236: CUSTOMER_TRX_ID ,
237: ORGANIZATION_ID ,
238: LOCATION_ID ,

Line 308: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;

304:
305: v_vat_start_num JAI_CMN_INVENTORY_ORGS.current_number%Type;
306: v_vat_jump_by JAI_CMN_INVENTORY_ORGS.jump_by%type;
307: v_vat_prefix JAI_CMN_INVENTORY_ORGS.prefix%type;
308: v_vat_invoice_no JAI_AR_TRXS.tax_invoice_no%type;
309: v_vat_reg_no JAI_CMN_INVENTORY_ORGS.vat_reg_no%type;
310:
311:
312: v_organization_id Number;

Line 316: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;

312: v_organization_id Number;
313: v_loc_id Number;
314: v_vat_taxes_exist Number;
315: v_trans_type VARCHAR2(30);
316: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;
317:
318: CURSOR organization_cur IS
319: SELECT organization_id,location_id
320: FROM JAI_AR_TRXS

Line 320: FROM JAI_AR_TRXS

316: v_loc_vat_inv_no JAI_AR_TRXS.tax_invoice_no%type;
317:
318: CURSOR organization_cur IS
319: SELECT organization_id,location_id
320: FROM JAI_AR_TRXS
321: where customer_trx_id = pr_new.customer_trx_id;
322:
323: CURSOR C_VAT_INVOICE_CUR IS
324: SELECT TAX_INVOICE_NO

Line 325: FROM JAI_AR_TRXS

321: where customer_trx_id = pr_new.customer_trx_id;
322:
323: CURSOR C_VAT_INVOICE_CUR IS
324: SELECT TAX_INVOICE_NO
325: FROM JAI_AR_TRXS
326: WHERE Customer_Trx_Id = pr_new.customer_trx_id;
327:
328:
329: cursor c_vat_taxes_exist

Line 399: update JAI_AR_TRXS

395: else
396: v_vat_invoice_no := v_vat_start_num;
397: end if;
398:
399: update JAI_AR_TRXS
400: set tax_invoice_no = v_vat_invoice_no
401: where customer_trx_id = pr_new.customer_trx_id;
402:
403: update JAI_CMN_INVENTORY_ORGS

Line 579: Update JAI_AR_TRXS

575:
576: IF pr_new.created_from = 'RAXTRX' THEN
577: IF pr_new.CUSTOMER_TRX_ID <> pr_old.CUSTOMER_TRX_ID
578: THEN
579: Update JAI_AR_TRXS
580: Set Customer_Trx_ID = pr_new.Customer_Trx_ID
581: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
582: Update JAI_AR_TRX_LINES
583: Set Customer_Trx_Id = pr_new.Customer_Trx_ID

Line 588: Update JAI_AR_TRXS

584: Where Customer_Trx_ID = pr_old.Customer_Trx_ID;
585: END IF;
586:
587:
588: Update JAI_AR_TRXS
589: Set Trx_Number = pr_new.Trx_Number
590: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
591: END IF;
592:

Line 600: Update JAI_AR_TRXS

596: IF NVL(v_trans_type,'N') in ('CM','DM') THEN
597:
598: -- Start, Vijay Shankar for bug # 3181921
599: IF pr_new.created_from = 'RAXTRX' THEN
600: Update JAI_AR_TRXS
601: Set Trx_Number = pr_new.Trx_Number
602: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
603: ELSE
604: -- End, Vijay Shankar for bug # 3181921

Line 606: Update JAI_AR_TRXS

602: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
603: ELSE
604: -- End, Vijay Shankar for bug # 3181921
605:
606: Update JAI_AR_TRXS
607: Set Trx_Number = pr_new.Trx_Number
608: , Once_Completed_Flag = NVL(pr_new.Complete_Flag,'N')
609: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
610: END IF;

Line 613: Update JAI_AR_TRXS

609: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
610: END IF;
611:
612: ELSIF NVL(v_trans_type,'N') = 'INV' THEN
613: Update JAI_AR_TRXS
614: Set Trx_Number = pr_new.Trx_Number
615: Where Customer_Trx_ID = pr_new.Customer_Trx_ID;
616: END IF;
617: /* Added an exception block by Ramananda for bug#4570303 */

Line 638: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;

634: PROCEDURE ARU_T3 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
635: v_organization_id NUMBER ;
636: v_loc_id NUMBER ;
637: v_trans_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
638: lv_vat_invoice_no JAI_AR_TRXS.VAT_INVOICE_NO%TYPE ;
639: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
641: lv_process_flag VARCHAR2(10) ;
642: lv_process_message VARCHAR2(4000) ;

Line 644: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;

640: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
641: lv_process_flag VARCHAR2(10) ;
642: lv_process_message VARCHAR2(4000) ;
643: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
644: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;
645:
646:
647: /*
648: || Get the organization, location, vat_invoice_no and vat_invoice_date from JAI_AR_TRXS

Line 648: || Get the organization, location, vat_invoice_no and vat_invoice_date from JAI_AR_TRXS

644: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;
645:
646:
647: /*
648: || Get the organization, location, vat_invoice_no and vat_invoice_date from JAI_AR_TRXS
649: */
650: CURSOR organization_cur
651: IS
652: SELECT

Line 658: JAI_AR_TRXS

654: location_id ,
655: vat_invoice_no ,
656: vat_invoice_date
657: FROM
658: JAI_AR_TRXS
659: WHERE
660: customer_trx_id = pr_new.customer_trx_id;
661:
662: /*

Line 715: JAI_AR_TRXS

711: IS
712: SELECT
713: vat_invoice_no
714: FROM
715: JAI_AR_TRXS
716: WHERE
717: customer_trx_id = pr_new.previous_customer_trx_id;
718:
719: /*

Line 911: JAI_AR_TRXS

907:
908: END IF;
909:
910: UPDATE
911: JAI_AR_TRXS
912: SET
913: vat_invoice_no = lv_vat_invoice_no ,
914: vat_invoice_date = nvl(ld_gl_date,pr_new.trx_date)
915: WHERE

Line 1022: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/Bug#4601570 bduvarag/

1018: v_register_exp_date JAI_OM_OE_BOND_REG_HDRS.bond_expiry_date%type;
1019: v_lou_flag JAI_OM_OE_BOND_REG_HDRS.lou_flag%type;
1020: -- added by sriram - bug # 3021588
1021: v_trading_flag JAI_CMN_INVENTORY_ORGS.TRADING%TYPE;/*Bug#4601570 bduvarag*/
1022: v_update_rg23d_flag JAI_AR_TRXS.UPDATE_RG23D_FLAG%TYPE;/*Bug#4601570 bduvarag*/
1023:
1024: /*
1025: || Start of bug 4101549
1026: || Cursor modified by aiyer

Line 1038: JAI_AR_TRXS

1034: decode(once_completed_flag,'A','RG23A','C','RG23C','P','PLA') register_type,
1035: update_rg_flag, -- update_rg_flag added by sriram - bug# 3496577
1036: nvl(update_rg23d_flag,'N') /*Bug 5040383*/
1037: FROM
1038: JAI_AR_TRXS
1039: WHERE
1040: customer_trx_id = v_customer_trx_id;
1041:
1042:

Line 1064: FROM JAI_AR_TRXS

1060: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
1061:
1062: CURSOR tax_amount_cur IS
1063: SELECT NVL(tax_amount,0) tax_amount
1064: FROM JAI_AR_TRXS
1065: WHERE customer_trx_id = v_customer_trx_id;
1066:
1067: CURSOR preference_reg_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1068: SELECT pref_rg23a , pref_rg23c , pref_pla

Line 1081: FROM JAI_AR_TRXS

1077: ORGANIZATION_ID = P_ORG_ID;
1078:
1079: CURSOR organization_cur IS
1080: SELECT organization_id,location_id
1081: FROM JAI_AR_TRXS
1082: WHERE trx_number = v_parent_trx_number;
1083:
1084: CURSOR register_balance_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER) IS
1085: SELECT NVL(register_balance,0) register_balance

Line 1232: FROM JAI_AR_TRXS jtrx,

1228:
1229: --3661746
1230: CURSOR c_total_Excise_amt IS
1231: SELECT nvl(sum(jrtl.func_tax_amount),0)
1232: FROM JAI_AR_TRXS jtrx,
1233: JAI_AR_TRX_LINES jtl,
1234: JAI_AR_TRX_TAX_LINES jrtl,
1235: JAI_CMN_TAXES_ALL jtc ,
1236: JAI_INV_ITM_SETUPS jmtl

Line 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 */

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
1274: SELECT
1275: 1
1276: FROM

Line 1287: FROM JAI_AR_TRXS

1283: CURSOR c_vat_invoice_cur
1284: IS
1285: SELECT
1286: vat_invoice_no
1287: FROM JAI_AR_TRXS
1288: WHERE customer_trx_id = pr_new.customer_trx_id;
1289:
1290: CURSOR cur_vat_taxes_exist
1291: IS

Line 1346: CURSOR cur_get_same_inv_no ( cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ,

1342: --bug#5645003, ends
1343:
1344:
1345:
1346: CURSOR cur_get_same_inv_no ( cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ,
1347: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE
1348: )
1349: IS
1350: SELECT

Line 1347: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE

1343:
1344:
1345:
1346: CURSOR cur_get_same_inv_no ( cp_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ,
1347: cp_location_id JAI_AR_TRXS.LOCATION_ID%TYPE
1348: )
1349: IS
1350: SELECT
1351: nvl(attribute_value ,'N') attribute_value

Line 1392: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;

1388: lv_register_type VARCHAR2(5);
1389: lv_rg23a_cess_avlbl VARCHAR2(10);
1390: lv_rg23c_cess_avlbl VARCHAR2(10);
1391: lv_pla_cess_avlbl VARCHAR2(10);
1392: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1393: lv_vat_taxes_exist VARCHAR2(1);
1394: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE; -- := 'N'; --Ramananda for File.Sql.35
1395: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1396: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;

Line 1516: UPDATE JAI_AR_TRXS

1512: */
1513:
1514: IF NVL(v_trans_type,'N') <> 'INV' THEN
1515: /*Bug 5171573 bduvarag start*/
1516: UPDATE JAI_AR_TRXS
1517: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
1518: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
1519: /*Bug 5171573 bduvarag End*/
1520: RETURN;

Line 1523: UPDATE JAI_AR_TRXS

1519: /*Bug 5171573 bduvarag End*/
1520: RETURN;
1521: END IF;
1522: IF pr_new.created_from = 'RAXTRX' THEN
1523: UPDATE JAI_AR_TRXS
1524: SET ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
1525: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
1526: ELSE
1527:

Line 1986: FROM JAI_AR_TRXS

1982: v_reg_type VARCHAR2(10);
1983: Begin
1984: SELECT once_completed_flag
1985: INTO v_reg_type
1986: FROM JAI_AR_TRXS
1987: WHERE CUSTOMER_TRX_ID = pr_new.Customer_trx_id;
1988:
1989: IF v_reg_type = 'P' THEN
1990: v_reg_type := 'PLA';

Line 2101: FROM JAI_AR_TRXS

2097: v_reg_type1 VARCHAR2(10);
2098: Begin
2099: SELECT once_completed_flag
2100: INTO v_reg_type1
2101: FROM JAI_AR_TRXS
2102: WHERE CUSTOMER_TRX_ID = pr_new.Customer_trx_id;
2103:
2104: If v_reg_type1 = 'P' THEN
2105: v_reg_type1 := 'PLA';

Line 2174: UPDATE JAI_AR_TRXS

2170: SYSDATE ,
2171: FND_GLOBAL.USER_ID ,
2172: SYSDATE);
2173: END IF;
2174: UPDATE JAI_AR_TRXS
2175: SET
2176: ONCE_COMPLETED_FLAG = pr_new.COMPLETE_FLAG
2177: WHERE CUSTOMER_TRX_ID = V_CUSTOMER_TRX_ID;
2178: END IF;

Line 2341: JAI_AR_TRXS

2337:
2338: END IF;
2339:
2340: UPDATE
2341: JAI_AR_TRXS
2342: SET
2343: vat_invoice_no = lv_vat_invoice_number ,
2344: vat_invoice_date = nvl(ld_gl_date,pr_new.trx_date)
2345: WHERE

Line 2475: FROM JAI_AR_TRXS

2471:
2472:
2473: CURSOR SO_AR_HDR_INFO IS
2474: SELECT organization_id, location_id, batch_source_id
2475: FROM JAI_AR_TRXS
2476: WHERE Customer_Trx_ID = v_customer_trx_id;
2477:
2478:
2479: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER,

Line 2547: ||changed the variable definition from RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE

2543: v_err_mesg VARCHAR2(250);
2544:
2545: /*
2546: || start of bug 5364288 - code modified by aiyer
2547: ||changed the variable definition from RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
2548: */
2549: v_trx_num JAI_AR_TRXS.TRX_NUMBER%TYPE;
2550:
2551: /* End of bug 5364288 */

Line 2549: v_trx_num JAI_AR_TRXS.TRX_NUMBER%TYPE;

2545: /*
2546: || start of bug 5364288 - code modified by aiyer
2547: ||changed the variable definition from RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE to JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE
2548: */
2549: v_trx_num JAI_AR_TRXS.TRX_NUMBER%TYPE;
2550:
2551: /* End of bug 5364288 */
2552:
2553: v_TRX_TAX_COUNT Number;

Line 2839: FROM JAI_AR_TRXS

2835: FROM JAI_AR_TRX_APPS_RELS_T ;/*altered by rchandan for bug#4479131*/
2836:
2837: CURSOR organization_cur IS
2838: SELECT organization_id
2839: FROM JAI_AR_TRXS
2840: WHERE trx_number = pr_new.recurred_from_trx_number;
2841:
2842: CURSOR ONCE_COMPLETE_FLAG_CUR IS
2843: SELECT once_completed_flag

Line 2844: FROM JAI_AR_TRXS

2840: WHERE trx_number = pr_new.recurred_from_trx_number;
2841:
2842: CURSOR ONCE_COMPLETE_FLAG_CUR IS
2843: SELECT once_completed_flag
2844: FROM JAI_AR_TRXS
2845: WHERE customer_trx_id = v_header_id;
2846:
2847: v_trans_type Varchar2(30);
2848:

Line 2945: the change is being reflected in the JAI_AR_TRXS table.

2941: CURSOR TAX_INFO_CUR MODIFY PRECEDENCE IS ADDED FROM 6 TO 10
2942: SQL STATEMENT JAI_AR_TRX_TAX_LINES MODIFY PRECEDENCE IS ADDED FROM 6 TO 10
2943: 3. 27-Feb-2007 CSahoo for Bug 5390583, File Version 120.5 Forward Porting of 11i BUG 5357400
2944: When a change is done in the invoice currency code from the front end
2945: the change is being reflected in the JAI_AR_TRXS table.
2946: Added a IF clause for the same.
2947:
2948:
2949: 4. 14-05-2007 ssawant for bug 5879769, File Version 120.6

Line 3013: UPDATE JAI_AR_TRXS

3009: END IF;
3010: --Following If and update added by CSahoo - bug# 5390583
3011: IF pr_new.invoice_currency_code <> pr_old.invoice_currency_code THEN
3012:
3013: UPDATE JAI_AR_TRXS
3014: SET invoice_currency_code = pr_new.invoice_currency_code ,
3015: exchange_rate_type = pr_new.exchange_rate_type ,
3016: exchange_date = pr_new.exchange_date ,
3017: exchange_rate = pr_new.exchange_rate

Line 3232: LV_ONCE_COMPLETED_FLAG JAI_AR_TRXS.ONCE_COMPLETED_FLAG%TYPE;

3228: ( PR_OLD T_REC%TYPE , PR_NEW T_REC%TYPE , PV_ACTION VARCHAR2 , PV_RETURN_CODE OUT NOCOPY VARCHAR2 , PV_RETURN_MESSAGE OUT NOCOPY VARCHAR2 )
3229: IS
3230: LV_DOCUMENT_TYPE VARCHAR2(40);
3231: LN_REG_ID NUMBER;
3232: LV_ONCE_COMPLETED_FLAG JAI_AR_TRXS.ONCE_COMPLETED_FLAG%TYPE;
3233: V_HEADER_ID NUMBER;
3234:
3235:
3236: CURSOR ONCE_COMPLETE_FLAG_CUR IS

Line 3238: FROM JAI_AR_TRXS

3234:
3235:
3236: CURSOR ONCE_COMPLETE_FLAG_CUR IS
3237: SELECT ONCE_COMPLETED_FLAG
3238: FROM JAI_AR_TRXS
3239: WHERE CUSTOMER_TRX_ID = V_HEADER_ID;
3240:
3241: BEGIN
3242:

Line 3324: Added legal_entity_id for table JAI_AR_TRXS in insert statement

3320: 2. 10-Jun-2005 File Version: 116.2
3321: Removal of SQL LITERALs is done
3322:
3323: 3. 10-Jun-2005 rallamse bug#4448789 116.3
3324: Added legal_entity_id for table JAI_AR_TRXS in insert statement
3325:
3326: 4. 26-07-2005 rallamse bug#4510143 120.2
3327: Modified legal_entity_id for table JAI_AR_TRXS to get from header_info_cur cursor
3328:

Line 3327: Modified legal_entity_id for table JAI_AR_TRXS to get from header_info_cur cursor

3323: 3. 10-Jun-2005 rallamse bug#4448789 116.3
3324: Added legal_entity_id for table JAI_AR_TRXS in insert statement
3325:
3326: 4. 26-07-2005 rallamse bug#4510143 120.2
3327: Modified legal_entity_id for table JAI_AR_TRXS to get from header_info_cur cursor
3328:
3329: 5. 10-Aug-2005 Aiyer bug 4545146 version 120.1
3330: Issue:-
3331: Deadlock on tables due to multiple triggers on the same table (in different sql files)

Line 3374: FROM JAI_AR_TRXS

3370: ORDER BY customer_trx_id;
3371:
3372: CURSOR ONCE_COMPLETE_FLAG_CUR(p_header_id IN NUMBER, p_batch_source_id IN Number) IS
3373: SELECT once_completed_flag, 1
3374: FROM JAI_AR_TRXS
3375: WHERE customer_trx_id = p_header_id
3376: AND NVL(batch_source_id,0) = p_batch_source_id;
3377:
3378: CURSOR parent_header_id(p_recurred_from_trx_number IN Varchar2, p_batch_source_id IN Number) IS

Line 3380: FROM JAI_AR_TRXS a

3376: AND NVL(batch_source_id,0) = p_batch_source_id;
3377:
3378: CURSOR parent_header_id(p_recurred_from_trx_number IN Varchar2, p_batch_source_id IN Number) IS
3379: SELECT a.customer_trx_id
3380: FROM JAI_AR_TRXS a
3381: WHERE a.trx_number = p_recurred_from_trx_number
3382: AND NVL(batch_source_id,0) = p_batch_source_id;
3383:
3384: CURSOR LINES_INFO_CUR(p_parent_header_id IN Number) IS

Line 3407: FROM JAI_AR_TRXS

3403:
3404: CURSOR HEADER_INFO_CUR(p_recurred_from_trx_number IN Varchar2, p_batch_source_id IN Number) IS
3405: SELECT CUSTOMER_TRX_ID, ORGANIZATION_ID, LOCATION_ID, UPDATE_RG_FLAG, UPDATE_RG23D_FLAG,
3406: TAX_AMOUNT, LINE_AMOUNT, TOTAL_AMOUNT, BATCH_SOURCE_ID,legal_entity_id /* added rallamse bug#4448789 */
3407: FROM JAI_AR_TRXS
3408: WHERE trx_number = p_recurred_from_trx_number
3409: AND NVL(batch_source_id,0) = p_batch_source_id;
3410:
3411: BEGIN

Line 3445: INSERT INTO JAI_AR_TRXS

3441: IF NVL(x,0) <> 1 THEN
3442:
3443: FOR hdr in HEADER_INFO_CUR(v_recurred_from_trx_number, v_batch_source_id)
3444: LOOP
3445: INSERT INTO JAI_AR_TRXS
3446: (customer_trx_id, organization_id, location_id, update_rg23d_flag,
3447: update_rg_flag, trx_number, once_completed_flag,
3448: line_amount, batch_source_id, created_from,
3449: creation_date, created_by,

Line 3531: UPDATE JAI_AR_TRXS

3527: WHERE customer_trx_line_id = v_customer_trx_line_id;
3528: v_line_tax_amount := 0;
3529: END LOOP;
3530:
3531: UPDATE JAI_AR_TRXS
3532: SET tax_amount = v_header_tax_amount,
3533: total_amount = nvl(line_amount,0) + v_header_tax_amount
3534: WHERE customer_trx_id = v_header_id;
3535: v_header_tax_amount := 0;

Line 3542: DELETE JAI_AR_TRXS

3538:
3539: --added this procedure for bug#7450481
3540: PROCEDURE ARD_T1 ( pr_old t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
3541: BEGIN
3542: DELETE JAI_AR_TRXS
3543: WHERE customer_trx_id = pr_old.customer_trx_id ;
3544:
3545: pv_return_message := '';
3546: pv_return_code := jai_constants.successful;