APPS.IGS_RE_WORKFLOW dependencies on FND_NEW_MESSAGES

Line 855: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS

851: WHERE person_id = cp_person_id;
852:
853: l_c_full_name c_full_name%ROWTYPE;
854:
855: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
856: SELECT message_text
857: FROM fnd_new_messages
858: WHERE message_name = cp_message_name;
859:

Line 857: FROM fnd_new_messages

853: l_c_full_name c_full_name%ROWTYPE;
854:
855: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
856: SELECT message_text
857: FROM fnd_new_messages
858: WHERE message_name = cp_message_name;
859:
860: l_c_mesg_text c_mesg_text%ROWTYPE;
861:

Line 1052: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS

1048:
1049: l_c_full_name c_full_name%ROWTYPE;
1050: l_c_full_name_sup c_full_name%ROWTYPE;
1051:
1052: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
1053: SELECT message_text
1054: FROM fnd_new_messages
1055: WHERE message_name = cp_message_name;
1056:

Line 1054: FROM fnd_new_messages

1050: l_c_full_name_sup c_full_name%ROWTYPE;
1051:
1052: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
1053: SELECT message_text
1054: FROM fnd_new_messages
1055: WHERE message_name = cp_message_name;
1056:
1057: l_c_mesg_text c_mesg_text%ROWTYPE;
1058:

Line 1387: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS

1383: WHERE person_id = cp_person_id;
1384:
1385: l_c_full_name c_full_name%ROWTYPE;
1386:
1387: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
1388: SELECT message_text
1389: FROM fnd_new_messages
1390: WHERE message_name = cp_message_name;
1391:

Line 1389: FROM fnd_new_messages

1385: l_c_full_name c_full_name%ROWTYPE;
1386:
1387: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
1388: SELECT message_text
1389: FROM fnd_new_messages
1390: WHERE message_name = cp_message_name;
1391:
1392: l_c_mesg_text c_mesg_text%ROWTYPE;
1393:

Line 2540: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS

2536: WHERE person_id = cp_person_id;
2537:
2538: l_c_full_name c_full_name%ROWTYPE;
2539:
2540: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
2541: SELECT message_text
2542: FROM fnd_new_messages
2543: WHERE message_name = cp_message_name;
2544:

Line 2542: FROM fnd_new_messages

2538: l_c_full_name c_full_name%ROWTYPE;
2539:
2540: CURSOR c_mesg_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
2541: SELECT message_text
2542: FROM fnd_new_messages
2543: WHERE message_name = cp_message_name;
2544:
2545: l_c_mesg_text c_mesg_text%ROWTYPE;
2546: