eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_ASSIGN_REVIEW_GRP dependencies on IGS_GE_NUMBER

Line 263: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

259:
260: IF p_calendar_details IS NOT NULL THEN
261: -- Get the Academic Calander details form the Academic Calender Parameter
262: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
263: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
264:
265: -- Get the Admission Calander details form the Admission Calender Parameter
266: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
267: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

Line 267: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

263: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
264:
265: -- Get the Admission Calander details form the Admission Calender Parameter
266: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
267: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
268:
269:
270: IF l_acad_cal_type IS NULL OR l_acad_ci_sequence_number IS NULL OR l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL THEN
271: fnd_dsql.add_text(' 1=2 ' );

Line 433: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

429: x_mode => 'R');
430:
431: -- Write the Application Instance which got Assigned to a
432: -- Particular Review Code to the Log file
433: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
434: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
435: LPAD(l_nominated_course_cd,'15',' ')||
436: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
437: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 434: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||

430:
431: -- Write the Application Instance which got Assigned to a
432: -- Particular Review Code to the Log file
433: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
434: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
435: LPAD(l_nominated_course_cd,'15',' ')||
436: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
437: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
438: -- Update Using Table Handler

Line 436: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

432: -- Particular Review Code to the Log file
433: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
434: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
435: LPAD(l_nominated_course_cd,'15',' ')||
436: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
437: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
438: -- Update Using Table Handler
439: igs_ad_appl_arp_pkg.update_row (
440: x_rowid => c_arp_rec_found_rec.rowid,

Line 452: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

448: x_mode => 'R');
449:
450: -- Write the Application Instance which got Assigned to a
451: --Particular Review Code to the Log file
452: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
453: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
454: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
455: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
456: END IF;

Line 453: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||

449:
450: -- Write the Application Instance which got Assigned to a
451: --Particular Review Code to the Log file
452: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
453: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
454: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
455: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
456: END IF;
457: CLOSE c_arp_rec_found;

Line 455: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

451: --Particular Review Code to the Log file
452: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
453: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
454: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
455: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
456: END IF;
457: CLOSE c_arp_rec_found;
458:
459:

Line 556: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

552:
553: IF p_calendar_details IS NOT NULL THEN
554: -- Get the Academic Calander details form the Academic Calender Parameter
555: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
556: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
557:
558: -- Get the Admission Calander details form the Admission Calender Parameter
559: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
560: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

Line 560: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

556: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
557:
558: -- Get the Admission Calander details form the Admission Calender Parameter
559: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
560: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
561:
562:
563: IF l_acad_cal_type IS NULL OR l_acad_ci_sequence_number IS NULL OR l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL THEN
564: fnd_dsql.add_text(' 1=2 ' );

Line 804: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

800: x_mode => 'R');
801:
802: -- Write the Application Instance
803: --which got Assigned to a Particular Review Code to the Log file
804: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
805: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
806: LPAD(l_nominated_course_cd,'15',' ')||
807: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
808:

Line 805: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||

801:
802: -- Write the Application Instance
803: --which got Assigned to a Particular Review Code to the Log file
804: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
805: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
806: LPAD(l_nominated_course_cd,'15',' ')||
807: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
808:
809: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 807: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

803: --which got Assigned to a Particular Review Code to the Log file
804: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
805: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
806: LPAD(l_nominated_course_cd,'15',' ')||
807: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
808:
809: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
810: -- Update Using Table Handler
811: igs_ad_appl_arp_pkg.update_row (

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

820: x_mode => 'R');
821:
822: -- Write the Application Instance which got Assigned to a
823: -- Particular Review Code to the Log file
824: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
825: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
826: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
827: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
828:

Line 825: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||

821:
822: -- Write the Application Instance which got Assigned to a
823: -- Particular Review Code to the Log file
824: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
825: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
826: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
827: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
828:
829: END IF;

Line 827: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

823: -- Particular Review Code to the Log file
824: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
825: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
826: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
827: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
828:
829: END IF;
830: CLOSE c_arp_rec_found;
831: END LOOP;

Line 926: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

922:
923: IF p_calendar_details IS NOT NULL THEN
924: -- Get the Academic Calander details form the Academic Calender Parameter
925: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
926: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
927:
928: -- Get the Admission Calander details form the Admission Calender Parameter
929: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
930: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

Line 930: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

926: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
927:
928: -- Get the Admission Calander details form the Admission Calender Parameter
929: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
930: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
931:
932:
933: IF l_acad_cal_type IS NULL OR l_acad_ci_sequence_number IS NULL OR l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL THEN
934: fnd_dsql.add_text(' 1=2 ' );

Line 1177: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

