DBA Data[Home] [Help]

APPS.JTF_IH_PVT dependencies on JTF_IH_PUB

Line 12: p_interaction_rec IN jtf_ih_pub.interaction_rec_type,

8: p_login_id IN NUMBER DEFAULT NULL,
9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
12: p_interaction_rec IN jtf_ih_pub.interaction_rec_type,
13: p_activities IN jtf_ih_pub.activity_tbl_type,
14: p_media IN jtf_ih_pub.media_rec_type,
15: p_mlcs IN jtf_ih_pub.mlcs_tbl_type
16: )IS

Line 13: p_activities IN jtf_ih_pub.activity_tbl_type,

9: x_return_status OUT VARCHAR2,
10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
12: p_interaction_rec IN jtf_ih_pub.interaction_rec_type,
13: p_activities IN jtf_ih_pub.activity_tbl_type,
14: p_media IN jtf_ih_pub.media_rec_type,
15: p_mlcs IN jtf_ih_pub.mlcs_tbl_type
16: )IS
17: l_return_status VARCHAR2(1);

Line 14: p_media IN jtf_ih_pub.media_rec_type,

10: x_msg_count OUT NUMBER,
11: x_msg_data OUT VARCHAR2,
12: p_interaction_rec IN jtf_ih_pub.interaction_rec_type,
13: p_activities IN jtf_ih_pub.activity_tbl_type,
14: p_media IN jtf_ih_pub.media_rec_type,
15: p_mlcs IN jtf_ih_pub.mlcs_tbl_type
16: )IS
17: l_return_status VARCHAR2(1);
18: l_msg_count NUMBER;

Line 15: p_mlcs IN jtf_ih_pub.mlcs_tbl_type

11: x_msg_data OUT VARCHAR2,
12: p_interaction_rec IN jtf_ih_pub.interaction_rec_type,
13: p_activities IN jtf_ih_pub.activity_tbl_type,
14: p_media IN jtf_ih_pub.media_rec_type,
15: p_mlcs IN jtf_ih_pub.mlcs_tbl_type
16: )IS
17: l_return_status VARCHAR2(1);
18: l_msg_count NUMBER;
19: l_msg_data VARCHAR2(1000);

Line 20: l_interaction_rec jtf_ih_pub.interaction_rec_type := p_interaction_rec;

16: )IS
17: l_return_status VARCHAR2(1);
18: l_msg_count NUMBER;
19: l_msg_data VARCHAR2(1000);
20: l_interaction_rec jtf_ih_pub.interaction_rec_type := p_interaction_rec;
21: l_activities jtf_ih_pub.activity_tbl_type := p_activities;
22: l_media jtf_ih_pub.media_rec_type := p_media;
23:
24: BEGIN

Line 21: l_activities jtf_ih_pub.activity_tbl_type := p_activities;

17: l_return_status VARCHAR2(1);
18: l_msg_count NUMBER;
19: l_msg_data VARCHAR2(1000);
20: l_interaction_rec jtf_ih_pub.interaction_rec_type := p_interaction_rec;
21: l_activities jtf_ih_pub.activity_tbl_type := p_activities;
22: l_media jtf_ih_pub.media_rec_type := p_media;
23:
24: BEGIN
25:

Line 22: l_media jtf_ih_pub.media_rec_type := p_media;

18: l_msg_count NUMBER;
19: l_msg_data VARCHAR2(1000);
20: l_interaction_rec jtf_ih_pub.interaction_rec_type := p_interaction_rec;
21: l_activities jtf_ih_pub.activity_tbl_type := p_activities;
22: l_media jtf_ih_pub.media_rec_type := p_media;
23:
24: BEGIN
25:
26: -- Standard start of API savepoint

Line 37: JTF_IH_PUB.Create_MediaItem(1.0,'T','T',p_resp_appl_id,p_resp_id,p_user_id,p_login_id,

33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: SELECT jtf.jtf_ih_media_items_s1.NEXTVAL INTO l_media.media_id FROM dual;
36:
37: JTF_IH_PUB.Create_MediaItem(1.0,'T','T',p_resp_appl_id,p_resp_id,p_user_id,p_login_id,
38: l_return_status,
39: l_msg_count,
40: l_msg_data,
41: l_media,

Line 51: JTF_IH_PUB.Create_Interaction(1.0,'T','T',p_resp_appl_id,p_resp_id,p_user_id,p_login_id,

47:
48: for idx in 1 .. l_activities.count loop
49: l_activities(idx).media_id := l_media.media_id;
50: end loop;
51: JTF_IH_PUB.Create_Interaction(1.0,'T','T',p_resp_appl_id,p_resp_id,p_user_id,p_login_id,
52: l_return_status,
53: l_msg_count,
54: l_msg_data,
55: l_interaction_rec,