DBA Data[Home] [Help]

APPS.JTF_UM_USERTYPES_PKG dependencies on JTF_UM_USERTYPES_B_S

Line 51: JTF_UM_USERTYPES_B_S.NEXTVAL,

47: X_ENABLED_FLAG,
48: X_EMAIL_NOTIFICATION_FLAG,
49: X_IS_SELF_SERVICE_FLAG,
50: X_EFFECTIVE_START_DATE,
51: JTF_UM_USERTYPES_B_S.NEXTVAL,
52: X_USERTYPE_KEY,
53: X_CREATION_DATE,
54: X_CREATED_BY,
55: X_LAST_UPDATE_DATE,

Line 196: update JTF_UM_USERTYPES_B set

192: X_USERTYPE_SHORTNAME in VARCHAR2,
193: X_DISPLAY_ORDER in NUMBER
194: ) is
195: begin
196: update JTF_UM_USERTYPES_B set
197: EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
198: APPROVAL_ID = X_APPROVAL_ID,
199: APPLICATION_ID = X_APPLICATION_ID,
200: ENABLED_FLAG = X_ENABLED_FLAG,

Line 916: update JTF_UM_USERTYPES_B set

912: begin
913: --if (x_owner = 'SEED') then
914: -- l_user_id := 1;
915: --end if;
916: update JTF_UM_USERTYPES_B set
917: LAST_UPDATE_LOGIN = l_user_id,
918: LAST_UPDATE_DATE = SYSDATE,
919: DISPLAY_ORDER = X_DISPLAY_ORDER
920: where USERTYPE_ID = X_USERTYPE_ID;