APPS.JTF_UM_SUBSCRIPTIONS_PKG dependencies on JTF_UM_SUBSCRIPTION_REG

Line 662: insert into JTF_UM_SUBSCRIPTION_REG (

658: X_GRANT_DELEGATION_FLAG in VARCHAR2
659:
660: ) is
661: begin
662: insert into JTF_UM_SUBSCRIPTION_REG (
663: LAST_APPROVER_COMMENT,
664: APPROVER_USER_ID,
665: EFFECTIVE_END_DATE,
666: WF_ITEM_TYPE,

Line 752: UPDATE JTF_UM_SUBSCRIPTION_REG SET GRANT_DELEGATION_FLAG = l_flag_value

748: l_flag_value := 'Y';
749:
750: end if;
751:
752: UPDATE JTF_UM_SUBSCRIPTION_REG SET GRANT_DELEGATION_FLAG = l_flag_value
753: WHERE SUBSCRIPTION_REG_ID = p_subscription_reg_id ;
754:
755: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
756: p_message => l_procedure_name

Line 802: FROM FND_USER FU, JTF_UM_SUBSCRIPTION_REG SUBREG

798: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
799: l_flag_value VARCHAR2(1) := 'N';
800:
801: CURSOR FIND_PRINCIPAL_NAME IS SELECT FU.USER_NAME, SUBREG.SUBSCRIPTION_ID
802: FROM FND_USER FU, JTF_UM_SUBSCRIPTION_REG SUBREG
803: WHERE FU.USER_ID = SUBREG.USER_ID
804: AND SUBREG.SUBSCRIPTION_REG_ID = p_subscription_reg_id;
805:
806: l_principal_name FND_USER.USER_NAME%TYPE;

Line 830: UPDATE JTF_UM_SUBSCRIPTION_REG SET GRANT_DELEGATION_FLAG = l_flag_value

826: l_flag_value := 'Y';
827:
828: end if;
829:
830: UPDATE JTF_UM_SUBSCRIPTION_REG SET GRANT_DELEGATION_FLAG = l_flag_value
831: WHERE SUBSCRIPTION_REG_ID = p_subscription_reg_id ;
832:
833: -- Grant the delegation role, if required
834: IF p_grant_delegation_role = 1 AND p_grant_delegation_flag = 1 THEN

Line 978: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU

974:
975: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
976:
977: CURSOR FIND_REG_ID IS SELECT SUBSCRIPTION_REG_ID
978: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU
979: WHERE SUBSCRIPTION_ID = p_subscription_id
980: AND SUBREG.USER_ID = FU.USER_ID
981: AND FU.USER_NAME = p_user_name
982: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;

Line 984: l_subscription_reg_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID%TYPE;

980: AND SUBREG.USER_ID = FU.USER_ID
981: AND FU.USER_NAME = p_user_name
982: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;
983:
984: l_subscription_reg_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID%TYPE;
985:
986: begin
987:
988: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

Line 1128: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU

1124: ) is
1125:
1126: l_procedure_name CONSTANT varchar2(30) := 'update_grant_delegation_flag';
1127: CURSOR FIND_REG_ID IS SELECT SUBSCRIPTION_REG_ID
1128: FROM JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU
1129: WHERE SUBSCRIPTION_ID = p_subscription_id
1130: AND SUBREG.USER_ID = FU.USER_ID
1131: AND FU.USER_ID = p_user_id
1132: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;

Line 1134: l_subscription_reg_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID%TYPE;

1130: AND SUBREG.USER_ID = FU.USER_ID
1131: AND FU.USER_ID = p_user_id
1132: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;
1133:
1134: l_subscription_reg_id JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_REG_ID%TYPE;
1135:
1136: begin
1137:
1138: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

Line 1305: * from the table JTF_UM_SUBSCRIPTION_REG

1301: * Procedure : get_grant_delegation_flag
1302: * Type : Private
1303: * Pre_reqs : None
1304: * Description : Will return the value of the column grant_delegation_flag
1305: * from the table JTF_UM_SUBSCRIPTION_REG
1306: * Parameters :
1307: * input parameters
1308: * @param p_subscription_id
1309: * description: The subscription_id of an enrollment

Line 1322: * or there is no matching record in JTF_UM_SUBSCRIPTION_REG table

1318: *
1319: * Note:
1320: *
1321: * This API will raise an exception, if subscription_id or user_id is invalid
1322: * or there is no matching record in JTF_UM_SUBSCRIPTION_REG table
1323: *
1324: */
1325:
1326: procedure get_grant_delegation_flag(

Line 1334: CURSOR FIND_DELEGATION_FLAG IS SELECT GRANT_DELEGATION_FLAG FROM JTF_UM_SUBSCRIPTION_REG

1330: ) IS
1331:
1332: l_procedure_name CONSTANT varchar2(30) := 'get_grant_delegation_flag';
1333:
1334: CURSOR FIND_DELEGATION_FLAG IS SELECT GRANT_DELEGATION_FLAG FROM JTF_UM_SUBSCRIPTION_REG
1335: WHERE SUBSCRIPTION_ID = p_subscription_id AND USER_ID = p_user_id
1336: AND NVL(EFFECTIVE_END_DATE, SYSDATE+1) > SYSDATE;
1337:
1338: l_flag_value varchar2(1);