DBA Data[Home] [Help]

APPS.IGS_AZ_GEN_001 dependencies on FND_NEW_MESSAGES

Line 1165: lvcHoldMsgSubject fnd_new_messages.message_text%TYPE;

1161: lvReturnStatus VARCHAR2(1);
1162: lvMsgData VARCHAR2(100);
1163: lnMsgCount NUMBER;
1164: lvcHoldPersonIds VARCHAR2(32767); -- Variable to hold the comma separated person IDs of the students who are going to be applied advising hold. Will be used in sending the notification.
1165: lvcHoldMsgSubject fnd_new_messages.message_text%TYPE;
1166: lvcHoldMsgText fnd_new_messages.message_text%TYPE;
1167: lvnHoldExixts NUMBER;
1168: lvEncumbranceType igs_pe_pers_encumb.encumbrance_type%TYPE;
1169: lvEncmbTypeStartDt igs_pe_pers_encumb.start_dt%TYPE;

Line 1166: lvcHoldMsgText fnd_new_messages.message_text%TYPE;

1162: lvMsgData VARCHAR2(100);
1163: lnMsgCount NUMBER;
1164: lvcHoldPersonIds VARCHAR2(32767); -- Variable to hold the comma separated person IDs of the students who are going to be applied advising hold. Will be used in sending the notification.
1165: lvcHoldMsgSubject fnd_new_messages.message_text%TYPE;
1166: lvcHoldMsgText fnd_new_messages.message_text%TYPE;
1167: lvnHoldExixts NUMBER;
1168: lvEncumbranceType igs_pe_pers_encumb.encumbrance_type%TYPE;
1169: lvEncmbTypeStartDt igs_pe_pers_encumb.start_dt%TYPE;
1170: l_cur_az_holds_upd cur_az_holds_upd%ROWTYPE;

Line 1451: -- Get the Default message subject. This can be got from FND_NEW_MESSAGES table. PLacing here before any loop because subject remains same for

1447: lncount NUMBER := 0;
1448: --
1449: BEGIN
1450: --
1451: -- Get the Default message subject. This can be got from FND_NEW_MESSAGES table. PLacing here before any loop because subject remains same for
1452: -- all kinds of advising notification. (Message IGS_AZ_NOTIF_SUBJECT Token Group name ).
1453: --
1454: IGS_GE_GEN_003.SET_ORG_ID(); -- swaghmar, bug# 4951054
1455: