DBA Data[Home] [Help]

APPS.PNT_PAYMENT_TERMS_PKG dependencies on FND_PROFILE

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

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

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

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

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

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

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

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