DBA Data[Home] [Help]

APPS.PNT_PAYMENT_TERMS_PKG dependencies on FND_PROFILE

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

1696: SET estimated_amount = ROUND(l_est_amt, l_precision)
1697: ,actual_amount = ROUND(l_act_amt, l_precision)
1698: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1699: ,last_update_date = SYSDATE
1700: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
1701: ,last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
1702: WHERE payment_item_id = pnt_rec.payment_item_id;
1703:
1704: EXIT;

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

1697: ,actual_amount = ROUND(l_act_amt, l_precision)
1698: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1699: ,last_update_date = SYSDATE
1700: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
1701: ,last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
1702: WHERE payment_item_id = pnt_rec.payment_item_id;
1703:
1704: EXIT;
1705: END LOOP;

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

1795: SET estimated_amount = ROUND(l_est_amt, l_precision)
1796: ,actual_amount = ROUND(l_act_amt, l_precision)
1797: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1798: ,last_update_date = SYSDATE
1799: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
1800: ,last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
1801: WHERE payment_item_id = pnt_rec.payment_item_id;
1802:
1803: END LOOP;

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

1796: ,actual_amount = ROUND(l_act_amt, l_precision)
1797: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1798: ,last_update_date = SYSDATE
1799: ,last_updated_by = NVL(fnd_profile.value('USER_ID'),0)
1800: ,last_update_login= NVL(fnd_profile.value('LOGIN_ID'),0)
1801: WHERE payment_item_id = pnt_rec.payment_item_id;
1802:
1803: END LOOP;
1804: