APPS.JTM_WRAPPER_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 196: JTM_HOOK_UTIL_PKG.Insert_Acc

192: PROCEDURE INSERT_RESOURCE_RECORD( P_RESOURCE_ID IN NUMBER )
193: IS
194: BEGIN
195: /*** Insert current user's resource record ***/
196: JTM_HOOK_UTIL_PKG.Insert_Acc
197: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
198: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
199: ,P_PK1_NAME => 'RESOURCE_PK'
200: ,P_PK1_NUM_VALUE => P_RESOURCE_ID

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

193: IS
194: BEGIN
195: /*** Insert current user's resource record ***/
196: JTM_HOOK_UTIL_PKG.Insert_Acc
197: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
198: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
199: ,P_PK1_NAME => 'RESOURCE_PK'
200: ,P_PK1_NUM_VALUE => P_RESOURCE_ID
201: ,P_RESOURCE_ID => P_RESOURCE_ID

Line 209: JTM_HOOK_UTIL_PKG.Delete_Acc

205: PROCEDURE DELETE_RESOURCE_RECORD( P_RESOURCE_ID IN NUMBER )
206: IS
207: BEGIN
208: /*** Delete current user's resource record ***/
209: JTM_HOOK_UTIL_PKG.Delete_Acc
210: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
211: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
212: ,P_PK1_NAME => 'RESOURCE_PK'
213: ,P_PK1_NUM_VALUE => P_RESOURCE_ID

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

206: IS
207: BEGIN
208: /*** Delete current user's resource record ***/
209: JTM_HOOK_UTIL_PKG.Delete_Acc
210: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS')
211: ,P_ACC_TABLE_NAME => 'JTM_JTF_RS_RESOURCE_EXTNS_ACC'
212: ,P_PK1_NAME => 'RESOURCE_PK'
213: ,P_PK1_NUM_VALUE => P_RESOURCE_ID
214: ,P_RESOURCE_ID => P_RESOURCE_ID

Line 223: JTM_HOOK_UTIL_PKG.Insert_Acc

219: IS
220: l_count number;
221: BEGIN
222: l_count := 0;
223: JTM_HOOK_UTIL_PKG.Insert_Acc
224: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')
225: ,P_ACC_TABLE_NAME => 'JTM_FND_USER_ACC'
226: ,P_PK1_NAME => 'USER_ID'
227: ,P_PK1_NUM_VALUE => P_USER_ID

Line 224: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')

220: l_count number;
221: BEGIN
222: l_count := 0;
223: JTM_HOOK_UTIL_PKG.Insert_Acc
224: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')
225: ,P_ACC_TABLE_NAME => 'JTM_FND_USER_ACC'
226: ,P_PK1_NAME => 'USER_ID'
227: ,P_PK1_NUM_VALUE => P_USER_ID
228: ,P_RESOURCE_ID => P_RESOURCE_ID

Line 250: JTM_HOOK_UTIL_PKG.Delete_Acc

246: PROCEDURE DELETE_USER_RECORD( P_USER_ID IN NUMBER, P_RESOURCE_ID IN NUMBER )
247: IS
248: BEGIN
249: /*** Delete current user user's record ***/
250: JTM_HOOK_UTIL_PKG.Delete_Acc
251: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')
252: ,P_ACC_TABLE_NAME => 'JTM_FND_USER_ACC'
253: ,P_PK1_NAME => 'USER_ID'
254: ,P_PK1_NUM_VALUE => P_USER_ID

Line 251: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')

247: IS
248: BEGIN
249: /*** Delete current user user's record ***/
250: JTM_HOOK_UTIL_PKG.Delete_Acc
251: ( P_PUBLICATION_ITEM_NAMES => JTM_HOOK_UTIL_PKG.t_publication_item_list('FND_USER')
252: ,P_ACC_TABLE_NAME => 'JTM_FND_USER_ACC'
253: ,P_PK1_NAME => 'USER_ID'
254: ,P_PK1_NUM_VALUE => P_USER_ID
255: ,P_RESOURCE_ID => P_RESOURCE_ID

Line 302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

298:
299: IF p_errtable.count > 0 THEN
300: FOR i IN p_errtable.first..p_errtable.last LOOP
301: IF p_errtable.exists(i) THEN
302: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
303: JTM_message_log_pkg.Log_Msg
304: ( v_object_id => null
305: , v_object_name => p_errtable(i)
306: , v_message => 'Entering ' || p_errtable(i) ||' Check data if get populated'

Line 307: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL

303: JTM_message_log_pkg.Log_Msg
304: ( v_object_id => null
305: , v_object_name => p_errtable(i)
306: , v_message => 'Entering ' || p_errtable(i) ||' Check data if get populated'
307: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
308: , v_module => 'jtm_wrapper_pkg');
309: END IF;
310:
311: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG