[Home] [Help]
124:
125: CURSOR c_task_src (b_task_id NUMBER) IS
126: SELECT tb.source_object_type_code
127: FROM jtf_object_usages ou,
128: jtf_tasks_b tb
129: WHERE
130: tb.task_id = b_task_id and
131: ou.object_user_code = 'NOTES' and
132: ou.object_code = tb.source_object_type_code;
488:
489: -- 09/24/03 commented this code because getting the object_version_number from p_action_input_data. (fix bug 3127477)
490: /*
491: SELECT object_version_number INTO l_object_version_number
492: FROM jtf_tasks_b WHERE task_id = l_task_rec_tbl(i).id;
493: */
494:
495: -- call the update_task api to update the task object
496: --INSERT INTO msista_Tmp values (50, 'calling update_task, with params :- ');
727: -- we have to do some additional work if 'auto-relate note' is true
728: IF (FND_PROFILE.VALUE('IEU_AUTO_RELATED') = 'Y') THEN -- this is for source document
729: l_continue := 0;
730: select count(source_object_id) into l_continue
731: from jtf_tasks_b
732: where task_id = l_task_rec_tbl(i).id;
733:
734: if (l_continue > 0) then
735: select source_object_id into l_note_context_type_id
732: where task_id = l_task_rec_tbl(i).id;
733:
734: if (l_continue > 0) then
735: select source_object_id into l_note_context_type_id
736: from jtf_tasks_b
737: where task_id = l_task_rec_tbl(i).id;
738: else l_note_context_type_id := null;
739: end if;
740:
774:
775: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CUSTOMER') = 'Y') THEN
776: l_continue := 0;
777: select count(customer_id) into l_continue
778: from jtf_tasks_b
779: where task_id = l_task_rec_tbl(i).id;
780:
781: if (l_continue > 0) then
782: select customer_id into l_note_context_type_id
779: where task_id = l_task_rec_tbl(i).id;
780:
781: if (l_continue > 0) then
782: select customer_id into l_note_context_type_id
783: from jtf_tasks_b
784: where task_id = l_task_rec_tbl(i).id;
785: else l_note_context_type_id := null;
786: end if;
787:
874: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
875: --commit;
876: l_continue := 0;
877: select count(customer_id) into l_continue
878: from jtf_tasks_b
879: where task_id = l_task_rec_tbl(i).id;
880:
881: if (l_continue > 0) then
882: select customer_id into l_note_context_type_id
879: where task_id = l_task_rec_tbl(i).id;
880:
881: if (l_continue > 0) then
882: select customer_id into l_note_context_type_id
883: from jtf_tasks_b
884: where task_id = l_task_rec_tbl(i).id;
885: else l_note_context_type_id := null;
886: end if;
887:
980: select count(a.object_id) into l_continue
981: from hz_relationships a, hz_parties b
982: where b.party_type = 'PARTY_RELATIONSHIP'
983: and a.party_id in (select source_object_id
984: from jtf_tasks_b
985: where task_id = l_task_rec_tbl(i).id)
986: and a.party_id = b.party_id
987: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
988: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
992: select a.object_id into l_note_context_type_id
993: from hz_relationships a, hz_parties b
994: where b.party_type = 'PARTY_RELATIONSHIP'
995: and a.party_id in (select source_object_id
996: from jtf_tasks_b
997: where task_id = l_task_rec_tbl(i).id)
998: and a.party_id = b.party_id
999: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1000: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1044: select count(a.subject_id) into l_continue
1045: from hz_relationships a, hz_parties b
1046: where b.party_type = 'PARTY_RELATIONSHIP'
1047: and a.party_id = (select source_object_id
1048: from jtf_tasks_b
1049: where task_id = l_task_rec_tbl(i).id)
1050: and a.party_id = b.party_id
1051: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1052: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1056: select a.subject_id into l_note_context_type_id
1057: from hz_relationships a, hz_parties b
1058: where b.party_type = 'PARTY_RELATIONSHIP'
1059: and a.party_id = (select source_object_id
1060: from jtf_tasks_b
1061: where task_id = l_task_rec_tbl(i).id)
1062: and a.party_id = b.party_id
1063: and a.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1064: AND a.OBJECT_TABLE_NAME = 'HZ_PARTIES'