APPS.CSL_USER_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 13: FROM JTF_RS_RESOURCE_EXTNS

9: PROCEDURE CREATE_USER( p_resource_id IN NUMBER
10: , x_return_status OUT NOCOPY VARCHAR2 ) IS
11: CURSOR c_user( b_resource_id NUMBER ) IS
12: SELECT USER_ID
13: FROM JTF_RS_RESOURCE_EXTNS
14: WHERE RESOURCE_ID = b_resource_id;
15: r_user NUMBER;
16: BEGIN
17: /*** get debug level ***/

Line 46: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')

42: END IF;
43: CLOSE c_user;
44:
45: JTM_HOOK_UTIL_PKG.Insert_Acc
46: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
47: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
48: ,P_PK1_NAME => 'RESOURCE_PK'
49: ,P_PK1_NUM_VALUE => P_RESOURCE_ID
50: ,P_RESOURCE_ID => P_RESOURCE_ID

Line 47: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'

43: CLOSE c_user;
44:
45: JTM_HOOK_UTIL_PKG.Insert_Acc
46: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
47: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
48: ,P_PK1_NAME => 'RESOURCE_PK'
49: ,P_PK1_NUM_VALUE => P_RESOURCE_ID
50: ,P_RESOURCE_ID => P_RESOURCE_ID
51: );

Line 276: /* TODO add jtf_RS_resource_EXTNS and JTF_group_members and fnd_user*/

272: x_return_status := FND_API.G_RET_STS_ERROR;
273: END CREATE_USER;
274:
275: /* Put all delete_user procedures here */
276: /* TODO add jtf_RS_resource_EXTNS and JTF_group_members and fnd_user*/
277: PROCEDURE DELETE_USER( p_resource_id IN NUMBER
278: , x_return_status OUT NOCOPY VARCHAR2 ) IS
279: BEGIN
280: /*** get debug level ***/

Line 814: , 'Delete from JTM_JTF_RS_RESOURCE_EXTNS_ACC for resource '||p_resource_id

810: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
811: jtm_message_log_pkg.Log_Msg
812: ( null
813: , g_table_name
814: , 'Delete from JTM_JTF_RS_RESOURCE_EXTNS_ACC for resource '||p_resource_id
815: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
816: , 'csl_user_pkg');
817: END IF;
818: DELETE JTM_JTF_RS_RESOURCE_EXTNS_ACC

Line 818: DELETE JTM_JTF_RS_RESOURCE_EXTNS_ACC

814: , 'Delete from JTM_JTF_RS_RESOURCE_EXTNS_ACC for resource '||p_resource_id
815: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
816: , 'csl_user_pkg');
817: END IF;
818: DELETE JTM_JTF_RS_RESOURCE_EXTNS_ACC
819: WHERE RESOURCE_ID = p_resource_id;
820: COMMIT;
821:
822: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN