DBA Data[Home] [Help]

APPS.IGS_AS_GEN_006 dependencies on IGS_GE_DATE

Line 1234: ocr.other_reference = TO_CHAR(suaai.ass_id) || '|' || IGS_GE_DATE.IGSCHARDT(suaai.creation_dt)

1230: ocr.cal_type = suaai.cal_type AND
1231: ocr.ci_sequence_number = suaai.ci_sequence_number AND
1232: ocr.course_cd = suaai.course_cd AND
1233: ocr.unit_cd = suaai.unit_cd AND
1234: ocr.other_reference = TO_CHAR(suaai.ass_id) || '|' || IGS_GE_DATE.IGSCHARDT(suaai.creation_dt)
1235: )
1236: )
1237: )
1238: ORDER BY suaai.person_id, suaai.unit_cd;

Line 1635: IGS_GE_DATE.IGSCHARDT(v_enrolled_rec.creation_dt) || '|' ||

1631:
1632: CLOSE c_ai;
1633: v_record := v_record ||
1634: TO_CHAR(v_enrolled_rec.ass_id) || '|' ||
1635: IGS_GE_DATE.IGSCHARDT(v_enrolled_rec.creation_dt) || '|' ||
1636: v_suv_rec.uai_reference || '|' ||
1637: v_ai_rec.description || '|';
1638:
1639:

Line 1642: IF v_suv_rec.uai_due_dt < NVL(v_enrolled_rec.override_due_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN -- Start Of if 15

1638:
1639:
1640: -- If Student Assessment Due date is less than the override_due_dt then take the override_due_dt
1641: -- else take the uai_due_dt
1642: IF v_suv_rec.uai_due_dt < NVL(v_enrolled_rec.override_due_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN -- Start Of if 15
1643:
1644: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_enrolled_rec.override_due_dt) || '|';
1645: ELSE
1646: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_suv_rec.uai_due_dt) || '|';

Line 1644: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_enrolled_rec.override_due_dt) || '|';

1640: -- If Student Assessment Due date is less than the override_due_dt then take the override_due_dt
1641: -- else take the uai_due_dt
1642: IF v_suv_rec.uai_due_dt < NVL(v_enrolled_rec.override_due_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN -- Start Of if 15
1643:
1644: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_enrolled_rec.override_due_dt) || '|';
1645: ELSE
1646: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_suv_rec.uai_due_dt) || '|';
1647: END IF; -- End Of if 15
1648:

Line 1646: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_suv_rec.uai_due_dt) || '|';

1642: IF v_suv_rec.uai_due_dt < NVL(v_enrolled_rec.override_due_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) THEN -- Start Of if 15
1643:
1644: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_enrolled_rec.override_due_dt) || '|';
1645: ELSE
1646: v_record := v_record || IGS_GE_DATE.IGSCHAR(v_suv_rec.uai_due_dt) || '|';
1647: END IF; -- End Of if 15
1648:
1649: v_record := v_record || TO_CHAR(v_enrolled_rec.tracking_id);
1650: