APPS.JTM_WRAPPER_PKG dependencies on ASG_USER

Line 232: from JTM_ASG_USER_ACC

228: ,P_RESOURCE_ID => P_RESOURCE_ID
229: );
230: BEGIN
231: select count(*) into l_count
232: from JTM_ASG_USER_ACC
233: where USER_ID = P_USER_ID;
234: if (l_count = 0) then
235: Insert into JTM_ASG_USER_ACC
236: (ACCESS_ID,USER_ID,COUNTER,

Line 235: Insert into JTM_ASG_USER_ACC

231: select count(*) into l_count
232: from JTM_ASG_USER_ACC
233: where USER_ID = P_USER_ID;
234: if (l_count = 0) then
235: Insert into JTM_ASG_USER_ACC
236: (ACCESS_ID,USER_ID,COUNTER,
237: LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY)
238: VALUES (JTM_ACC_TABLE_S.NEXTVAL,P_USER_ID,1,sysdate,1,sysdate,1);
239: end if;

Line 257: delete from JTM_ASG_USER_ACC where user_id = P_USER_ID;

253: ,P_PK1_NAME => 'USER_ID'
254: ,P_PK1_NUM_VALUE => P_USER_ID
255: ,P_RESOURCE_ID => P_RESOURCE_ID
256: );
257: delete from JTM_ASG_USER_ACC where user_id = P_USER_ID;
258: END DELETE_USER_RECORD;
259:
260:
261: PROCEDURE POPULATE_ACCESS_RECORDS( P_USER_ID IN NUMBER )

Line 266: FROM ASG_USER

262: IS
263: PRAGMA AUTONOMOUS_TRANSACTION;
264: CURSOR c_user( b_user_id NUMBER ) IS
265: SELECT RESOURCE_ID
266: FROM ASG_USER
267: WHERE USER_ID = b_user_id;
268: r_user c_user%ROWTYPE;
269:
270: return_value1 BOOLEAN ;

Line 345: FROM ASG_USER

341: IS
342: PRAGMA AUTONOMOUS_TRANSACTION;
343: CURSOR c_user( b_user_id NUMBER ) IS
344: SELECT RESOURCE_ID
345: FROM ASG_USER
346: WHERE USER_ID = b_user_id;
347: r_user c_user%ROWTYPE;
348: BEGIN
349: OPEN c_user( P_USER_ID );