APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_CACHE_PUB

Line 1: Package Body JTF_PREFAB_CACHE_PUB AS

1: Package Body JTF_PREFAB_CACHE_PUB AS
2: /* $Header: jtfprefabcab.pls 120.3 2006/09/15 12:23:31 amaddula ship $ */
3:
4: -- global variables --
5: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PREFAB_CACHE_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PREFAB_CACHE_PUB';

1: Package Body JTF_PREFAB_CACHE_PUB AS
2: /* $Header: jtfprefabcab.pls 120.3 2006/09/15 12:23:31 amaddula ship $ */
3:
4: -- global variables --
5: G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_PREFAB_CACHE_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(16):='jtfprefabcab.pls';
7:
8: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 119: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,

115: OPEN cache_comps_cursor_gen;
116: FETCH cache_comps_cursor_gen INTO l_ca_comp_id;
117:
118: WHILE cache_comps_cursor_gen%FOUND LOOP
119: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,
120: p_init_msg_list,
121: p_commit,
122: l_ha_comp_id,
123: p_host_app_id,

Line 139: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,

135: ELSE
136: OPEN cache_comps_cursor;
137: FETCH cache_comps_cursor INTO l_ca_comp_id;
138: WHILE cache_comps_cursor%FOUND LOOP
139: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,
140: p_init_msg_list,
141: p_commit,
142: l_ha_comp_id,
143: p_host_app_id,

Line 164: JTF_PREFAB_CACHE_PUB.INSERT_HA_FILTER(p_api_version,

160: OPEN cache_filters_cursor;
161: FETCH cache_filters_cursor INTO l_ca_filter_id;
162:
163: WHILE cache_filters_cursor%FOUND LOOP
164: JTF_PREFAB_CACHE_PUB.INSERT_HA_FILTER(p_api_version,
165: p_init_msg_list,
166: p_commit,
167: l_ha_filter_id,
168: p_host_app_id,

Line 450: JTF_PREFAB_CACHE_PUB.DELETE_HA_COMPS_FOR_HOST_APP(p_api_version,

446:
447: DELETE FROM jtf_prefab_host_apps
448: WHERE host_app_id = p_host_app_id;
449:
450: JTF_PREFAB_CACHE_PUB.DELETE_HA_COMPS_FOR_HOST_APP(p_api_version,
451: p_init_msg_list,
452: p_commit,
453: p_host_app_id,
454: p_object_version_number,

Line 459: JTF_PREFAB_CACHE_PUB.DELETE_HA_FILTERS_F_HOST_APP(p_api_version,

455: x_return_status,
456: x_msg_count,
457: x_msg_data);
458:
459: JTF_PREFAB_CACHE_PUB.DELETE_HA_FILTERS_F_HOST_APP(p_api_version,
460: p_init_msg_list,
461: p_commit,
462: p_host_app_id,
463: p_object_version_number,

Line 562: JTF_PREFAB_CACHE_PUB.DELETE_HOST_APP(p_api_version,

558: OPEN host_apps_cursor;
559:
560: FETCH host_apps_cursor INTO l_host_app_id;
561: WHILE host_apps_cursor%FOUND LOOP
562: JTF_PREFAB_CACHE_PUB.DELETE_HOST_APP(p_api_version,
563: p_init_msg_list,
564: p_commit,
565: l_host_app_id,
566: p_object_version_number,

Line 766: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,

762: OPEN host_apps_cursor;
763: FETCH host_apps_cursor INTO l_host_app_id;
764:
765: WHILE host_apps_cursor%FOUND LOOP
766: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,
767: p_init_msg_list,
768: p_commit,
769: l_ha_comp_id,
770: l_host_app_id,

Line 790: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,

786: OPEN host_apps_cursor_gen;
787: FETCH host_apps_cursor_gen INTO l_host_app_id;
788:
789: WHILE host_apps_cursor_gen%FOUND LOOP
790: JTF_PREFAB_CACHE_PUB.INSERT_HA_COMP(p_api_version,
791: p_init_msg_list,
792: p_commit,
793: l_ha_comp_id,
794: l_host_app_id,

Line 1129: JTF_PREFAB_CACHE_PUB.DELETE_HA_COMPS_FOR_CACHE_COMP(p_api_version,

1125: DELETE FROM jtf_prefab_cache_comps
1126: WHERE ca_comp_id = p_ca_comp_id;
1127: */
1128:
1129: JTF_PREFAB_CACHE_PUB.DELETE_HA_COMPS_FOR_CACHE_COMP(p_api_version,
1130: p_init_msg_list,
1131: p_commit,
1132: p_ca_comp_id,
1133: p_object_version_number,

Line 2112: JTF_PREFAB_CACHE_PUB.INSERT_HA_FILTER(p_api_version,

2108: OPEN host_apps_cursor;
2109: FETCH host_apps_cursor INTO l_host_app_id;
2110:
2111: WHILE host_apps_cursor%FOUND LOOP
2112: JTF_PREFAB_CACHE_PUB.INSERT_HA_FILTER(p_api_version,
2113: p_init_msg_list,
2114: p_commit,
2115: l_ha_filter_id,
2116: l_host_app_id,

Line 2314: JTF_PREFAB_CACHE_PUB.DELETE_HA_FILTERS_F_CA_FILTER(p_api_version,

2310: ----------------
2311:
2312: JTF_PREFAB_CA_FILTERS_PKG.DELETE_ROW(p_ca_filter_id);
2313:
2314: JTF_PREFAB_CACHE_PUB.DELETE_HA_FILTERS_F_CA_FILTER(p_api_version,
2315: p_init_msg_list,
2316: p_commit,
2317: p_ca_filter_id,
2318: p_object_version_number,

Line 2322: JTF_PREFAB_CACHE_PUB.DELETE_CA_FL_RESP(p_api_version,

2318: p_object_version_number,
2319: x_return_status,
2320: x_msg_count,
2321: x_msg_data);
2322: JTF_PREFAB_CACHE_PUB.DELETE_CA_FL_RESP(p_api_version,
2323: p_init_msg_list,
2324: p_commit,
2325: p_ca_filter_id,
2326: p_object_version_number,

Line 2330: JTF_PREFAB_CACHE_PUB.DELETE_CA_FL_LANG(p_api_version,

2326: p_object_version_number,
2327: x_return_status,
2328: x_msg_count,
2329: x_msg_data);
2330: JTF_PREFAB_CACHE_PUB.DELETE_CA_FL_LANG(p_api_version,
2331: p_init_msg_list,
2332: p_commit,
2333: p_ca_filter_id,
2334: p_object_version_number,

Line 3363: END JTF_PREFAB_CACHE_PUB;

3359: p_data => x_msg_data );
3360:
3361: END DELETE_CA_FL_LANG;
3362:
3363: END JTF_PREFAB_CACHE_PUB;