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,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
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,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
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,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
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,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
16:
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,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
16:
17: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%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,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
16:
17: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
18:
11: p_application_id IN jtf_prefab_host_apps.application_id%TYPE,
12: p_cache_policy IN jtf_prefab_host_apps.cache_policy%TYPE,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
16:
17: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
18:
19: x_return_status OUT NOCOPY VARCHAR2,
13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
16:
17: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
18:
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2
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,
32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
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,
32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
34:
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,
32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
34:
35: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
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,
32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
34:
35: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
36:
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,
32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
34:
35: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
36:
37: x_return_status OUT NOCOPY VARCHAR2,
31: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,
32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%TYPE,
33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,
34:
35: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%TYPE,
36:
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2
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,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
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,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
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,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
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,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
53: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%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,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
53: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
54: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
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,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
53: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
54: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
55: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
48: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%TYPE,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
53: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
54: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
55: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
56: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,
49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%TYPE,
50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_policy%TYPE,
51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%TYPE,
52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%TYPE,
53: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%TYPE,
54: p_hostname OUT NOCOPY jtf_prefab_wsh_poes_b.hostname%TYPE,
55: p_appname OUT NOCOPY fnd_application_vl.application_name%TYPE,
56: p_app_short_name OUT NOCOPY fnd_application_vl.application_short_name%TYPE,
57:
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,
71:
72: x_return_status OUT NOCOPY VARCHAR2,
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,
71:
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2
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,
85:
86: x_return_status OUT NOCOPY VARCHAR2,
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,
85:
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2