DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on FND_GLOBAL

Line 937: ln_user_id NUMBER := fnd_global.user_id;

933: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;
934: func_curr_det_rec jai_plsql_cache_pkg.func_curr_details;
935: lv_period_name gl_periods.period_name%TYPE;
936: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
937: ln_user_id NUMBER := fnd_global.user_id;
938: lv_procedure_name VARCHAR2(40):='Do_Unclaim';
939: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
940: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
941: lv_organization_code mtl_parameters.organization_code%TYPE;/*added by rchandan*/

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

2925: , ld_supp_exc_inv_date --=> pd_supp_exc_inv_date
2926: , pv_vat_action --=> pv_vat_action
2927: , pv_supp_vat_inv_no --=> pv_supp_vat_inv_no
2928: , ld_supp_vat_inv_date --=> pd_supp_vat_inv_date
2929: , fnd_global.conc_request_id --=> fnd_global.conc_request_id
2930: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines
2931: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions
2932: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2933: , SYSDATE --=> sysdate

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

2930: , jai_rcv_lines_rec.receipt_num --=> receipt_number from jai_rcv_lines
2931: , rcv_transactions_rec.vendor_id --=> vendor_id from rcv_transactions
2932: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2933: , SYSDATE --=> sysdate
2934: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2935: , SYSDATE --=> sysdate
2936: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id
2937: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2938: , NULL --=> NULL

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

2932: , rcv_transactions_rec.vendor_site_id --=> vendor_site_id from rcv_transactions
2933: , SYSDATE --=> sysdate
2934: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2935: , SYSDATE --=> sysdate
2936: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id
2937: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2938: , NULL --=> NULL
2939: );
2940:

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

2933: , SYSDATE --=> sysdate
2934: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2935: , SYSDATE --=> sysdate
2936: , FND_GLOBAL.LOGIN_ID --=> fnd_global.login_id
2937: , FND_GLOBAL.USER_ID --=> fnd_global.user_id
2938: , NULL --=> NULL
2939: );
2940:
2941: IF (ln_proc_level >= ln_dbg_level)

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

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
2986: , fnd_global.user_id --=> fnd_global.user_id
2987: , NULL --=> NULL

Line 2985: , fnd_global.login_id --=> fnd_global.login_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
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)

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

2982: , SYSDATE --=> sysdate
2983: , fnd_global.user_id --=> fnd_global.user_id
2984: , SYSDATE --=> sysdate
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:

Line 3502: , fnd_global.login_id

3498: , ln_vendor_id
3499: , ln_vendor_site_id
3500: , SYSDATE
3501: , SYSDATE
3502: , fnd_global.login_id
3503: , fnd_global.user_id
3504: , fnd_global.user_id
3505: , NULL
3506: );

Line 3503: , fnd_global.user_id

3499: , ln_vendor_site_id
3500: , SYSDATE
3501: , SYSDATE
3502: , fnd_global.login_id
3503: , fnd_global.user_id
3504: , fnd_global.user_id
3505: , NULL
3506: );
3507: ELSIF pr_old.shipment_type = 'BLANKET'

Line 3504: , fnd_global.user_id

3500: , SYSDATE
3501: , SYSDATE
3502: , fnd_global.login_id
3503: , fnd_global.user_id
3504: , fnd_global.user_id
3505: , NULL
3506: );
3507: ELSIF pr_old.shipment_type = 'BLANKET'
3508: THEN

Line 3568: , fnd_global.login_id

3564: , ln_vendor_id
3565: , ln_vendor_site_id
3566: , SYSDATE
3567: , SYSDATE
3568: , fnd_global.login_id
3569: , fnd_global.user_id
3570: , fnd_global.user_id
3571: , NULL
3572: );

Line 3569: , fnd_global.user_id

3565: , ln_vendor_site_id
3566: , SYSDATE
3567: , SYSDATE
3568: , fnd_global.login_id
3569: , fnd_global.user_id
3570: , fnd_global.user_id
3571: , NULL
3572: );
3573: END IF;

Line 3570: , fnd_global.user_id

3566: , SYSDATE
3567: , SYSDATE
3568: , fnd_global.login_id
3569: , fnd_global.user_id
3570: , fnd_global.user_id
3571: , NULL
3572: );
3573: END IF;
3574: EXCEPTION

Line 3642: , fnd_global.user_id

3638: , tax_rec.modvat_flag
3639: , tax_rec.adhoc_flag
3640: , lv_third_party_flag
3641: , SYSDATE
3642: , fnd_global.user_id
3643: , SYSDATE
3644: , fnd_global.login_id
3645: , fnd_global.user_id
3646: , NULL

Line 3644: , fnd_global.login_id

3640: , lv_third_party_flag
3641: , SYSDATE
3642: , fnd_global.user_id
3643: , SYSDATE
3644: , fnd_global.login_id
3645: , fnd_global.user_id
3646: , NULL
3647: );
3648: EXCEPTION

Line 3645: , fnd_global.user_id

3641: , SYSDATE
3642: , fnd_global.user_id
3643: , SYSDATE
3644: , fnd_global.login_id
3645: , fnd_global.user_id
3646: , NULL
3647: );
3648: EXCEPTION
3649: WHEN OTHERS THEN

Line 3699: , last_updated_by = fnd_global.user_id

3695: JAI_RETRO_TAX_CHANGES
3696: SET
3697: modified_tax_amount = pn_tax_amt
3698: , last_update_date = SYSDATE
3699: , last_updated_by = fnd_global.user_id
3700: , last_update_login = fnd_global.login_id
3701: WHERE tax_line_no = pn_line_no
3702: AND line_change_id = (SELECT
3703: line_change_id

Line 3700: , last_update_login = fnd_global.login_id

3696: SET
3697: modified_tax_amount = pn_tax_amt
3698: , last_update_date = SYSDATE
3699: , last_updated_by = fnd_global.user_id
3700: , last_update_login = fnd_global.login_id
3701: WHERE tax_line_no = pn_line_no
3702: AND line_change_id = (SELECT
3703: line_change_id
3704: FROM