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

Line 196: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144

192: UPDATE pn_payment_items
193: SET accounted_amount = l_accounted_amt,
194: accounted_date = l_accounted_date,
195: last_update_date = SYSDATE, --Bug#5389144
196: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
197: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
198: WHERE payment_item_id = payment_item_rec.payment_item_id;
199:
200: END IF;

Line 197: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144

193: SET accounted_amount = l_accounted_amt,
194: accounted_date = l_accounted_date,
195: last_update_date = SYSDATE, --Bug#5389144
196: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
197: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
198: WHERE payment_item_id = payment_item_rec.payment_item_id;
199:
200: END IF;
201:

Line 212: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144

208: accounted_date = l_accounted_date,
209: RATE = payment_item_rec.RATE,
210: CURRENCY_CODE = payment_item_rec.currency_code,
211: last_update_date = SYSDATE, --Bug#5389144
212: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
213: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
214: WHERE payment_item_id = l_norm_payment_item_id;
215:
216: END IF;

Line 213: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144

209: RATE = payment_item_rec.RATE,
210: CURRENCY_CODE = payment_item_rec.currency_code,
211: last_update_date = SYSDATE, --Bug#5389144
212: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
213: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
214: WHERE payment_item_id = l_norm_payment_item_id;
215:
216: END IF;
217:

Line 740: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144

736: 'THIRD_PARTY','Y',
737: 'SUB_LEASE' ,'Y',
738: NULL),
739: last_update_date = SYSDATE, --Bug#5389144
740: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
741: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
742: WHERE payment_item_type_lookup_code = 'CASH'
743: AND payment_schedule_id = l_payment_schedule_id;
744:

Line 741: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144

737: 'SUB_LEASE' ,'Y',
738: NULL),
739: last_update_date = SYSDATE, --Bug#5389144
740: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
741: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
742: WHERE payment_item_type_lookup_code = 'CASH'
743: AND payment_schedule_id = l_payment_schedule_id;
744:
745: /* Approve the schedule */

Line 748: approved_by_user_id = fnd_profile.value('USER_ID'),

744:
745: /* Approve the schedule */
746: UPDATE PN_PAYMENT_SCHEDULES
747: SET payment_status_lookup_code = 'APPROVED',
748: approved_by_user_id = fnd_profile.value('USER_ID'),
749: approval_date = SYSDATE,
750: period_name = l_period_name,
751: last_update_date = SYSDATE, --Bug#5389144
752: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144

Line 752: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144

748: approved_by_user_id = fnd_profile.value('USER_ID'),
749: approval_date = SYSDATE,
750: period_name = l_period_name,
751: last_update_date = SYSDATE, --Bug#5389144
752: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
753: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
754: WHERE payment_schedule_id = l_payment_schedule_id;
755:
756: END IF;

Line 753: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144

749: approval_date = SYSDATE,
750: period_name = l_period_name,
751: last_update_date = SYSDATE, --Bug#5389144
752: last_updated_by = NVL(fnd_profile.value('USER_ID'),0), --Bug#5389144
753: last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0) --Bug#5389144
754: WHERE payment_schedule_id = l_payment_schedule_id;
755:
756: END IF;
757: