DBA Data[Home] [Help]

APPS.PVX_PRTNR_PRFLS_PVT dependencies on FND_GLOBAL

Line 196: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY

192: )
193: VALUES (
194: l_prtnr_prfls_rec.partner_profile_id
195: ,SYSDATE -- LAST_UPDATE_DATE
196: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
197: ,SYSDATE -- CREATION_DATE
198: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
199: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
200: ,l_prtnr_prfls_rec.partner_id

Line 198: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY

194: l_prtnr_prfls_rec.partner_profile_id
195: ,SYSDATE -- LAST_UPDATE_DATE
196: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
197: ,SYSDATE -- CREATION_DATE
198: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
199: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
200: ,l_prtnr_prfls_rec.partner_id
201: ,l_prtnr_prfls_rec.target_revenue_amt
202: ,l_prtnr_prfls_rec.actual_revenue_amt

Line 199: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN

195: ,SYSDATE -- LAST_UPDATE_DATE
196: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
197: ,SYSDATE -- CREATION_DATE
198: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
199: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
200: ,l_prtnr_prfls_rec.partner_id
201: ,l_prtnr_prfls_rec.target_revenue_amt
202: ,l_prtnr_prfls_rec.actual_revenue_amt
203: ,l_prtnr_prfls_rec.target_revenue_pct

Line 725: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)

721: END IF;
722:
723: UPDATE PV_PARTNER_PROFILES SET
724: last_update_date = SYSDATE
725: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
726: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
727: ,PARTNER_ID = l_prtnr_prfls_rec.PARTNER_ID
728: ,TARGET_REVENUE_AMT = l_prtnr_prfls_rec.TARGET_REVENUE_AMT
729: ,ACTUAL_REVENUE_AMT = l_prtnr_prfls_rec.ACTUAL_REVENUE_AMT

Line 726: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)

722:
723: UPDATE PV_PARTNER_PROFILES SET
724: last_update_date = SYSDATE
725: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
726: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
727: ,PARTNER_ID = l_prtnr_prfls_rec.PARTNER_ID
728: ,TARGET_REVENUE_AMT = l_prtnr_prfls_rec.TARGET_REVENUE_AMT
729: ,ACTUAL_REVENUE_AMT = l_prtnr_prfls_rec.ACTUAL_REVENUE_AMT
730: ,TARGET_REVENUE_PCT = l_prtnr_prfls_rec.TARGET_REVENUE_PCT