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 2657: CURSOR get_jai_rcv_line_taxes_cur

2653: AND jrlc.source_line_change_id = pn_line_change_id
2654: AND jrlc.doc_type = 'RECEIPT'
2655: );
2656:
2657: CURSOR get_jai_rcv_line_taxes_cur
2658: (pn_transaction_id jai_rcv_line_taxes.transaction_id%TYPE )
2659: IS
2660: SELECT
2661: jrlt.*,

Line 2658: (pn_transaction_id jai_rcv_line_taxes.transaction_id%TYPE )

2654: AND jrlc.doc_type = 'RECEIPT'
2655: );
2656:
2657: CURSOR get_jai_rcv_line_taxes_cur
2658: (pn_transaction_id jai_rcv_line_taxes.transaction_id%TYPE )
2659: IS
2660: SELECT
2661: jrlt.*,
2662: jcta.adhoc_flag

Line 2664: jai_rcv_line_taxes jrlt

2660: SELECT
2661: jrlt.*,
2662: jcta.adhoc_flag
2663: FROM
2664: jai_rcv_line_taxes jrlt
2665: , jai_cmn_taxes_all jcta
2666: WHERE jrlt.transaction_id = pn_transaction_id
2667: AND jrlt.tax_id = jcta.tax_id;
2668:

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

2955: THEN
2956: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_line_changes inserted ');
2957: END IF; --l_proc_level>=l_dbg_level
2958:
2959: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
2960: LOOP
2961: -- Insert into jai_retro_tax_changes
2962: INSERT INTO jai_retro_tax_changes
2963: ( tax_change_id

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

2981: )
2982: VALUES
2983: ( jai_retro_tax_changes_s.nextval --=> jai_retro_tax_changes_s.nextval
2984: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2985: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2986: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2987: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes

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

2982: VALUES
2983: ( jai_retro_tax_changes_s.nextval --=> jai_retro_tax_changes_s.nextval
2984: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2985: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2986: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2987: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes

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

2983: ( jai_retro_tax_changes_s.nextval --=> jai_retro_tax_changes_s.nextval
2984: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2985: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2986: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2987: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount

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

2984: , ln_retro_line_changes_id --=> from jai_retro_line_changes
2985: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2986: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2987: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes

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

2985: , jai_rcv_line_taxes_rec.tax_line_no --=> from jai_rcv_line_taxes
2986: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2987: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id

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

2986: , jai_rcv_line_taxes_rec.tax_id --=> from jai_rcv_line_taxes
2987: , jai_rcv_line_taxes_rec.tax_name --=> from jai_rcv_line_taxes
2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2994: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes

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

2988: , jai_rcv_line_taxes_rec.tax_type --=> from jai_rcv_line_taxes
2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2994: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2995: , SYSDATE --=> sysdate
2996: , fnd_global.user_id --=> fnd_global.user_id

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

2989: , jai_rcv_line_taxes_rec.currency --=> from jai_rcv_line_taxes
2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2994: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2995: , SYSDATE --=> sysdate
2996: , fnd_global.user_id --=> fnd_global.user_id
2997: , SYSDATE --=> sysdate

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

2990: , jai_rcv_line_taxes_rec.tax_amount --=> tax_amount from jai_rcv_line_taxes
2991: , NULL --=> NULL ,modified_tax_amount
2992: , jai_rcv_line_taxes_rec.modvat_flag --=> modvat_flag from jai_rcv_line_taxes
2993: , jai_rcv_line_taxes_rec.adhoc_flag --=> adhoc_flag from jai_cmn_taxes_all. Join using tax_id
2994: , jai_rcv_line_taxes_rec.third_party_flag --=> from jai_rcv_line_taxes
2995: , SYSDATE --=> sysdate
2996: , fnd_global.user_id --=> fnd_global.user_id
2997: , SYSDATE --=> sysdate
2998: , fnd_global.login_id --=> fnd_global.login_id

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

2998: , fnd_global.login_id --=> fnd_global.login_id
2999: , fnd_global.user_id --=> fnd_global.user_id
3000: , NULL --=> NULL
3001: ) ;
3002: END LOOP;-- (jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur)
3003:
3004: IF (ln_proc_level >= ln_dbg_level)
3005: THEN
3006: FND_FILE.PUT_LINE(fnd_file.log, ' Table jai_retro_tax_changes inserted ');

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

3119: -- print the new total tax amount of the receipt
3120: 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);
3121:
3122: -- After recalculating the tax ,updat the modified_tax_amount of jai_retro_tax_changes table
3123: FOR jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur (rcv_transactions_rec.transaction_id)
3124: LOOP
3125: -- Update the new tax amount in modified_tax_amount column of jai_retro_tax_changes
3126: UPDATE
3127: jai_retro_tax_changes jrtc

Line 3130: FROM jai_rcv_line_taxes jrlt

3126: UPDATE
3127: jai_retro_tax_changes jrtc
3128: SET
3129: modified_tax_amount = ( SELECT tax_amount
3130: FROM jai_rcv_line_taxes jrlt
3131: WHERE jrlt.shipment_header_id = jai_rcv_lines_rec.shipment_header_id
3132: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3133: AND jrlt.tax_id = jrtc.tax_id
3134: )

Line 3136: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no

3132: AND jrlt.shipment_line_id = jai_rcv_lines_rec.shipment_line_id
3133: AND jrlt.tax_id = jrtc.tax_id
3134: )
3135: WHERE line_change_id = ln_retro_line_changes_id
3136: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3137: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3138: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3139:
3140: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');

Line 3137: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;

3133: AND jrlt.tax_id = jrtc.tax_id
3134: )
3135: WHERE line_change_id = ln_retro_line_changes_id
3136: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3137: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3138: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3139:
3140: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');
3141:

Line 3138: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur

3134: )
3135: WHERE line_change_id = ln_retro_line_changes_id
3136: AND tax_line_no = jai_rcv_line_taxes_rec.tax_line_no
3137: AND tax_id = jai_rcv_line_taxes_rec.tax_id ;
3138: END LOOP; --jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur
3139:
3140: Fnd_File.Put_Line(FND_FILE.LOG,' New tax has been updated to the table jai_retro_tax_changes ');
3141:
3142: Get_Vat_CenVat_Amount