APPS.JTF_UM_USERTYPES_PKG dependencies on JTF_UM_USERTYPE_SUBSCRIP

Line 610: UPDATE JTF_UM_USERTYPE_SUBSCRIP SET

606: X_SUBSCRIPTION_ID IN NUMBER
607: ) is
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

Line 630: INSERT INTO JTF_UM_USERTYPE_SUBSCRIP(

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,
632: SUBSCRIPTION_ID,
633: SUBSCRIPTION_FLAG,
634: SUBSCRIPTION_DISPLAY_ORDER,

Line 662: update JTF_UM_USERTYPE_SUBSCRIP

658: X_SUBSCRIPTION_FLAG VARCHAR2,
659: X_DISPLAY_ORDER NUMBER
660: ) is
661: begin
662: update JTF_UM_USERTYPE_SUBSCRIP
663: set SUBSCRIPTION_FLAG=X_SUBSCRIPTION_FLAG,
664: SUBSCRIPTION_DISPLAY_ORDER = X_DISPLAY_ORDER
665: where USERTYPE_ID = X_USERTYPE_ID
666: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID;

Line 682: update JTF_UM_USERTYPE_SUBSCRIP

678: X_LAST_UPDATED_BY IN NUMBER,
679: X_LAST_UPDATE_LOGIN IN NUMBER
680: ) is
681: begin
682: update JTF_UM_USERTYPE_SUBSCRIP
683: set SUBSCRIPTION_FLAG=X_SUBSCRIPTION_FLAG,
684: SUBSCRIPTION_DISPLAY_ORDER = X_DISPLAY_ORDER,
685: EFFECTIVE_END_DATE = X_EFFECTIVE_END_DATE,
686: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 720: from jtf_UM_USERTYPE_SUBSCRIP

716: -- end if;
717:
718: select count(*)
719: into h_record_exists
720: from jtf_UM_USERTYPE_SUBSCRIP
721: where USERTYPE_ID = X_USERTYPE_ID
722: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
723: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
724:

Line 751: FROM JTF_UM_USERTYPE_SUBSCRIP

747: -- there is a row for this app_id and this app_short_name
748: -- Exception is thrown otherwise.
749: select LAST_UPDATED_BY, LAST_UPDATE_DATE
750: into db_luby, db_ludate
751: FROM JTF_UM_USERTYPE_SUBSCRIP
752: where USERTYPE_ID = X_USERTYPE_ID
753: and SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
754: and EFFECTIVE_START_DATE = X_EFFECTIVE_START_DATE;
755: