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_ST_GEN_004 dependencies on IGS_GE_DATE

Line 240: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'03/31');

236: v_sub_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
237: -- define the submission census dates
238: -- these can be changed if required
239: v_submission_1_census_dt DATE :=
240: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'03/31');
241: v_submission_2_census_dt DATE :=
242: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'08/31');
243: v_ess_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE;
244: v_effective_dt DATE;

Line 242: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'08/31');

238: -- these can be changed if required
239: v_submission_1_census_dt DATE :=
240: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'03/31');
241: v_submission_2_census_dt DATE :=
242: IGS_GE_DATE.igsdate(TO_CHAR(p_submission_yr)||'08/31');
243: v_ess_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE;
244: v_effective_dt DATE;
245: v_unit_effective_dt DATE;
246: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 1337: IGS_GE_DATE.igscharDT(v_ess_snapshot_dt_time), -- Key

1333: TO_CHAR(p_submission_yr) ||
1334: ' ' ||
1335: TO_CHAR(p_submission_number) ||
1336: ',' ||
1337: IGS_GE_DATE.igscharDT(v_ess_snapshot_dt_time), -- Key
1338: v_creation_dt); -- Output parameter. Needed for creating entries.
1339: p_log_creation_dt := v_creation_dt;
1340: -- for submissions 1 and 2, retrieve data from the
1341: -- enrolment statistics snapshot

Line 1359: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1355: gv_other_detail := 'Parm:'
1356: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1357: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1358: || ', p_dt_time- ' ||
1359: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1360: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1361: Fnd_Message.Set_Name('IGS',v_message_name);
1362: IGS_GE_MSG_STACK.ADD;
1363: App_Exception.Raise_Exception;

Line 1382: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1378: gv_other_detail := 'Parm:'
1379: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1380: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1381: || ', p_dt_time- ' ||
1382: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1383: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1384: Fnd_Message.Set_Name('IGS',v_message_name);
1385: IGS_GE_MSG_STACK.ADD;
1386: App_Exception.Raise_Exception;

Line 1399: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1395: gv_other_detail := 'Parm:'
1396: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1397: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1398: || ', p_dt_time- ' ||
1399: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1400: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1401: Fnd_Message.Set_Name('IGS',v_message_name);
1402: IGS_GE_MSG_STACK.ADD;
1403: App_Exception.Raise_Exception;

Line 1416: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1412: gv_other_detail := 'Parm:'
1413: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1414: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1415: || ', p_dt_time- ' ||
1416: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1417: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
1418: Fnd_Message.Set_Name('IGS',v_message_name);
1419: IGS_GE_MSG_STACK.ADD;
1420:

Line 1458: || IGS_GE_DATE.igschar(v_start_dt) || ' - '

1454: v_end_dt;
1455: CLOSE c_ci;
1456: gv_extra_details := 'Cannot determine the Government Semester for - '
1457: || v_enr_snpsht_rec.ci_cal_type || ', '
1458: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1459: || IGS_GE_DATE.igschar(v_end_dt) || ', '
1460: || v_enr_snpsht_rec.sua_cal_type;
1461: gv_other_detail := 'Parm:'
1462: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)

Line 1459: || IGS_GE_DATE.igschar(v_end_dt) || ', '

1455: CLOSE c_ci;
1456: gv_extra_details := 'Cannot determine the Government Semester for - '
1457: || v_enr_snpsht_rec.ci_cal_type || ', '
1458: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1459: || IGS_GE_DATE.igschar(v_end_dt) || ', '
1460: || v_enr_snpsht_rec.sua_cal_type;
1461: gv_other_detail := 'Parm:'
1462: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1463: || ', p_submission_number- ' || TO_CHAR(p_submission_number)

Line 1465: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1461: gv_other_detail := 'Parm:'
1462: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1463: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1464: || ', p_ess_snapshot_dt_time- ' ||
1465: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1466: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1467: || gv_extra_details;
1468: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1469: IGS_GE_MSG_STACK.ADD;

Line 1498: || IGS_GE_DATE.igschar(v_start_dt) || ' - '

1494: v_end_dt;
1495: CLOSE c_ci;
1496: gv_extra_details := 'Cannot determine the Teaching Census Date for - '
1497: || v_enr_snpsht_rec.sua_cal_type || ', '
1498: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1499: || IGS_GE_DATE.igschar(v_end_dt);
1500: gv_other_detail := 'Parm:'
1501: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1502: || ', p_submission_number- ' || TO_CHAR(p_submission_number)

Line 1499: || IGS_GE_DATE.igschar(v_end_dt);

1495: CLOSE c_ci;
1496: gv_extra_details := 'Cannot determine the Teaching Census Date for - '
1497: || v_enr_snpsht_rec.sua_cal_type || ', '
1498: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1499: || IGS_GE_DATE.igschar(v_end_dt);
1500: gv_other_detail := 'Parm:'
1501: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1502: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1503: || ', p_ess_snapshot_dt_time- ' ||

Line 1504: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1500: gv_other_detail := 'Parm:'
1501: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1502: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1503: || ', p_ess_snapshot_dt_time- ' ||
1504: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1505: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1506: || gv_extra_details;
1507: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1508: IGS_GE_MSG_STACK.ADD;

Line 1559: || IGS_GE_DATE.igschar(v_start_dt) || ' - '

1555: || TO_CHAR(v_enr_snpsht_rec.crv_version_number) || ', '
1556: || v_enr_snpsht_rec.unit_cd || ', '
1557: || TO_CHAR(v_enr_snpsht_rec.uv_version_number) || ', '
1558: || v_enr_snpsht_rec.sua_cal_type || ', '
1559: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1560: || IGS_GE_DATE.igschar(v_end_dt) || ', '
1561: || v_enr_snpsht_rec.tr_org_unit_cd || ', '
1562: || IGS_GE_DATE.igscharDT(v_enr_snpsht_rec.tr_ou_start_dt) || ', '
1563: || TO_CHAR(v_enr_snpsht_rec.eftsu) || ', '

Line 1560: || IGS_GE_DATE.igschar(v_end_dt) || ', '

1556: || v_enr_snpsht_rec.unit_cd || ', '
1557: || TO_CHAR(v_enr_snpsht_rec.uv_version_number) || ', '
1558: || v_enr_snpsht_rec.sua_cal_type || ', '
1559: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1560: || IGS_GE_DATE.igschar(v_end_dt) || ', '
1561: || v_enr_snpsht_rec.tr_org_unit_cd || ', '
1562: || IGS_GE_DATE.igscharDT(v_enr_snpsht_rec.tr_ou_start_dt) || ', '
1563: || TO_CHAR(v_enr_snpsht_rec.eftsu) || ', '
1564: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.enrolled_dt) || ', '

Line 1562: || IGS_GE_DATE.igscharDT(v_enr_snpsht_rec.tr_ou_start_dt) || ', '

1558: || v_enr_snpsht_rec.sua_cal_type || ', '
1559: || IGS_GE_DATE.igschar(v_start_dt) || ' - '
1560: || IGS_GE_DATE.igschar(v_end_dt) || ', '
1561: || v_enr_snpsht_rec.tr_org_unit_cd || ', '
1562: || IGS_GE_DATE.igscharDT(v_enr_snpsht_rec.tr_ou_start_dt) || ', '
1563: || TO_CHAR(v_enr_snpsht_rec.eftsu) || ', '
1564: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.enrolled_dt) || ', '
1565: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.discontinued_dt) || ', '
1566: || TO_CHAR(v_govt_semester) || ', '

Line 1564: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.enrolled_dt) || ', '

1560: || IGS_GE_DATE.igschar(v_end_dt) || ', '
1561: || v_enr_snpsht_rec.tr_org_unit_cd || ', '
1562: || IGS_GE_DATE.igscharDT(v_enr_snpsht_rec.tr_ou_start_dt) || ', '
1563: || TO_CHAR(v_enr_snpsht_rec.eftsu) || ', '
1564: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.enrolled_dt) || ', '
1565: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.discontinued_dt) || ', '
1566: || TO_CHAR(v_govt_semester) || ', '
1567: || IGS_GE_DATE.igschar(v_alias_val) || ', '
1568: || v_enr_snpsht_rec.ci_cal_type || ', '

Line 1565: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.discontinued_dt) || ', '

1561: || v_enr_snpsht_rec.tr_org_unit_cd || ', '
1562: || IGS_GE_DATE.igscharDT(v_enr_snpsht_rec.tr_ou_start_dt) || ', '
1563: || TO_CHAR(v_enr_snpsht_rec.eftsu) || ', '
1564: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.enrolled_dt) || ', '
1565: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.discontinued_dt) || ', '
1566: || TO_CHAR(v_govt_semester) || ', '
1567: || IGS_GE_DATE.igschar(v_alias_val) || ', '
1568: || v_enr_snpsht_rec.ci_cal_type || ', '
1569: || IGS_GE_DATE.igschar(v_start_dt_2) || ' - '

Line 1567: || IGS_GE_DATE.igschar(v_alias_val) || ', '

1563: || TO_CHAR(v_enr_snpsht_rec.eftsu) || ', '
1564: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.enrolled_dt) || ', '
1565: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.discontinued_dt) || ', '
1566: || TO_CHAR(v_govt_semester) || ', '
1567: || IGS_GE_DATE.igschar(v_alias_val) || ', '
1568: || v_enr_snpsht_rec.ci_cal_type || ', '
1569: || IGS_GE_DATE.igschar(v_start_dt_2) || ' - '
1570: || IGS_GE_DATE.igschar(v_end_dt_2);
1571: gv_other_detail := 'Parm:'

