DBA Data[Home] [Help]

APPS.PAP_CMERGE_BB2 dependencies on STANDARD

Line 339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

335: --
336: UPDATE pa_project_contacts PC
337: SET CUSTOMER_ID = var_racm_customer_id,
338: LAST_UPDATE_DATE = SYSDATE,
339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
341: WHERE
342: PC.PROJECT_ID = var_project_id
343: AND PC.CUSTOMER_ID = var_customer_id;

Line 340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

336: UPDATE pa_project_contacts PC
337: SET CUSTOMER_ID = var_racm_customer_id,
338: LAST_UPDATE_DATE = SYSDATE,
339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
341: WHERE
342: PC.PROJECT_ID = var_project_id
343: AND PC.CUSTOMER_ID = var_customer_id;
344: --

Line 433: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

429:
430: UPDATE pa_project_contacts PC
431: SET BILL_SHIP_CUSTOMER_ID = var_racm_customer_id,
432: LAST_UPDATE_DATE = SYSDATE,
433: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
434: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
435: WHERE
436: PC.PROJECT_ID = var_project_id
437: AND PC.CUSTOMER_ID = var_customer_id

Line 434: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

430: UPDATE pa_project_contacts PC
431: SET BILL_SHIP_CUSTOMER_ID = var_racm_customer_id,
432: LAST_UPDATE_DATE = SYSDATE,
433: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
434: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
435: WHERE
436: PC.PROJECT_ID = var_project_id
437: AND PC.CUSTOMER_ID = var_customer_id
438: AND PC.BILL_SHIP_CUSTOMER_ID=var_bill_ship_customer_id;