DBA Data[Home] [Help]

APPS.JTM_WRAPPER_PKG dependencies on JTM_ASG_USER_ACC

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 )