APPS.JTF_IH_PUB dependencies on JTF_IH_INTERACTION_INTERS

Line 3249: insert into jtf_ih_interaction_inters

3245: END loop;
3246:
3247: -- DBMS_OUTPUT.PUT_LINE('PAST insert into activities');
3248: IF ((l_int_val_rec.parent_id IS NOT NULL) AND (l_int_val_rec.parent_id <> fnd_api.g_miss_num)) THEN
3249: insert into jtf_ih_interaction_inters
3250: (
3251: INTERACT_INTERACTION_ID,
3252: INTERACT_INTERACTION_IDRELATES,
3253: CREATED_BY,

Line 4274: INSERT INTO jtf_ih_interaction_inters

4270: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB.Open_Interaction');
4271:
4272:
4273: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
4274: INSERT INTO jtf_ih_interaction_inters
4275: (
4276: INTERACT_INTERACTION_ID,
4277: INTERACT_INTERACTION_IDRELATES,
4278: CREATED_BY,

Line 4297: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB.Open_Interaction');

4293: p_user_id
4294: );
4295: END IF;
4296: --l_test_msg := '8';
4297: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB.Open_Interaction');
4298: --
4299: -- Set OUT value
4300: --
4301: --x_interaction_id := l_interaction_id;

Line 4859: FROM jtf_ih_interaction_inters

4855: --
4856: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
4857: l_count := 0;
4858: SELECT count(*) into l_count
4859: FROM jtf_ih_interaction_inters
4860: WHERE interact_interaction_id = p_interaction_rec.interaction_id;
4861:
4862: -- Bug# 2418345
4863: -- WHERE interact_interaction_id = p_interaction_rec.interaction_id and

Line 4867: INSERT INTO jtf_ih_interaction_inters

4863: -- WHERE interact_interaction_id = p_interaction_rec.interaction_id and
4864: -- interact_interaction_idrelates = p_interaction_rec.parent_id;
4865:
4866: IF (l_count = 0) THEN
4867: INSERT INTO jtf_ih_interaction_inters
4868: (
4869: INTERACT_INTERACTION_IDRELATES,
4870: INTERACT_INTERACTION_ID,
4871: CREATED_BY,

Line 4890: UPDATE jtf_ih_interaction_inters SET

4886: );
4887: l_int_rec.parent_id := p_interaction_rec.parent_id;
4888: -- Bug# 2418345
4889: ELSE
4890: UPDATE jtf_ih_interaction_inters SET
4891: INTERACT_INTERACTION_IDRELATES = p_interaction_rec.parent_id,
4892: LAST_UPDATED_BY = p_user_id ,
4893: LAST_UPDATE_DATE = SYSDATE,
4894: LAST_UPDATE_LOGIN = p_user_id

Line 5216: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB.Update_Interaction');

5212: END IF;
5213: END IF;
5214: -- DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_interactions in JTF_IH_PUB.Update_Interaction');
5215:
5216: -- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB.Update_Interaction');
5217:
5218: -- Post processing Call
5219:
5220: IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'V') THEN