APPS.IGS_PE_GEN_002 dependencies on IGS_GE_DATE

Line 522: SELECT igs_ge_date.igsdate(igs_ge_date.igschar(cp_date))

518:
519: --check the date format of the start date
520: DECLARE
521: CURSOR c_dt_format(cp_date VARCHAR2) IS
522: SELECT igs_ge_date.igsdate(igs_ge_date.igschar(cp_date))
523: FROM DUAL;
524:
525:
526: BEGIN

Line 555: OPEN c_hold_alrdy_exst(l_student_rec.person_id,l_hold_type, igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)));

551: return;
552: END;
553:
554: --Check whether the hold already exists on the student
555: OPEN c_hold_alrdy_exst(l_student_rec.person_id,l_hold_type, igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)));
556: FETCH c_hold_alrdy_exst INTO l_exist_exp_dt;
557:
558: IF c_hold_alrdy_exst%NOTFOUND THEN
559: CLOSE c_hold_alrdy_exst;

Line 572: igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),

568:
569: IF IGS_EN_VAL_PEN.enrp_val_pen_open (
570: l_student_rec.person_id,
571: l_hold_type,
572: igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
573: v_message_name) = FALSE THEN
574:
575: IF v_message_name IS NOT NULL then
576:

Line 598: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),

594: igs_pe_gen_002.apply_admin_hold
595: (
596: p_person_id => l_student_rec.person_id,
597: p_encumbrance_type => l_hold_type,
598: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
599: p_end_dt => l_d_expiry_date,
600: p_authorising_person_id => NULL,
601: p_comments => NULL,
602: p_spo_course_cd => NULL,

Line 649: igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),

645:
646: IF IGS_EN_VAL_PEN.enrp_val_pen_open (
647: l_student_rec.person_id,
648: l_hold_type,
649: igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
650: v_message_name) = FALSE THEN
651:
652: IF v_message_name IS NOT NULL then
653:

Line 672: IF igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)) < TRUNC(SYSDATE) THEN

668:
669:
670: --Before releasing check the end date with the sysdate
671: IF l_expiry_date IS NOT NULL THEN
672: IF igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)) < TRUNC(SYSDATE) THEN
673: l_error :='IGS_EN_DT_NOT_LT_CURR_DT';
674: message_get(l_error,l_message_name);
675: Wf_Engine.SetItemAttrText(
676: ItemType => itemtype,

Line 683: ELSIF igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)) < igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)) THEN

679: avalue => l_message_name
680: );
681: resultout := 'COMPLETE:F';
682: return;
683: ELSIF igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)) < igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)) THEN
684: l_error := 'IGS_EN_EXPDT_GE_STDT';
685: message_get(l_error,l_message_name);
686: Wf_Engine.SetItemAttrText(
687: ItemType => itemtype,

Line 727: OPEN c_external_hold_exst(l_student_rec.person_id,l_hold_type,igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),l_external_ref);

723:
724:
725: END IF;
726:
727: OPEN c_external_hold_exst(l_student_rec.person_id,l_hold_type,igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),l_external_ref);
728: FETCH c_external_hold_exst INTO l_exist;
729:
730: IF c_external_hold_exst%NOTFOUND THEN
731: -- External reference does not match

Line 759: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),

755: p_resp_id => NULL,
756: p_fnd_user_id => NULL,
757: p_person_id => l_student_rec.person_id,
758: p_encumbrance_type => l_hold_type,
759: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
760: p_expiry_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)),
761: p_override_resp => 'X',
762: p_message_name => l_message_name
763: );

Line 760: p_expiry_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)),

756: p_fnd_user_id => NULL,
757: p_person_id => l_student_rec.person_id,
758: p_encumbrance_type => l_hold_type,
759: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
760: p_expiry_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)),
761: p_override_resp => 'X',
762: p_message_name => l_message_name
763: );
764: