[Home] [Help]
1822: else
1823: l_bool_flag := false;
1824: end if;
1825:
1826: JTF_UM_SUBSCRIPTIONS_PKG.UPDATE_GRANT_DELEGATION_FLAG (
1827: P_SUBSCRIPTION_ID => l_request_id,
1828: P_USER_ID => l_requesterUserID,
1829: P_GRANT_DELEGATION_FLAG => l_bool_flag);
1830:
3407: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3408: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;
3409:
3410: -- create record in JTF_UM_SUBSCRIPTION_REG table
3411: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW
3412: (X_SUBSCRIPTION_ID => p_subscription_id,
3413: X_LAST_APPROVER_COMMENT => null,
3414: X_APPROVER_USER_ID => null,
3415: X_EFFECTIVE_END_DATE => null,
3437: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
3438: where SUBSCRIPTION_REG_ID = p_subscription_reg_id;
3439:
3440: -- create record in JTF_UM_SUBSCRIPTION_REG table
3441: JTF_UM_SUBSCRIPTIONS_PKG.INSERT_SUBREG_ROW
3442: (X_SUBSCRIPTION_ID => p_subscription_id,
3443: X_LAST_APPROVER_COMMENT => null,
3444: X_APPROVER_USER_ID => null,
3445: X_EFFECTIVE_END_DATE => null,