DBA Data[Home] [Help]

APPS.JTF_UM_USERTYPES_PKG dependencies on FND_GLOBAL

Line 457: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

453: begin
454:
455: UPDATE JTF_UM_USERTYPE_TMPL SET
456: EFFECTIVE_END_DATE = SYSDATE,
457: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
458: LAST_UPDATE_DATE= SYSDATE
459: WHERE USERTYPE_ID = X_USERTYPE_ID;
460:
461: end REMOVE_TEMPLATE_ASSIGNMENT;

Line 468: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,

464: X_USERTYPE_ID IN NUMBER,
465: X_TEMPLATE_ID IN NUMBER,
466: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
467: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
468: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
469: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
470: ) is
471: begin
472:

Line 469: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID

465: X_TEMPLATE_ID IN NUMBER,
466: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
467: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
468: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
469: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
470: ) is
471: begin
472:
473: INSERT INTO JTF_UM_USERTYPE_TMPL(

Line 612: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,

608: begin
609:
610: UPDATE JTF_UM_USERTYPE_SUBSCRIP SET
611: EFFECTIVE_END_DATE = SYSDATE,
612: LAST_UPDATED_BY=FND_GLOBAL.USER_ID,
613: LAST_UPDATE_DATE= SYSDATE
614: WHERE USERTYPE_ID = X_USERTYPE_ID
615: AND SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;
616:

Line 626: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,

622: X_SUBSCRIPTION_FLAG VARCHAR2,
623: X_DISPLAY_ORDER NUMBER,
624: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
625: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
626: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
627: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
628: ) is
629: begin
630: INSERT INTO JTF_UM_USERTYPE_SUBSCRIP(

Line 627: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID

623: X_DISPLAY_ORDER NUMBER,
624: X_EFFECTIVE_START_DATE IN DATE DEFAULT SYSDATE,
625: X_EFFECTIVE_END_DATE IN DATE DEFAULT NULL,
626: X_CREATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID,
627: X_LAST_UPDATED_BY IN NUMBER DEFAULT FND_GLOBAL.USER_ID
628: ) is
629: begin
630: INSERT INTO JTF_UM_USERTYPE_SUBSCRIP(
631: USERTYPE_ID,