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 JTF_PREFAB_HOST_APPS

Line 16: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,

12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,

Line 17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,

13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,

Line 18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,

14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,

Line 19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,

15:
16: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
23:

Line 20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,

16: p_host_app_id OUT NOCOPY jtf_prefab_host_apps.host_app_id%TYPE,
17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,

Line 21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,

17: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
25:

Line 22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,

18: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
19: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
25:
26: x_return_status OUT NOCOPY VARCHAR2,

Line 24: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,

20: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
21: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
22: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
23:
24: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
25:
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2

Line 35: SELECT jtf_prefab_host_apps_s.NEXTVAL from dual;

31: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_HOST_APP';
32: l_api_version NUMBER := p_api_version;
33:
34: CURSOR sequence_cursor IS
35: SELECT jtf_prefab_host_apps_s.NEXTVAL from dual;
36: CURSOR cache_comps_cursor IS
37: SELECT ca_comp_id
38: FROM jtf_prefab_ca_comps_vl
39: WHERE application_id = p_application_id and cache_generic_flag='f';

Line 82: INSERT INTO jtf_prefab_host_apps (host_app_id,

78: FETCH sequence_cursor INTO p_host_app_id;
79: CLOSE sequence_cursor;
80: p_object_version_number := 1;
81:
82: INSERT INTO jtf_prefab_host_apps (host_app_id,
83: object_version_number,
84: created_by,
85: creation_date,
86: last_updated_by,

Line 229: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,

225: p_api_version IN NUMBER,
226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228:
229: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
230: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,

Line 230: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,

226: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228:
229: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
230: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
234:

Line 231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,

227: p_commit IN VARCHAR2 := FND_API.G_FALSE,
228:
229: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
230: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
234:
235: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,

Line 232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,

228:
229: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
230: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
234:
235: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
236:

Line 233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,

229: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
230: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
234:
235: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
236:
237: x_return_status OUT NOCOPY VARCHAR2,

Line 235: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,

231: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
232: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
233: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
234:
235: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
236:
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2

Line 270: UPDATE jtf_prefab_host_apps

266:
267: -- real logic --
268: ----------------
269:
270: UPDATE jtf_prefab_host_apps
271: SET object_version_number = p_object_version_number,
272: last_updated_by = G_USER_ID,
273: last_update_date = SYSDATE,
274: last_update_login = G_LOGIN_ID,

Line 328: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,

324:
325: procedure SELECT_HOST_APP_FOR_HOST(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
329:
330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,

Line 330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,

326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
329:
330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,

Line 331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,

327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
329:
330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,

Line 332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,

328: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
329:
330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,

Line 333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,

329:
330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
337: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,

Line 334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,

330: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
337: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
338: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,

Line 335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,

331: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
337: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
338: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
339: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,

Line 336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,

332: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
333: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
334: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
335: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
336: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
337: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
338: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
339: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,
340:

Line 350: FROM jtf_prefab_host_apps

346: l_api_version CONSTANT NUMBER := p_api_version;
347:
348: CURSOR host_app_cursor IS
349: SELECT application_id
350: FROM jtf_prefab_host_apps
351: WHERE host_app_id = p_host_app_id;
352:
353: BEGIN
354:

Line 385: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host

381: if p_application_id = -1 then
382:
383: SELECT app.object_version_number, app.wsh_po_id, app.application_id, app.cache_policy, app.cache_clear_flag, app.cache_reload_flag, app.cache_filter_policy, host.hostname, 'HTML-Platform', ''
384: INTO p_object_version_number, p_wsh_po_id, p_application_id, p_cache_policy, p_cache_clear_flag, p_cache_reload_flag, p_cache_filter_policy, p_hostname, p_appname, p_app_short_name
385: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host
386: WHERE app.host_app_id = p_host_app_id
387: AND app.wsh_po_id = host.wsh_po_id;
388:
389: else

Line 393: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host, fnd_application_vl fndapp

389: else
390:
391: SELECT app.object_version_number, app.wsh_po_id, app.application_id, app.cache_policy, app.cache_clear_flag, app.cache_reload_flag, app.cache_filter_policy, host.hostname, fndapp.application_name, fndapp.application_short_name
392: INTO p_object_version_number, p_wsh_po_id, p_application_id, p_cache_policy, p_cache_clear_flag, p_cache_reload_flag, p_cache_filter_policy, p_hostname, p_appname, p_app_short_name
393: FROM jtf_prefab_host_apps app, jtf_prefab_wsh_poes_vl host, fnd_application_vl fndapp
394: WHERE app.host_app_id = p_host_app_id
395: AND app.wsh_po_id = host.wsh_po_id
396: AND app.application_id = fndapp.application_id;
397:

Line 411: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,

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_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
412:
413: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,
414:
415: x_return_status OUT NOCOPY VARCHAR2,

Line 413: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,

409: p_commit IN VARCHAR2 := FND_API.G_FALSE,
410:
411: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,
412:
413: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,
414:
415: x_return_status OUT NOCOPY VARCHAR2,
416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2

Line 447: DELETE FROM jtf_prefab_host_apps

443:
444: -- real logic --
445: ----------------
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,

Line 517: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,

513: p_api_version IN NUMBER,
514: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516:
517: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
518:
519: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,
520:
521: x_return_status OUT NOCOPY VARCHAR2,

Line 519: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,

515: p_commit IN VARCHAR2 := FND_API.G_FALSE,
516:
517: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,
518:
519: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,
520:
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_msg_count OUT NOCOPY NUMBER,
523: x_msg_data OUT NOCOPY VARCHAR2

Line 530: FROM jtf_prefab_host_apps

526: l_api_version CONSTANT NUMBER := p_api_version;
527:
528: CURSOR host_apps_cursor IS
529: SELECT host_app_id
530: FROM jtf_prefab_host_apps
531: WHERE wsh_po_id = p_wsh_po_id;
532: l_host_app_id NUMBER;
533: BEGIN
534: -- Standard Start of API savepoint

Line 654: FROM jtf_prefab_host_apps

650: CURSOR sequence_cursor IS
651: SELECT jtf_prefab_ca_comps_b_s.NEXTVAL from dual;
652: CURSOR host_apps_cursor IS
653: SELECT host_app_id
654: FROM jtf_prefab_host_apps
655: WHERE application_id = p_application_id;
656: CURSOR host_apps_cursor_gen IS
657: SELECT host_app_id
658: FROM jtf_prefab_host_apps

Line 658: FROM jtf_prefab_host_apps

654: FROM jtf_prefab_host_apps
655: WHERE application_id = p_application_id;
656: CURSOR host_apps_cursor_gen IS
657: SELECT host_app_id
658: FROM jtf_prefab_host_apps
659: WHERE application_id = -1;
660: l_host_app_id NUMBER;
661: l_ha_comp_id NUMBER;
662: BEGIN

Line 2059: FROM jtf_prefab_host_apps

2055: CURSOR sequence_cursor IS
2056: SELECT jtf_prefab_ca_filters_b_s.NEXTVAL from dual;
2057: CURSOR host_apps_cursor IS
2058: SELECT host_app_id
2059: FROM jtf_prefab_host_apps
2060: WHERE application_id = p_application_id;
2061: l_host_app_id NUMBER;
2062: l_ha_filter_id NUMBER;
2063: BEGIN