APPS.JTF_PREFAB_LOAD_DIST_PUB dependencies on JTF_PREFAB_PRBS

Line 16: p_policy_id IN jtf_prefab_prbs.policy_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_policy_id IN jtf_prefab_prbs.policy_id%TYPE,
17: p_uri IN jtf_prefab_prbs.uri%TYPE,
18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,
19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,

Line 17: p_uri IN jtf_prefab_prbs.uri%TYPE,

13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id IN jtf_prefab_prbs.policy_id%TYPE,
17: p_uri IN jtf_prefab_prbs.uri%TYPE,
18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,
19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,
21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,

Line 18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,

14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15:
16: p_policy_id IN jtf_prefab_prbs.policy_id%TYPE,
17: p_uri IN jtf_prefab_prbs.uri%TYPE,
18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,
19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,
21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,
22:

Line 19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,

15:
16: p_policy_id IN jtf_prefab_prbs.policy_id%TYPE,
17: p_uri IN jtf_prefab_prbs.uri%TYPE,
18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,
19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,
21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,
22:
23: p_object_version_number OUT NOCOPY jtf_prefab_prbs.object_version_number%TYPE,

Line 20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,

16: p_policy_id IN jtf_prefab_prbs.policy_id%TYPE,
17: p_uri IN jtf_prefab_prbs.uri%TYPE,
18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,
19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,
21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,
22:
23: p_object_version_number OUT NOCOPY jtf_prefab_prbs.object_version_number%TYPE,
24:

Line 21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,

17: p_uri IN jtf_prefab_prbs.uri%TYPE,
18: p_user_id IN jtf_prefab_prbs.user_id%TYPE,
19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,
21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,
22:
23: p_object_version_number OUT NOCOPY jtf_prefab_prbs.object_version_number%TYPE,
24:
25: x_return_status OUT NOCOPY VARCHAR2,

Line 23: p_object_version_number OUT NOCOPY jtf_prefab_prbs.object_version_number%TYPE,

19: p_responsibility_id IN jtf_prefab_prbs.responsibility_id%TYPE,
20: p_application_id IN jtf_prefab_prbs.application_id%TYPE,
21: p_prefab_hostname IN jtf_prefab_prbs.prefab_hostname%TYPE,
22:
23: p_object_version_number OUT NOCOPY jtf_prefab_prbs.object_version_number%TYPE,
24:
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2

Line 60: INSERT INTO jtf_prefab_prbs(prb_id,

56: ----------------
57:
58: p_object_version_number := 1;
59:
60: INSERT INTO jtf_prefab_prbs(prb_id,
61: object_version_number,
62: created_by,
63: creation_date,
64: last_updated_by,

Line 74: VALUES (jtf_prefab_prbs_s.NEXTVAL,

70: user_id,
71: responsibility_id,
72: application_id,
73: prefab_hostname)
74: VALUES (jtf_prefab_prbs_s.NEXTVAL,
75: p_object_version_number,
76: G_USER_ID,
77: SYSDATE,
78: G_USER_ID,