DBA Data[Home] [Help]

APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_HOST_APPS

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

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,

Line 10: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%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,

Line 11: p_application_id IN jtf_prefab_host_apps.application_id%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,

Line 12: p_cache_policy IN jtf_prefab_host_apps.cache_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:

Line 13: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,

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,

Line 14: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%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:

Line 15: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%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:
19: x_return_status OUT NOCOPY VARCHAR2,

Line 17: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%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,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2

Line 29: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,

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,

Line 30: p_cache_policy IN jtf_prefab_host_apps.cache_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:

Line 31: p_cache_clear_flag IN jtf_prefab_host_apps.cache_clear_flag%TYPE,

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,

Line 32: p_cache_reload_flag IN jtf_prefab_host_apps.cache_reload_flag%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:

Line 33: p_cache_filter_policy IN jtf_prefab_host_apps.cache_filter_policy%TYPE,

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,

Line 35: p_object_version_number IN OUT NOCOPY jtf_prefab_host_apps.object_version_number%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,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2

Line 45: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,

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,

Line 47: p_object_version_number OUT NOCOPY jtf_prefab_host_apps.object_version_number%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,

Line 48: p_wsh_po_id OUT NOCOPY jtf_prefab_host_apps.wsh_po_id%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,

Line 49: p_application_id OUT NOCOPY jtf_prefab_host_apps.application_id%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,

Line 50: p_cache_policy OUT NOCOPY jtf_prefab_host_apps.cache_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,

Line 51: p_cache_clear_flag OUT NOCOPY jtf_prefab_host_apps.cache_clear_flag%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,

Line 52: p_cache_reload_flag OUT NOCOPY jtf_prefab_host_apps.cache_reload_flag%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,

Line 53: p_cache_filter_policy OUT NOCOPY jtf_prefab_host_apps.cache_filter_policy%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:

Line 68: p_host_app_id IN jtf_prefab_host_apps.host_app_id%TYPE,

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,

Line 70: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,

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

Line 82: p_wsh_po_id IN jtf_prefab_host_apps.wsh_po_id%TYPE,

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,

Line 84: p_object_version_number IN jtf_prefab_host_apps.object_version_number%TYPE,

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