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_NORM_RENORM_PKG dependencies on FND_PROFILE

Line 417: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

413: UPDATE pn_payment_items_all ppi
414: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
415: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
416: ppi.last_update_date = SYSDATE,
417: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
418: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
419: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
420: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
421: AND ppi.payment_term_id = p_term_id;

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

414: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
415: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
416: ppi.last_update_date = SYSDATE,
417: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
418: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
419: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
420: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
421: AND ppi.payment_term_id = p_term_id;
422:

Line 460: NVL(fnd_profile.value('USER_ID'),0),

456: VALUES
457: (
458: PN_PAYMENT_ITEMS_S.NEXTVAL,
459: SYSDATE,
460: NVL(fnd_profile.value('USER_ID'),0),
461: SYSDATE,
462: NVL(fnd_profile.value('USER_ID'),0),
463: NVL(fnd_profile.value('LOGIN_ID'),0),
464: g_norm_item_tbl(i).normalized_amount,

Line 462: NVL(fnd_profile.value('USER_ID'),0),

458: PN_PAYMENT_ITEMS_S.NEXTVAL,
459: SYSDATE,
460: NVL(fnd_profile.value('USER_ID'),0),
461: SYSDATE,
462: NVL(fnd_profile.value('USER_ID'),0),
463: NVL(fnd_profile.value('LOGIN_ID'),0),
464: g_norm_item_tbl(i).normalized_amount,
465: NULL,
466: g_norm_item_tbl(i).schedule_date,

Line 463: NVL(fnd_profile.value('LOGIN_ID'),0),

459: SYSDATE,
460: NVL(fnd_profile.value('USER_ID'),0),
461: SYSDATE,
462: NVL(fnd_profile.value('USER_ID'),0),
463: NVL(fnd_profile.value('LOGIN_ID'),0),
464: g_norm_item_tbl(i).normalized_amount,
465: NULL,
466: g_norm_item_tbl(i).schedule_date,
467: 'NORMALIZED',

Line 876: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),

872: UPDATE pn_payment_items_all ppi
873: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
874: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
875: ppi.last_update_date = SYSDATE,
876: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
877: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
878: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
879: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
880: AND ppi.payment_term_id = p_term_id;

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

873: SET ppi.actual_amount = g_norm_item_tbl(i).normalized_amount,
874: ppi.export_currency_amount = g_norm_item_tbl(i).normalized_amount,
875: ppi.last_update_date = SYSDATE,
876: ppi.last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
877: ppi.last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
878: WHERE ppi.payment_schedule_id = g_norm_item_tbl(i).schedule_id
879: AND ppi.payment_item_type_lookup_code = 'NORMALIZED'
880: AND ppi.payment_term_id = p_term_id;
881:

Line 916: NVL(fnd_profile.value('USER_ID'),0),

912: org_id)
913: VALUES
914: (PN_PAYMENT_ITEMS_S.NEXTVAL,
915: SYSDATE,
916: NVL(fnd_profile.value('USER_ID'),0),
917: SYSDATE,
918: NVL(fnd_profile.value('USER_ID'),0),
919: NVL(fnd_profile.value('LOGIN_ID'),0),
920: g_norm_item_tbl(i).normalized_amount,

Line 918: NVL(fnd_profile.value('USER_ID'),0),

914: (PN_PAYMENT_ITEMS_S.NEXTVAL,
915: SYSDATE,
916: NVL(fnd_profile.value('USER_ID'),0),
917: SYSDATE,
918: NVL(fnd_profile.value('USER_ID'),0),
919: NVL(fnd_profile.value('LOGIN_ID'),0),
920: g_norm_item_tbl(i).normalized_amount,
921: NULL,
922: g_norm_item_tbl(i).schedule_date,

Line 919: NVL(fnd_profile.value('LOGIN_ID'),0),

915: SYSDATE,
916: NVL(fnd_profile.value('USER_ID'),0),
917: SYSDATE,
918: NVL(fnd_profile.value('USER_ID'),0),
919: NVL(fnd_profile.value('LOGIN_ID'),0),
920: g_norm_item_tbl(i).normalized_amount,
921: NULL,
922: g_norm_item_tbl(i).schedule_date,
923: 'NORMALIZED',