Line 1569: || IGS_GE_DATE.igschar(v_start_dt_2) || ' - '

1565: || IGS_GE_DATE.igschar(v_enr_snpsht_rec.discontinued_dt) || ', '
1566: || TO_CHAR(v_govt_semester) || ', '
1567: || IGS_GE_DATE.igschar(v_alias_val) || ', '
1568: || v_enr_snpsht_rec.ci_cal_type || ', '
1569: || IGS_GE_DATE.igschar(v_start_dt_2) || ' - '
1570: || IGS_GE_DATE.igschar(v_end_dt_2);
1571: gv_other_detail := 'Parm:'
1572: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1573: || ', p_submission_number- ' || TO_CHAR(p_submission_number)

Line 1570: || IGS_GE_DATE.igschar(v_end_dt_2);

1566: || TO_CHAR(v_govt_semester) || ', '
1567: || IGS_GE_DATE.igschar(v_alias_val) || ', '
1568: || v_enr_snpsht_rec.ci_cal_type || ', '
1569: || IGS_GE_DATE.igschar(v_start_dt_2) || ' - '
1570: || IGS_GE_DATE.igschar(v_end_dt_2);
1571: gv_other_detail := 'Parm:'
1572: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1573: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1574: || ', p_ess_snapshot_dt_time- ' ||

Line 1575: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1571: gv_other_detail := 'Parm:'
1572: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1573: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1574: || ', p_ess_snapshot_dt_time- ' ||
1575: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1576: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1577: || gv_extra_details;
1578:
1579: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 1692: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1688: gv_other_detail := 'Parm:'
1689: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1690: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1691: || ', p_ess_snapshot_dt_time- ' ||
1692: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1693: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1694: || gv_extra_details;
1695: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1696: IGS_GE_MSG_STACK.ADD;

Line 1896: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

1892: gv_other_detail := 'Parm:'
1893: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
1894: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
1895: || ', p_ess_snapshot_dt_time- ' ||
1896: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
1897: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind || ' '
1898: || gv_extra_details;
1899: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
1900: IGS_GE_MSG_STACK.ADD;

Line 2126: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

2122: gv_other_detail := 'Parm:'
2123: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
2124: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
2125: || ', p_dt_time- ' ||
2126: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
2127: || ', p_ind- ' || p_use_most_recent_ess_ind
2128: || ', ' || gv_extra_details;
2129: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2130: IGS_GE_MSG_STACK.ADD;

Line 2163: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

2159: gv_other_detail := 'Parm:'
2160: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
2161: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
2162: || ', p_dt_time- ' ||
2163: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
2164: || ', p_ind- ' || p_use_most_recent_ess_ind
2165: || ', ' || gv_extra_details;
2166: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2167: IGS_GE_MSG_STACK.ADD;

Line 2253: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)

2249: gv_other_detail := 'Parm:'
2250: || ' p_submission_yr- ' || TO_CHAR(p_submission_yr)
2251: || ', p_submission_number- ' || TO_CHAR(p_submission_number)
2252: || ', p_dt_time- ' ||
2253: IGS_GE_DATE.igscharDT(p_ess_snapshot_dt_time)
2254: || ', p_use_most_recent_ess_ind- ' || p_use_most_recent_ess_ind;
2255: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2256: IGS_GE_MSG_STACK.ADD;
2257: App_Exception.Raise_Exception;

Line 2331: IGS_GE_DATE.igscharDT(v_creation_dt),

2327: --Check if an entry has been written to the error log
2328: --Create an entry in the system log entry
2329: IGS_GE_GEN_003.genp_ins_log_entry (
2330: v_s_log_type,
2331: IGS_GE_DATE.igscharDT(v_creation_dt),
2332: 'IGS_PE_PERSON IGS_PS_COURSE ' || ',' || TO_CHAR(v_person_id) || ',' || v_course_cd,
2333: 4222,
2334: NULL);
2335: -- set that an error has been logged

Line 3229: v_effective_dt := IGS_GE_DATE.igsdate(v_char_date);

3225: v_char_date := TO_CHAR(p_submission_yr)||'03/31/';
3226: ELSE -- Submission 2
3227: v_char_date := TO_CHAR(p_submission_yr)||'08/31/';
3228: END IF;
3229: v_effective_dt := IGS_GE_DATE.igsdate(v_char_date);
3230: -- select all govt_student_liability_records for previous submission
3231: FOR v_gsli_gslc IN c_gsli_gslc LOOP
3232: v_person_id := v_gsli_gslc.person_id;
3233: v_course_cd := v_gsli_gslc.course_cd;