[Home] [Help]
1511: );
1512: END loop;
1513:
1514: IF ((l_int_val_rec.parent_id IS NOT NULL) AND (l_int_val_rec.parent_id <> fnd_api.g_miss_num)) THEN
1515: insert into jtf_ih_interaction_inters
1516: (
1517: INTERACT_INTERACTION_ID,
1518: INTERACT_INTERACTION_IDRELATES,
1519: CREATED_BY,
2016: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Open_Interaction');
2017:
2018:
2019: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
2020: INSERT INTO jtf_ih_interaction_inters
2021: (
2022: INTERACT_INTERACTION_ID,
2023: INTERACT_INTERACTION_IDRELATES,
2024: CREATED_BY,
2037: Sysdate,
2038: p_user_id
2039: );
2040: END IF;
2041: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB_PS.Open_Interaction');
2042: --
2043: -- Set OUT value
2044: --
2045: x_interaction_id := l_interaction_id;
2365:
2366: IF ((p_interaction_rec.parent_id IS NOT NULL) AND (p_interaction_rec.parent_id <> fnd_api.g_miss_num)) THEN
2367: l_count := 0;
2368: SELECT count(*) into l_count
2369: FROM jtf_ih_interaction_inters
2370: WHERE interact_interaction_id = p_interaction_rec.interaction_id and
2371: interact_interaction_idrelates = p_interaction_rec.parent_id;
2372: IF (l_count <= 0) THEN
2373: INSERT INTO jtf_ih_interaction_inters
2369: FROM jtf_ih_interaction_inters
2370: WHERE interact_interaction_id = p_interaction_rec.interaction_id and
2371: interact_interaction_idrelates = p_interaction_rec.parent_id;
2372: IF (l_count <= 0) THEN
2373: INSERT INTO jtf_ih_interaction_inters
2374: (
2375: INTERACT_INTERACTION_ID,
2376: INTERACT_INTERACTION_IDRELATES,
2377: CREATED_BY,
2391: p_user_id
2392: );
2393: END IF;
2394: END IF;
2395: --DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB_PS.Update_Interaction');
2396:
2397: -- Standard check of p_commit
2398: IF fnd_api.to_boolean(p_commit) THEN
2399: COMMIT WORK;