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.PN_APPROVE_VARENT_PKG dependencies on FND_PROFILE

Line 878: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

874: IF NVL(l_retcode,-1) <> 2 THEN
875: UPDATE pn_payment_terms_all
876: SET status = 'APPROVED',
877: last_update_date = SYSDATE,
878: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
879: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
880: approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
881: WHERE payment_term_id = l_payment_term_id;
882: END IF;

Line 879: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),

875: UPDATE pn_payment_terms_all
876: SET status = 'APPROVED',
877: last_update_date = SYSDATE,
878: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
879: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
880: approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
881: WHERE payment_term_id = l_payment_term_id;
882: END IF;
883: END IF;

Line 880: approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)

876: SET status = 'APPROVED',
877: last_update_date = SYSDATE,
878: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
879: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0),
880: approved_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
881: WHERE payment_term_id = l_payment_term_id;
882: END IF;
883: END IF;
884:

Line 904: last_updated_by = NVL(fnd_profile.VALUE ('USER_ID'), 0),

900: SET forecasted_exp_code = DECODE(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
901: actual_exp_code = DECODE(p_rent_type,'ACTUAL','Y',actual_exp_code),
902: variance_exp_code = DECODE(p_rent_type,'VARIANCE','Y',variance_exp_code),
903: last_update_date = SYSDATE,
904: last_updated_by = NVL(fnd_profile.VALUE ('USER_ID'), 0),
905: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
906: WHERE var_rent_inv_id = p_var_rent_inv_id;
907:
908: /* pinky */

Line 905: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

901: actual_exp_code = DECODE(p_rent_type,'ACTUAL','Y',actual_exp_code),
902: variance_exp_code = DECODE(p_rent_type,'VARIANCE','Y',variance_exp_code),
903: last_update_date = SYSDATE,
904: last_updated_by = NVL(fnd_profile.VALUE ('USER_ID'), 0),
905: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
906: WHERE var_rent_inv_id = p_var_rent_inv_id;
907:
908: /* pinky */
909: UPDATE pn_var_rent_inv_all

Line 920: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

916: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
917: actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
918: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
919: last_update_date = SYSDATE,
920: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
921: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
922: WHERE period_id = p_period_id
923: AND invoice_date = p_invoice_date
924: AND var_rent_id = p_var_rent_id;

Line 921: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

917: actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
918: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
919: last_update_date = SYSDATE,
920: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
921: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
922: WHERE period_id = p_period_id
923: AND invoice_date = p_invoice_date
924: AND var_rent_id = p_var_rent_id;
925:

Line 929: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

925:
926: UPDATE pn_var_vol_hist_all
927: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
928: last_update_date = SYSDATE,
929: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
930: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
931: WHERE period_id = p_period_id
932: AND p_rent_type = 'FORECASTED'
933: AND grp_date_id IN

Line 930: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

926: UPDATE pn_var_vol_hist_all
927: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
928: last_update_date = SYSDATE,
929: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
930: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
931: WHERE period_id = p_period_id
932: AND p_rent_type = 'FORECASTED'
933: AND grp_date_id IN
934: (SELECT grp_date_id

Line 946: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

942: UPDATE pn_var_vol_hist_all
943: SET actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
944: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
945: last_update_date = SYSDATE,
946: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
947: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
948: WHERE period_id = p_period_id
949: AND vol_hist_status_code = 'APPROVED'
950: AND p_rent_type <> 'FORECASTED'

Line 947: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

943: SET actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
944: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
945: last_update_date = SYSDATE,
946: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
947: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
948: WHERE period_id = p_period_id
949: AND vol_hist_status_code = 'APPROVED'
950: AND p_rent_type <> 'FORECASTED'
951: AND grp_date_id IN

Line 966: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

962: IF p_rent_type in ('ACTUAL','VARIANCE') THEN
963: UPDATE pn_var_deductions_all
964: SET exported_code = 'Y',
965: last_update_date = SYSDATE,
966: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
968: WHERE period_id = p_period_id
969: AND grp_date_id IN
970: (SELECT grp_date_id

Line 967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

963: UPDATE pn_var_deductions_all
964: SET exported_code = 'Y',
965: last_update_date = SYSDATE,
966: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
967: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
968: WHERE period_id = p_period_id
969: AND grp_date_id IN
970: (SELECT grp_date_id
971: FROM pn_var_grp_dates_all

Line 986: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

982: SET forecasted_exp_code = decode(p_rent_type,'FORECASTED','Y',forecasted_exp_code),
983: actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
984: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
985: last_update_date = SYSDATE,
986: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
987: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
988: WHERE period_id = p_period_id
989: AND var_rent_id = p_var_rent_id;
990:

Line 987: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

983: actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
984: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
985: last_update_date = SYSDATE,
986: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
987: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
988: WHERE period_id = p_period_id
989: AND var_rent_id = p_var_rent_id;
990:
991: UPDATE pn_var_vol_hist_all

Line 995: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

991: UPDATE pn_var_vol_hist_all
992: SET actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
993: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
994: last_update_date = SYSDATE,
995: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
996: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
997: WHERE period_id = p_period_id
998: AND vol_hist_status_code = 'APPROVED'
999: AND p_rent_type <> 'FORECASTED'

Line 996: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

992: SET actual_exp_code = decode(p_rent_type,'ACTUAL','Y',actual_exp_code),
993: variance_exp_code = decode(p_rent_type,'VARIANCE','Y',variance_exp_code),
994: last_update_date = SYSDATE,
995: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
996: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
997: WHERE period_id = p_period_id
998: AND vol_hist_status_code = 'APPROVED'
999: AND p_rent_type <> 'FORECASTED'
1000: AND grp_date_id IN

Line 1008: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),

1004:
1005: UPDATE pn_var_deductions_all
1006: SET exported_code = 'Y',
1007: last_update_date = SYSDATE,
1008: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
1009: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
1010: WHERE period_id = p_period_id
1011: AND p_rent_type <> 'FORECASTED'
1012: AND grp_date_id IN

Line 1009: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

1005: UPDATE pn_var_deductions_all
1006: SET exported_code = 'Y',
1007: last_update_date = SYSDATE,
1008: last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0),
1009: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)
1010: WHERE period_id = p_period_id
1011: AND p_rent_type <> 'FORECASTED'
1012: AND grp_date_id IN
1013: (SELECT grp_date_id