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_RETRO_PRC_PKG dependencies on JAI_RCV_LINE_TAXES

Line 2644: CURSOR get_jai_rcv_line_taxes_cur

2640: AND jrlc.source_line_change_id = pn_line_change_id
2641: AND jrlc.doc_type = 'RECEIPT'
2642: );
2643:
2644: CURSOR get_jai_rcv_line_taxes_cur
2645: (pn_transaction_id jai_rcv_line_taxes.transaction_id%TYPE )
2646: IS
2647: SELECT
2648: jrlt.*,

Line 2645: (pn_transaction_id jai_rcv_line_taxes.transaction_id%TYPE )

2641: AND jrlc.doc_type = 'RECEIPT'
2642: );
2643:
2644: CURSOR get_jai_rcv_line_taxes_cur
2645: (pn_transaction_id jai_rcv_line_taxes.transaction_id%TYPE )
2646: IS
2647: SELECT
2648: jrlt.*,
2649: jcta.adhoc_flag

Line 2651: jai_rcv_line_taxes jrlt

2647: SELECT
2648: jrlt.*,
2649: jcta.adhoc_flag
2650: FROM
2651: jai_rcv_line_taxes jrlt
2652: , jai_cmn_taxes_all jcta
2653: WHERE jrlt.transaction_id = pn_transaction_id
2654: AND jrlt.tax_id = jcta.tax_id;
2655:

Line 2946: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)

2942: THEN
2943: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_line_changes inserted ');
2944: END IF; --l_proc_level>=l_dbg_level
2945:
2946: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
2947: LOOP
2948: -- Insert into jai_retro_tax_changes
2949: INSERT INTO jai_retro_tax_changes
2950: ( tax_change_id

Line 2972: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes

2968: )
2969: VALUES
2970: ( jai_retro_tax_changes_s.nextval --=> jai_retro_tax_changes_s.nextval
2971: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2972: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes

Line 2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes

2969: VALUES
2970: ( jai_retro_tax_changes_s.nextval --=> jai_retro_tax_changes_s.nextval
2971: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2972: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes

Line 2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes

2970: ( jai_retro_tax_changes_s.nextval --=> jai_retro_tax_changes_s.nextval
2971: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2972: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount

Line 2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes

2971: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2972: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes

Line 2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes

2972: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id

Line 2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes

2973: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2974: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2981: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes

Line 2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes

2975: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2981: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2982: , SYSDATE --=> sysdate
2983: , fnd_global.user_id --=> fnd_global.user_id

Line 2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id

2976: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2981: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2982: , SYSDATE --=> sysdate
2983: , fnd_global.user_id --=> fnd_global.user_id
2984: , SYSDATE --=> sysdate

Line 2981: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes

2977: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2978: , NULL --=> NULL ,modified_tax_amount
2979: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2980: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2981: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2982: , SYSDATE --=> sysdate
2983: , fnd_global.user_id --=> fnd_global.user_id
2984: , SYSDATE --=> sysdate
2985: , fnd_global.login_id --=> fnd_global.login_id

Line 2989: END LOOP;-- (jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur)

2985: , fnd_global.login_id --=> fnd_global.login_id
2986: , fnd_global.user_id --=> fnd_global.user_id
2987: , NULL --=> NULL
2988: ) ;
2989: END LOOP;-- (jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur)
2990:
2991: IF (ln_proc_level >= ln_dbg_level)
2992: THEN
2993: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_tax_changes inserted ');

Line 3078: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)

3074: -- print the new total tax amount of the receipt
3075: Fnd_File.Put_Line(FND_FILE.LOG,' New total tax amount of the receipt '||jai_rcv_lines_rec.receipt_num||' IS :' ||ln_recv_tax_amount);
3076:
3077: -- After recalculating the tax ,updat the modified_tax_amount of jai_retro_tax_changes table
3078: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
3079: LOOP
3080: -- Update the new tax amount in modified_tax_amount column of jai_retro_tax_changes
3081: UPDATE
3082: jai_retro_tax_changes jrtc

Line 3085: FROM jai_rcv_line_taxes jrlt

3081: UPDATE
3082: jai_retro_tax_changes jrtc
3083: SET
3084: modified_tax_amount = ( SELECT tax_amount
3085: FROM jai_rcv_line_taxes jrlt
3086: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id
3087: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3088: AND jrlt.tax_id = jrtc.tax_id
3089: )

Line 3091: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no

3087: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3088: AND jrlt.tax_id = jrtc.tax_id
3089: )
3090: WHERE line_change_id = ln_retro_line_changes_id
3091: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3092: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3093: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3094:
3095: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');

Line 3092: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;

3088: AND jrlt.tax_id = jrtc.tax_id
3089: )
3090: WHERE line_change_id = ln_retro_line_changes_id
3091: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3092: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3093: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3094:
3095: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');
3096:

Line 3093: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur

3089: )
3090: WHERE line_change_id = ln_retro_line_changes_id
3091: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3092: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3093: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3094:
3095: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');
3096:
3097: Get_Vat_CenVat_Amount