eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PREFAB_CACHE_PUB dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2: /* $Header: jtfprefabcas.pls 120.4 2006/09/15 13:04:34 amaddula ship $ */
3:
4: PROCEDURE INSERT_HOST_APP(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,

Line 7: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3:
4: PROCEDURE INSERT_HOST_APP(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8:
9: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
10: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
11: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,

Line 26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

22: );
23:
24: PROCEDURE UPDATE_HOST_APP(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28:
29: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
30: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,

Line 27: p_commit IN VARCHAR2 := FND_API.G_FALSE,

23:
24: PROCEDURE UPDATE_HOST_APP(
25: p_api_version IN NUMBER,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28:
29: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
30: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
31: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,

Line 44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

40: );
41:
42: procedure SELECT_HOST_APP_FOR_HOST(
43: p_api_version IN NUMBER,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
46:
47: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
48: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,

Line 65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

61: );
62:
63: procedure DELETE_HOST_APP(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67:
68: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
69:

Line 66: p_commit IN VARCHAR2 := FND_API.G_FALSE,

62:
63: procedure DELETE_HOST_APP(
64: p_api_version IN NUMBER,
65: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66: p_commit IN VARCHAR2 := FND_API.G_FALSE,
67:
68: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
69:
70: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,

Line 79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

75: );
76:
77: procedure DELETE_HOST_APPS_FOR_HOST(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81:
82: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
83:

Line 80: p_commit IN VARCHAR2 := FND_API.G_FALSE,

76:
77: procedure DELETE_HOST_APPS_FOR_HOST(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE,
81:
82: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
83:
84: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,

Line 93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

89: );
90:
91: PROCEDURE INSERT_CACHE_COMP(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95:
96: p_ca_comp_id OUT NOCOPY jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
97: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,

Line 94: p_commit IN VARCHAR2 := FND_API.G_FALSE,

90:
91: PROCEDURE INSERT_CACHE_COMP(
92: p_api_version IN NUMBER,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE,
95:
96: p_ca_comp_id OUT NOCOPY jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
97: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
98: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,

Line 120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

116: );
117:
118: PROCEDURE UPDATE_CACHE_COMP(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122:
123: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
124: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,

Line 121: p_commit IN VARCHAR2 := FND_API.G_FALSE,

117:
118: PROCEDURE UPDATE_CACHE_COMP(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
121: p_commit IN VARCHAR2 := FND_API.G_FALSE,
122:
123: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
124: p_application_id IN jtf_prefab_ca_comps_b.application_id%TYPE,
125: p_comp_name IN jtf_prefab_ca_comps_b.comp_name%TYPE,

Line 147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

143: );
144:
145: PROCEDURE UPDATE_CACHE_COMP_1(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149:
150: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
151:

Line 148: p_commit IN VARCHAR2 := FND_API.G_FALSE,

144:
145: PROCEDURE UPDATE_CACHE_COMP_1(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
148: p_commit IN VARCHAR2 := FND_API.G_FALSE,
149:
150: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
151:
152: -- p_object_version_number IN OUT jtf_prefab_ca_comps_b.object_version_number%TYPE,

Line 161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

157: );
158:
159: procedure DELETE_CACHE_COMP(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
165:

Line 162: p_commit IN VARCHAR2 := FND_API.G_FALSE,

158:
159: procedure DELETE_CACHE_COMP(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163:
164: p_ca_comp_id IN jtf_prefab_ca_comps_b.ca_comp_id%TYPE,
165:
166: p_object_version_number IN jtf_prefab_ca_comps_b.object_version_number%TYPE,

Line 175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

171: );
172:
173: PROCEDURE INSERT_HA_COMP(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177:
178: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
179: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,

Line 176: p_commit IN VARCHAR2 := FND_API.G_FALSE,

172:
173: PROCEDURE INSERT_HA_COMP(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177:
178: p_ha_comp_id OUT NOCOPY jtf_prefab_ha_comps.ha_comp_id%TYPE,
179: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
180: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,

Line 194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

190: );
191:
192: PROCEDURE UPDATE_HA_COMP(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196:
197: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,
198: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,

Line 195: p_commit IN VARCHAR2 := FND_API.G_FALSE,

191:
192: PROCEDURE UPDATE_HA_COMP(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
195: p_commit IN VARCHAR2 := FND_API.G_FALSE,
196:
197: p_ha_comp_id IN jtf_prefab_ha_comps.ha_comp_id%TYPE,
198: p_cache_policy IN jtf_prefab_ha_comps.cache_policy%TYPE,
199: p_cache_clear_flag IN jtf_prefab_ha_comps.cache_clear_flag%TYPE,

Line 211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

207: );
208:
209: procedure DELETE_HA_COMPS_FOR_HOST_APP(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213:
214: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
215:

Line 212: p_commit IN VARCHAR2 := FND_API.G_FALSE,

208:
209: procedure DELETE_HA_COMPS_FOR_HOST_APP(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212: p_commit IN VARCHAR2 := FND_API.G_FALSE,
213:
214: p_host_app_id IN jtf_prefab_ha_comps.host_app_id%TYPE,
215:
216: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,

Line 225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

221: );
222:
223: procedure DELETE_HA_COMPS_FOR_CACHE_COMP(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227:
228: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
229:

Line 226: p_commit IN VARCHAR2 := FND_API.G_FALSE,

222:
223: procedure DELETE_HA_COMPS_FOR_CACHE_COMP(
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227:
228: p_ca_comp_id IN jtf_prefab_ha_comps.ca_comp_id%TYPE,
229:
230: p_object_version_number IN jtf_prefab_ha_comps.object_version_number%TYPE,

Line 239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

235: );
236:
237: PROCEDURE INSERT_CACHE_STAT(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241:
242: p_cache_stat_id OUT NOCOPY jtf_prefab_cache_stats.cache_stat_id%TYPE,
243: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,

Line 240: p_commit IN VARCHAR2 := FND_API.G_FALSE,

236:
237: PROCEDURE INSERT_CACHE_STAT(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241:
242: p_cache_stat_id OUT NOCOPY jtf_prefab_cache_stats.cache_stat_id%TYPE,
243: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,
244: p_wsh_po_id IN jtf_prefab_cache_stats.wsh_po_id%TYPE,

Line 266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

262: );
263:
264: PROCEDURE UPDATE_CACHE_STAT(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268:
269: p_cache_stat_id IN jtf_prefab_cache_stats.cache_stat_id%TYPE,
270: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,

Line 267: p_commit IN VARCHAR2 := FND_API.G_FALSE,

263:
264: PROCEDURE UPDATE_CACHE_STAT(
265: p_api_version IN NUMBER,
266: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
267: p_commit IN VARCHAR2 := FND_API.G_FALSE,
268:
269: p_cache_stat_id IN jtf_prefab_cache_stats.cache_stat_id%TYPE,
270: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,
271: p_wsh_po_id IN jtf_prefab_cache_stats.wsh_po_id%TYPE,

Line 293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

289: );
290:
291: procedure DELETE_CACHE_STAT(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_commit IN VARCHAR2 := FND_API.G_FALSE,
295:
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,

Line 294: p_commit IN VARCHAR2 := FND_API.G_FALSE,

290:
291: procedure DELETE_CACHE_STAT(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_commit IN VARCHAR2 := FND_API.G_FALSE,
295:
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2

Line 303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

299: );
300:
301: procedure RESET_CACHE_STAT(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_wsh_po_id IN NUMBER,
306: p_ca_comp_id IN NUMBER,
307: x_return_status OUT NOCOPY VARCHAR2,

Line 304: p_commit IN VARCHAR2 := FND_API.G_FALSE,

300:
301: procedure RESET_CACHE_STAT(
302: p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_wsh_po_id IN NUMBER,
306: p_ca_comp_id IN NUMBER,
307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,

Line 314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

310: );
311:
312: PROCEDURE INSERT_CA_FILTER(
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316:
317: p_ca_filter_id OUT NOCOPY jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
318: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,

Line 315: p_commit IN VARCHAR2 := FND_API.G_FALSE,

311:
312: PROCEDURE INSERT_CA_FILTER(
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_commit IN VARCHAR2 := FND_API.G_FALSE,
316:
317: p_ca_filter_id OUT NOCOPY jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
318: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
319: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,

Line 331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

327: );
328:
329: PROCEDURE UPDATE_CA_FILTER(
330: p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333:
334: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
335: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,

Line 332: p_commit IN VARCHAR2 := FND_API.G_FALSE,

328:
329: PROCEDURE UPDATE_CA_FILTER(
330: p_api_version IN NUMBER,
331: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
332: p_commit IN VARCHAR2 := FND_API.G_FALSE,
333:
334: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
335: p_application_id IN jtf_prefab_ca_filters_b.application_id%TYPE,
336: p_ca_filter_name IN jtf_prefab_ca_filters_b.ca_filter_name%TYPE,

Line 348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

344: );
345:
346: procedure DELETE_CA_FILTER(
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350:
351: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
352:

Line 349: p_commit IN VARCHAR2 := FND_API.G_FALSE,

345:
346: procedure DELETE_CA_FILTER(
347: p_api_version IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350:
351: p_ca_filter_id IN jtf_prefab_ca_filters_b.ca_filter_id%TYPE,
352:
353: p_object_version_number IN jtf_prefab_ca_filters_b.object_version_number%TYPE,

Line 362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

358: );
359:
360: PROCEDURE INSERT_HA_FILTER(
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363: p_commit IN VARCHAR2 := FND_API.G_FALSE,
364:
365: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,
366: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,

Line 363: p_commit IN VARCHAR2 := FND_API.G_FALSE,

359:
360: PROCEDURE INSERT_HA_FILTER(
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363: p_commit IN VARCHAR2 := FND_API.G_FALSE,
364:
365: p_ha_filter_id OUT NOCOPY jtf_prefab_ha_filters.ha_filter_id%TYPE,
366: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
367: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,

Line 379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

375: );
376:
377: PROCEDURE UPDATE_HA_FILTER(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381:
382: p_ha_filter_id IN jtf_prefab_ha_filters.ha_filter_id%TYPE,
383: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,

Line 380: p_commit IN VARCHAR2 := FND_API.G_FALSE,

376:
377: PROCEDURE UPDATE_HA_FILTER(
378: p_api_version IN NUMBER,
379: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
381:
382: p_ha_filter_id IN jtf_prefab_ha_filters.ha_filter_id%TYPE,
383: p_cache_filter_enabled_flag IN jtf_prefab_ha_filters.cache_filter_enabled_flag%TYPE,
384:

Line 394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

390: );
391:
392: procedure DELETE_HA_FILTERS_F_HOST_APP(
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396:
397: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
398:

Line 395: p_commit IN VARCHAR2 := FND_API.G_FALSE,

391:
392: procedure DELETE_HA_FILTERS_F_HOST_APP(
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_commit IN VARCHAR2 := FND_API.G_FALSE,
396:
397: p_host_app_id IN jtf_prefab_ha_filters.host_app_id%TYPE,
398:
399: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,

Line 408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

404: );
405:
406: procedure DELETE_HA_FILTERS_F_CA_FILTER(
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410:
411: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
412:

Line 409: p_commit IN VARCHAR2 := FND_API.G_FALSE,

405:
406: procedure DELETE_HA_FILTERS_F_CA_FILTER(
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410:
411: p_ca_filter_id IN jtf_prefab_ha_filters.ca_filter_id%TYPE,
412:
413: p_object_version_number IN jtf_prefab_ha_filters.object_version_number%TYPE,

Line 422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

418: );
419:
420: PROCEDURE INSERT_CA_FL_RESP(
421: p_api_version IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
424:
425: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
426: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,

Line 423: p_commit IN VARCHAR2 := FND_API.G_FALSE,

419:
420: PROCEDURE INSERT_CA_FL_RESP(
421: p_api_version IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_commit IN VARCHAR2 := FND_API.G_FALSE,
424:
425: p_ca_fl_resp_id OUT NOCOPY jtf_prefab_ca_fl_resps.ca_fl_resp_id%TYPE,
426: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
427: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,

Line 438: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

434: );
435:
436: procedure DELETE_CA_FL_RESP(
437: p_api_version IN NUMBER,
438: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
439: p_commit IN VARCHAR2 := FND_API.G_FALSE,
440:
441: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
442:

Line 439: p_commit IN VARCHAR2 := FND_API.G_FALSE,

435:
436: procedure DELETE_CA_FL_RESP(
437: p_api_version IN NUMBER,
438: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
439: p_commit IN VARCHAR2 := FND_API.G_FALSE,
440:
441: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
442:
443: p_object_version_number IN jtf_prefab_ca_fl_resps.object_version_number%TYPE,

Line 452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

448: );
449:
450: procedure DELETE_CA_FL_RESP(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_commit IN VARCHAR2 := FND_API.G_FALSE,
454:
455: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
456: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,

Line 453: p_commit IN VARCHAR2 := FND_API.G_FALSE,

449:
450: procedure DELETE_CA_FL_RESP(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
453: p_commit IN VARCHAR2 := FND_API.G_FALSE,
454:
455: p_ca_filter_id IN jtf_prefab_ca_fl_resps.ca_filter_id%TYPE,
456: p_responsibility_id IN jtf_prefab_ca_fl_resps.responsibility_id%TYPE,
457:

Line 467: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

463: );
464:
465: PROCEDURE INSERT_CA_FL_LANG(
466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
468: p_commit IN VARCHAR2 := FND_API.G_FALSE,
469:
470: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
471: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,

Line 468: p_commit IN VARCHAR2 := FND_API.G_FALSE,

464:
465: PROCEDURE INSERT_CA_FL_LANG(
466: p_api_version IN NUMBER,
467: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
468: p_commit IN VARCHAR2 := FND_API.G_FALSE,
469:
470: p_ca_fl_lang_id OUT NOCOPY jtf_prefab_ca_fl_langs.ca_fl_lang_id%TYPE,
471: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
472: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,

Line 483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

479: );
480:
481: procedure DELETE_CA_FL_LANG(
482: p_api_version IN NUMBER,
483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
484: p_commit IN VARCHAR2 := FND_API.G_FALSE,
485:
486: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
487:

Line 484: p_commit IN VARCHAR2 := FND_API.G_FALSE,

480:
481: procedure DELETE_CA_FL_LANG(
482: p_api_version IN NUMBER,
483: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
484: p_commit IN VARCHAR2 := FND_API.G_FALSE,
485:
486: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
487:
488: p_object_version_number IN jtf_prefab_ca_fl_langs.object_version_number%TYPE,

Line 497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

493: );
494:
495: procedure DELETE_CA_FL_LANG(
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
499:
500: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
501: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,

Line 498: p_commit IN VARCHAR2 := FND_API.G_FALSE,

494:
495: procedure DELETE_CA_FL_LANG(
496: p_api_version IN NUMBER,
497: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
498: p_commit IN VARCHAR2 := FND_API.G_FALSE,
499:
500: p_ca_filter_id IN jtf_prefab_ca_fl_langs.ca_filter_id%TYPE,
501: p_language_code IN jtf_prefab_ca_fl_langs.language_code%TYPE,
502: