APPS.IEU_WPACTIONS_PVT dependencies on FND_PROFILE

Line 145: l_note_status := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');

141:
142:
143: BEGIN
144:
145: l_note_status := nvl(fnd_profile.value('JTF_NTS_NOTE_STATUS'),'I');
146: --DELETE FROM msista_tmp;
147: --commit;
148: --INSERT INTO msista_Tmp values (11, 'P_Action_Type is '|| P_Action_Type);
149: --commit;

Line 728: IF (FND_PROFILE.VALUE('IEU_AUTO_RELATED') = 'Y') THEN -- this is for source document

724: IF NOT (l_return_status = G_SUCCESS) THEN
725: RAISE fail_exception;
726: ELSE
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;

Line 775: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CUSTOMER') = 'Y') THEN

771: END IF;
772:
773: END IF; -- auto_relate = 1
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;

Line 825: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y') THEN

821:
822: END IF; -- if AS_NOTES_LEAD_CUSTOMER
823:
824:
825: IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y') THEN
826: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
827: --commit;
828: l_continue := 0;
829: for c2_rec in C_note_context_id (l_task_rec_tbl(i).id)

Line 871: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y')

867: IF (c_task_src%ISOPEN) THEN
868: CLOSE c_task_src;
869: END IF;
870:
871: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y')
872:
873: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y') THEN
874: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
875: --commit;

Line 873: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y') THEN

869: END IF;
870:
871: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_LEAD_CONTACT') = 'Y')
872:
873: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y') THEN
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

Line 927: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y')

923: IF (c_task_src%ISOPEN) THEN
924: CLOSE c_task_src;
925: END IF;
926:
927: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y')
928:
929:
930: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y') THEN
931: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );

Line 930: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y') THEN

926:
927: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CUSTOMER') = 'Y')
928:
929:
930: IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y') THEN
931: --INSERT INTO msista_Tmp values (70, 'auto related profile is YES' );
932: --commit;
933: l_continue := 0;
934: for c2_rec in C_note_context_id (l_task_rec_tbl(i).id)

Line 976: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y')

972:
973: IF (c_task_src%ISOPEN) THEN
974: CLOSE c_task_src;
975: END IF;
976: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y')
977:
978: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
979: l_continue := 0;
980: select count(a.object_id) into l_continue

Line 978: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN

974: CLOSE c_task_src;
975: END IF;
976: END IF; -- IF (FND_PROFILE.VALUE('AS_NOTES_OPP_CONTACT') = 'Y')
977:
978: IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y') THEN
979: l_continue := 0;
980: select count(a.object_id) into l_continue
981: from hz_relationships a, hz_parties b
982: where b.party_type = 'PARTY_RELATIONSHIP'

Line 1039: END IF; --IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y')

1035:
1036: IF (c_task_src%ISOPEN) THEN
1037: CLOSE c_task_src;
1038: END IF;
1039: END IF; --IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y')
1040:
1041:
1042: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1043: l_continue := 0;

Line 1042: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN

1038: END IF;
1039: END IF; --IF (FND_PROFILE.VALUE('AS_NOTES_REL_OBJECT') = 'Y')
1040:
1041:
1042: IF (FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y') THEN
1043: l_continue := 0;
1044: select count(a.subject_id) into l_continue
1045: from hz_relationships a, hz_parties b
1046: where b.party_type = 'PARTY_RELATIONSHIP'

Line 1103: END IF; -- if FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y')

1099:
1100: IF (c_task_src%ISOPEN) THEN
1101: CLOSE c_task_src;
1102: END IF;
1103: END IF; -- if FND_PROFILE.VALUE('AS_NOTES_REL_SUBJECT') = 'Y')
1104: END IF; -- if create_note ok
1105: END IF; -- IF (l_note IS NOT NULL)
1106:
1107: -- continue with rest of task items