1173:
1174: -- Write the Application Instance which got
1175: --Assigned to a Particular Review Code to the Log file
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,
1177: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1178: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1179: LPAD(l_nominated_course_cd,'15',' ')||
1180: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1181:

Line 1178: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||

1174: -- Write the Application Instance which got
1175: --Assigned to a Particular Review Code to the Log file
1176: FND_FILE.PUT_LINE(FND_FILE.LOG,
1177: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1178: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1179: LPAD(l_nominated_course_cd,'15',' ')||
1180: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1181:
1182: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 1180: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

1176: FND_FILE.PUT_LINE(FND_FILE.LOG,
1177: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1178: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1179: LPAD(l_nominated_course_cd,'15',' ')||
1180: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1181:
1182: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1183: -- Update Using Table Handler
1184: igs_ad_appl_arp_pkg.update_row (

Line 1198: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

1194:
1195: -- Write the Application Instance which got
1196: --Assigned to a Particular Review Code to the Log file
1197: FND_FILE.PUT_LINE(FND_FILE.LOG,
1198: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1199: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1200: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1201: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1202:

Line 1199: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||

1195: -- Write the Application Instance which got
1196: --Assigned to a Particular Review Code to the Log file
1197: FND_FILE.PUT_LINE(FND_FILE.LOG,
1198: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1199: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1200: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1201: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1202:
1203: END IF;

Line 1201: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

1197: FND_FILE.PUT_LINE(FND_FILE.LOG,
1198: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1199: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1200: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1201: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1202:
1203: END IF;
1204: CLOSE c_arp_rec_found;
1205: END LOOP;

Line 1300: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

1296:
1297: IF p_calendar_details IS NOT NULL THEN
1298: -- Get the Academic Calander details form the Academic Calender Parameter
1299: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
1300: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
1301:
1302: -- Get the Admission Calander details form the Admission Calender Parameter
1303: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
1304: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

Line 1304: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

1300: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
1301:
1302: -- Get the Admission Calander details form the Admission Calender Parameter
1303: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
1304: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
1305:
1306:
1307: IF l_acad_cal_type IS NULL OR l_acad_ci_sequence_number IS NULL OR l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL THEN
1308: fnd_dsql.add_text(' 1=2 ' );

Line 1477: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

1473: x_mode => 'R');
1474:
1475: -- Write the Application Instance which got
1476: --Assigned to a Particular Review Code to the Log file
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1478: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1479: LPAD(l_nominated_course_cd,'15',' ')||
1480: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1481:

Line 1478: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||

1474:
1475: -- Write the Application Instance which got
1476: --Assigned to a Particular Review Code to the Log file
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1478: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1479: LPAD(l_nominated_course_cd,'15',' ')||
1480: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1481:
1482: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 1480: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

1476: --Assigned to a Particular Review Code to the Log file
1477: FND_FILE.PUT_LINE(FND_FILE.LOG,LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1478: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1479: LPAD(l_nominated_course_cd,'15',' ')||
1480: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1481:
1482: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1483: -- Update Using Table Handler
1484: igs_ad_appl_arp_pkg.update_row (

Line 1498: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

1494:
1495: -- Write the Application Instance which got
1496: --Assigned to a Particular Review Code to the Log file
1497: FND_FILE.PUT_LINE(FND_FILE.LOG,
1498: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1499: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1500: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1501: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1502:

Line 1499: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||

1495: -- Write the Application Instance which got
1496: --Assigned to a Particular Review Code to the Log file
1497: FND_FILE.PUT_LINE(FND_FILE.LOG,
1498: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1499: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1500: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1501: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1502:
1503: END IF;

Line 1501: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

1497: FND_FILE.PUT_LINE(FND_FILE.LOG,
1498: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1499: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1500: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1501: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1502:
1503: END IF;
1504: CLOSE c_arp_rec_found;
1505:

Line 1600: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

1596:
1597: IF p_calendar_details IS NOT NULL THEN
1598: -- Get the Academic Calander details form the Academic Calender Parameter
1599: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
1600: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
1601:
1602: -- Get the Admission Calander details form the Admission Calender Parameter
1603: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
1604: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

Line 1604: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

1600: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
1601:
1602: -- Get the Admission Calander details form the Admission Calender Parameter
1603: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
1604: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
1605:
1606:
1607: IF l_acad_cal_type IS NULL OR l_acad_ci_sequence_number IS NULL OR l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL THEN
1608: fnd_dsql.add_text(' 1=2 ' );

Line 1701: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

1697:
1698: -- Write the Application Instance which got
1699: -- Assigned to a Particular Review Code to the Log file
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,
1701: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1702: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1703: LPAD(l_nominated_course_cd,'15',' ')||
1704: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1705:

Line 1702: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||

1698: -- Write the Application Instance which got
1699: -- Assigned to a Particular Review Code to the Log file
1700: FND_FILE.PUT_LINE(FND_FILE.LOG,
1701: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1702: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1703: LPAD(l_nominated_course_cd,'15',' ')||
1704: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1705:
1706: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 1704: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

1700: FND_FILE.PUT_LINE(FND_FILE.LOG,
1701: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1702: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1703: LPAD(l_nominated_course_cd,'15',' ')||
1704: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1705:
1706: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1707: -- Update Using Table Handler
1708: igs_ad_appl_arp_pkg.update_row (

Line 1722: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

1718:
1719: -- Write the Application Instance which got
1720: -- Assigned to a Particular Review Code to the Log file
1721: FND_FILE.PUT_LINE(FND_FILE.LOG,
1722: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1723: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1724: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1725: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1726:

Line 1723: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||

1719: -- Write the Application Instance which got
1720: -- Assigned to a Particular Review Code to the Log file
1721: FND_FILE.PUT_LINE(FND_FILE.LOG,
1722: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1723: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1724: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1725: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1726:
1727: END IF;

Line 1725: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

1721: FND_FILE.PUT_LINE(FND_FILE.LOG,
1722: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1723: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1724: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1725: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1726:
1727: END IF;
1728: CLOSE c_arp_rec_found;
1729:

Line 1824: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));

1820:
1821: IF p_calendar_details IS NOT NULL THEN
1822: -- Get the Academic Calander details form the Academic Calender Parameter
1823: l_acad_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 1, 10));
1824: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
1825:
1826: -- Get the Admission Calander details form the Admission Calender Parameter
1827: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
1828: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

Line 1828: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));

1824: l_acad_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 14, 6));
1825:
1826: -- Get the Admission Calander details form the Admission Calender Parameter
1827: l_adm_cal_type := RTRIM ( SUBSTR ( p_calendar_details, 23, 10));
1828: l_adm_ci_sequence_number := IGS_GE_NUMBER.TO_NUM ( SUBSTR ( p_calendar_details, 37, 6));
1829:
1830:
1831: IF l_acad_cal_type IS NULL OR l_acad_ci_sequence_number IS NULL OR l_adm_cal_type IS NULL OR l_adm_ci_sequence_number IS NULL THEN
1832: fnd_dsql.add_text(' 1=2 ' );

Line 1920: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||

1916:
1917: -- Write the Application Instance which got
1918: --Assigned to a Particular Review Code to the Log file
1919: FND_FILE.PUT_LINE(FND_FILE.LOG,
1920: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1921: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1922: LPAD(l_nominated_course_cd,'15',' ')||
1923: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1924:

Line 1921: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||

1917: -- Write the Application Instance which got
1918: --Assigned to a Particular Review Code to the Log file
1919: FND_FILE.PUT_LINE(FND_FILE.LOG,
1920: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1921: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1922: LPAD(l_nominated_course_cd,'15',' ')||
1923: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1924:
1925: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN

Line 1923: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));

1919: FND_FILE.PUT_LINE(FND_FILE.LOG,
1920: LPAD(IGS_GE_NUMBER.TO_CANN(l_person_id),'20',' ')||
1921: LPAD(IGS_GE_NUMBER.TO_CANN(l_admission_appl_number),'20',' ')||
1922: LPAD(l_nominated_course_cd,'15',' ')||
1923: LPAD(IGS_GE_NUMBER.TO_CANN(l_sequence_number),'20',' '));
1924:
1925: ELSIF c_arp_rec_found_rec.appl_revprof_revgr_id IS NULL THEN
1926: -- Update Using Table Handler
1927: igs_ad_appl_arp_pkg.update_row (

Line 1941: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||

1937:
1938: -- Write the Application Instance which got Assigned to a
1939: --Particular Review Code to the Log file
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,
1941: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1942: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1943: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1944: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1945:

Line 1942: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||

1938: -- Write the Application Instance which got Assigned to a
1939: --Particular Review Code to the Log file
1940: FND_FILE.PUT_LINE(FND_FILE.LOG,
1941: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1942: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1943: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1944: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1945:
1946: END IF;

Line 1944: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));

1940: FND_FILE.PUT_LINE(FND_FILE.LOG,
1941: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.person_id),'20',' ')||
1942: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.admission_appl_number),'20',' ')||
1943: LPAD(c_arp_rec_found_rec.nominated_course_cd,'20',' ')||
1944: LPAD(IGS_GE_NUMBER.TO_CANN(c_arp_rec_found_rec.sequence_number),'20',' '));
1945:
1946: END IF;
1947: CLOSE c_arp_rec_found;
1948: