DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on FND_GLOBAL

Line 942: ln_user_id NUMBER := fnd_global.user_id;

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

Line 2942: , fnd_global.conc_request_id --=> fnd_global.conc_request_id

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

Line 2947: , FND_GLOBAL.USER_ID --=> fnd_global.user_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
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

Line 2949: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id

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:

Line 2950: , FND_GLOBAL.USER_ID --=> fnd_global.user_id

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)

Line 2996: , fnd_global.user_id --=> fnd_global.user_id

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

Line 2998: , fnd_global.login_id --=> fnd_global.login_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
3001: ) ;
3002: END LOOP;-- (jai_rcv_line_taxes_rec IN get_jai_rcv_line_taxes_cur)

Line 2999: , fnd_global.user_id --=> fnd_global.user_id

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:

Line 3547: , fnd_global.login_id

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: );

Line 3548: , fnd_global.user_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: );
3552: ELSIF pr_old.shipment_type = 'BLANKET'

Line 3549: , fnd_global.user_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'
3553: THEN

Line 3613: , fnd_global.login_id

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: );

Line 3614: , fnd_global.user_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: );
3618: END IF;

Line 3615: , fnd_global.user_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;
3619: EXCEPTION

Line 3687: , fnd_global.user_id

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

Line 3689: , fnd_global.login_id

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

Line 3690: , fnd_global.user_id

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

Line 3744: , last_updated_by = fnd_global.user_id

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

Line 3745: , last_update_login = fnd_global.login_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