APPS.CSL_JTF_RESOURCE_EXTNS_ACC_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 6: := 'JTM_JTF_RS_RESOURCE_EXTNS_ACC';

2: /* $Header: cslreacb.pls 115.5 2003/01/06 07:01:04 vekrishn ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30)
6: := 'JTM_JTF_RS_RESOURCE_EXTNS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list
8: := JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS');
9: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_EXTNS';
10: g_pk_name CONSTANT VARCHAR2(30) := 'RESOURCE_PK';

Line 8: := JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS');

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30)
6: := 'JTM_JTF_RS_RESOURCE_EXTNS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list
8: := JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS');
9: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_EXTNS';
10: g_pk_name CONSTANT VARCHAR2(30) := 'RESOURCE_PK';
11: --Workaround for resource_id
12: g_debug_level NUMBER; -- debug level

Line 9: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_EXTNS';

5: g_acc_table_name CONSTANT VARCHAR2(30)
6: := 'JTM_JTF_RS_RESOURCE_EXTNS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list
8: := JTM_HOOK_UTIL_PKG.t_publication_item_list('JTF_RS_RESOURCE_EXTNS');
9: g_table_name CONSTANT VARCHAR2(30) := 'JTF_RS_RESOURCE_EXTNS';
10: g_pk_name CONSTANT VARCHAR2(30) := 'RESOURCE_PK';
11: --Workaround for resource_id
12: g_debug_level NUMBER; -- debug level
13:

Line 25: FROM JTF_RS_RESOURCE_EXTNS

21: RETURN BOOLEAN
22: IS
23: CURSOR c_user (b_resource_extn_id NUMBER) IS
24: SELECT resource_id -- Fix for Sql Performance
25: FROM JTF_RS_RESOURCE_EXTNS
26: WHERE resource_id = b_resource_extn_id;
27: r_user c_user%ROWTYPE;
28:
29: BEGIN