APPS.JTF_UM_ENROLLMENT_CREDENTIALS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

 Removed this direct update call as fnd_user_resp_groups is no
 longer a table. Converted this call to use an API instead.

UPDATE FND_USER_RESP_GROUPS SET END_DATE = SYSDATE
WHERE USER_ID = X_USER_ID
AND   RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
AND   RESPONSIBILITY_APPLICATION_ID = X_APPLICATION_ID;

Line: 71

CURSOR RESP_KEY IS SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;

Line: 103

CURSOR RESP_KEY_ID IS SELECT RESPONSIBILITY_ID
FROM FND_RESPONSIBILITY_VL
WHERE RESPONSIBILITY_KEY = X_RESPONSIBILITY_KEY;

Line: 146

CURSOR SUBSCRIPTION_RESP is select FR.RESPONSIBILITY_ID, FR.APPLICATION_ID, FR.VERSION FROM
JTF_UM_SUBSCRIPTION_RESP SB,
FND_RESPONSIBILITY_VL FR
WHERE SB.SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
AND   SB.RESPONSIBILITY_KEY = FR.RESPONSIBILITY_KEY
AND   SB.APPLICATION_ID = FR.APPLICATION_ID
AND   (SB.EFFECTIVE_END_DATE IS NULL OR SB.EFFECTIVE_END_DATE > SYSDATE)
AND   SB.EFFECTIVE_START_DATE < SYSDATE;

Line: 155

CURSOR SUBSCRIPTION_ROLES IS SELECT PRINCIPAL_NAME
FROM JTF_UM_SUBSCRIPTION_ROLE
WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
AND   (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE)
AND   EFFECTIVE_START_DATE < SYSDATE;

Line: 242

UPDATE JTF_UM_SUBSCRIPTION_REG SET STATUS_CODE='APPROVED'
WHERE SUBSCRIPTION_ID = X_SUBSCRIPTION_ID
AND USER_ID = X_USER_ID;

Line: 296

SELECT reg.WF_ITEM_TYPE, to_char (reg.SUBSCRIPTION_REG_ID)
FROM   JTF_UM_SUBSCRIPTION_REG reg, FND_USER fu
WHERE  fu.USER_NAME = P_USERNAME
AND    fu.USER_ID = reg.USER_ID
AND    STATUS_CODE = 'PENDING'
AND    (reg.EFFECTIVE_END_DATE is null
OR      reg.EFFECTIVE_END_DATE > sysdate);

Line: 313

    JTF_UM_WF_APPROVAL.COMPLETEAPPROVALACTIVITY (itemtype, itemkey, 'REJECTED', 'User deleted');

Line: 358

    select wf_item_type
    from   jtf_um_approvals_b
    where  approval_id = p_approval_id
    and    effective_start_date < sysdate
    and    nvl (effective_end_date, sysdate + 1) > sysdate;

Line: 365

    select status_code
    from   jtf_um_usertype_reg
    where  user_id = p_user_id
    and    effective_start_date <= sysdate
    and    nvl (effective_end_date, sysdate + 1) > sysdate;

Line: 409

    JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW (
        X_SUBSCRIPTION_ID       => p_enrollment_id,
        X_LAST_APPROVER_COMMENT => null,
        X_APPROVER_USER_ID      => null,
        X_EFFECTIVE_END_DATE    => null,
        X_WF_ITEM_TYPE          => l_wf_item_type,
        X_EFFECTIVE_START_DATE  => SYSDATE,
        X_SUBSCRIPTION_REG_ID   => x_enrollment_reg_id,
        X_USER_ID               => p_user_id,
        X_STATUS_CODE           => 'PENDING',
        X_CREATION_DATE         => SYSDATE,
        X_CREATED_BY            => FND_GLOBAL.USER_ID,
        X_LAST_UPDATE_DATE      => SYSDATE,
        X_LAST_UPDATED_BY       => FND_GLOBAL.USER_ID,
        X_LAST_UPDATE_LOGIN     => FND_GLOBAL.CONC_LOGIN_ID,
        X_GRANT_DELEGATION_FLAG => p_delegate_flag);