DBA Data[Home] [Help]

APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on FND_GLOBAL

Line 494: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

490: begin
491:
492: UPDATE JTF_UM_SUBSCRIPTION_TMPL SET
493: EFFECTIVE_END_DATE = SYSDATE,
494: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
495: LAST_UPDATE_DATE= SYSDATE
496: WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID ;
497:
498: end REMOVE_TEMPLATE_ASSIGNMENT;

Line 505: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,

501: X_SUBSCRIPTION_ID IN NUMBER,
502: X_TEMPLATE_ID IN NUMBER,
503: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
504: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
505: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
506: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
507: ) is
508: begin
509:

Line 506: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID

502: X_TEMPLATE_ID IN NUMBER,
503: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
504: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
505: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
506: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
507: ) is
508: begin
509:
510: INSERT INTO JTF_UM_SUBSCRIPTION_TMPL(