938: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;
939: func_curr_det_rec jai_plsql_cache_pkg.func_curr_details;
940: lv_period_name gl_periods.period_name%TYPE;
941: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
942: ln_user_id NUMBER := fnd_global.user_id;
943: lv_procedure_name VARCHAR2(40):='Do_Unclaim';
944: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
945: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
946: lv_organization_code mtl_parameters.organization_code%TYPE;/*added by rchandan*/
2938: , ld_supp_exc_inv_date --=> pd_supp_exc_inv_date
2939: , pv_vat_action --=> pv_vat_action
2940: , pv_supp_vat_inv_no --=> pv_supp_vat_inv_no
2941: , ld_supp_vat_inv_date --=> pd_supp_vat_inv_date
2942: , fnd_global.conc_request_id --=> fnd_global.conc_request_id
2943: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines
2944: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions
2945: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2946: , SYSDATE --=> sysdate
2943: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines
2944: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions
2945: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2946: , SYSDATE --=> sysdate
2947: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2948: , SYSDATE --=> sysdate
2949: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id
2950: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2951: , NULL --=> NULL
2945: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2946: , SYSDATE --=> sysdate
2947: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2948: , SYSDATE --=> sysdate
2949: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id
2950: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2951: , NULL --=> NULL
2952: );
2953:
2946: , SYSDATE --=> sysdate
2947: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2948: , SYSDATE --=> sysdate
2949: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id
2950: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2951: , NULL --=> NULL
2952: );
2953:
2954: IF (ln_proc_level >= ln_dbg_level)
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
2999: , fnd_global.user_id --=> fnd_global.user_id
3000: , NULL --=> NULL
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
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)
2995: , SYSDATE --=> sysdate
2996: , fnd_global.user_id --=> fnd_global.user_id
2997: , SYSDATE --=> sysdate
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:
3543: , ln_vendor_id
3544: , ln_vendor_site_id
3545: , SYSDATE
3546: , SYSDATE
3547: , fnd_global.login_id
3548: , fnd_global.user_id
3549: , fnd_global.user_id
3550: , NULL
3551: );
3544: , ln_vendor_site_id
3545: , SYSDATE
3546: , SYSDATE
3547: , fnd_global.login_id
3548: , fnd_global.user_id
3549: , fnd_global.user_id
3550: , NULL
3551: );
3552: ELSIF pr_old.shipment_type = 'BLANKET'
3545: , SYSDATE
3546: , SYSDATE
3547: , fnd_global.login_id
3548: , fnd_global.user_id
3549: , fnd_global.user_id
3550: , NULL
3551: );
3552: ELSIF pr_old.shipment_type = 'BLANKET'
3553: THEN
3609: , ln_vendor_id
3610: , ln_vendor_site_id
3611: , SYSDATE
3612: , SYSDATE
3613: , fnd_global.login_id
3614: , fnd_global.user_id
3615: , fnd_global.user_id
3616: , NULL
3617: );
3610: , ln_vendor_site_id
3611: , SYSDATE
3612: , SYSDATE
3613: , fnd_global.login_id
3614: , fnd_global.user_id
3615: , fnd_global.user_id
3616: , NULL
3617: );
3618: END IF;
3611: , SYSDATE
3612: , SYSDATE
3613: , fnd_global.login_id
3614: , fnd_global.user_id
3615: , fnd_global.user_id
3616: , NULL
3617: );
3618: END IF;
3619: EXCEPTION
3683: , tax_rec.modvat_flag
3684: , tax_rec.adhoc_flag
3685: , lv_third_party_flag
3686: , SYSDATE
3687: , fnd_global.user_id
3688: , SYSDATE
3689: , fnd_global.login_id
3690: , fnd_global.user_id
3691: , NULL
3685: , lv_third_party_flag
3686: , SYSDATE
3687: , fnd_global.user_id
3688: , SYSDATE
3689: , fnd_global.login_id
3690: , fnd_global.user_id
3691: , NULL
3692: );
3693: EXCEPTION
3686: , SYSDATE
3687: , fnd_global.user_id
3688: , SYSDATE
3689: , fnd_global.login_id
3690: , fnd_global.user_id
3691: , NULL
3692: );
3693: EXCEPTION
3694: WHEN OTHERS THEN
3740: JAI_RETRO_TAX_CHANGES
3741: SET
3742: modified_tax_amount = pn_tax_amt
3743: , last_update_date = SYSDATE
3744: , last_updated_by = fnd_global.user_id
3745: , last_update_login = fnd_global.login_id
3746: WHERE tax_line_no = pn_line_no
3747: AND line_change_id = (SELECT
3748: line_change_id
3741: SET
3742: modified_tax_amount = pn_tax_amt
3743: , last_update_date = SYSDATE
3744: , last_updated_by = fnd_global.user_id
3745: , last_update_login = fnd_global.login_id
3746: WHERE tax_line_no = pn_line_no
3747: AND line_change_id = (SELECT
3748: line_change_id
3749: FROM