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.

[Home] [Help]

APPS.IGF_AW_SS_GEN_PKG dependencies on IGS_PS_VER_ALL

Line 255: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

251: AND apt.ld_sequence_number = cal.sequence_number
252: ORDER BY cal.start_dt ASC;
253:
254: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
255: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
256: lc_version_num igs_ps_ver_all.version_number%TYPE;
257: lc_program_type igs_ps_ver_all.course_type%TYPE;
258: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
259:

Line 256: lc_version_num igs_ps_ver_all.version_number%TYPE;

252: ORDER BY cal.start_dt ASC;
253:
254: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
255: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
256: lc_version_num igs_ps_ver_all.version_number%TYPE;
257: lc_program_type igs_ps_ver_all.course_type%TYPE;
258: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
259:
260: p_last_accept_date DATE;

Line 257: lc_program_type igs_ps_ver_all.course_type%TYPE;

253:
254: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
255: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
256: lc_version_num igs_ps_ver_all.version_number%TYPE;
257: lc_program_type igs_ps_ver_all.course_type%TYPE;
258: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
259:
260: p_last_accept_date DATE;
261:

Line 258: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

254: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
255: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
256: lc_version_num igs_ps_ver_all.version_number%TYPE;
257: lc_program_type igs_ps_ver_all.course_type%TYPE;
258: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
259:
260: p_last_accept_date DATE;
261:
262: BEGIN

Line 360: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

356: AND apt.ld_sequence_number = cal.sequence_number
357: ORDER BY cal.start_dt ASC;
358:
359: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
360: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
361: lc_version_num igs_ps_ver_all.version_number%TYPE;
362: lc_program_type igs_ps_ver_all.course_type%TYPE;
363: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
364:

Line 361: lc_version_num igs_ps_ver_all.version_number%TYPE;

357: ORDER BY cal.start_dt ASC;
358:
359: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
360: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
361: lc_version_num igs_ps_ver_all.version_number%TYPE;
362: lc_program_type igs_ps_ver_all.course_type%TYPE;
363: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
364:
365: p_last_accept_date DATE;

Line 362: lc_program_type igs_ps_ver_all.course_type%TYPE;

358:
359: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
360: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
361: lc_version_num igs_ps_ver_all.version_number%TYPE;
362: lc_program_type igs_ps_ver_all.course_type%TYPE;
363: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
364:
365: p_last_accept_date DATE;
366:

Line 363: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

359: lc_all_terms_awd_prd cur_all_terms_awd_prd%ROWTYPE; -- place holder for the fetched value for cursor cur_all_terms_awd_prd
360: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
361: lc_version_num igs_ps_ver_all.version_number%TYPE;
362: lc_program_type igs_ps_ver_all.course_type%TYPE;
363: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
364:
365: p_last_accept_date DATE;
366:
367: BEGIN

Line 1393: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

1389: p_offered_amt NUMBER,
1390: p_ld_cal_type VARCHAR2,
1391: p_ld_seq_num NUMBER)
1392: RETURN VARCHAR2 AS
1393: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1394: lc_version_num igs_ps_ver_all.version_number%TYPE;
1395: lc_program_type igs_ps_ver_all.course_type%TYPE;
1396: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1397:

Line 1394: lc_version_num igs_ps_ver_all.version_number%TYPE;

1390: p_ld_cal_type VARCHAR2,
1391: p_ld_seq_num NUMBER)
1392: RETURN VARCHAR2 AS
1393: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1394: lc_version_num igs_ps_ver_all.version_number%TYPE;
1395: lc_program_type igs_ps_ver_all.course_type%TYPE;
1396: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1397:
1398: l_last_accept_date DATE;

Line 1395: lc_program_type igs_ps_ver_all.course_type%TYPE;

1391: p_ld_seq_num NUMBER)
1392: RETURN VARCHAR2 AS
1393: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1394: lc_version_num igs_ps_ver_all.version_number%TYPE;
1395: lc_program_type igs_ps_ver_all.course_type%TYPE;
1396: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1397:
1398: l_last_accept_date DATE;
1399:

Line 1396: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

1392: RETURN VARCHAR2 AS
1393: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1394: lc_version_num igs_ps_ver_all.version_number%TYPE;
1395: lc_program_type igs_ps_ver_all.course_type%TYPE;
1396: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1397:
1398: l_last_accept_date DATE;
1399:
1400: CURSOR c_get_base_id (cp_award_id NUMBER) IS

Line 1572: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

1568: p_offered_amt NUMBER,
1569: p_ld_cal_type VARCHAR2,
1570: p_ld_seq_num NUMBER)
1571: RETURN VARCHAR2 AS
1572: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1573: lc_version_num igs_ps_ver_all.version_number%TYPE;
1574: lc_program_type igs_ps_ver_all.course_type%TYPE;
1575: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1576:

Line 1573: lc_version_num igs_ps_ver_all.version_number%TYPE;

1569: p_ld_cal_type VARCHAR2,
1570: p_ld_seq_num NUMBER)
1571: RETURN VARCHAR2 AS
1572: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1573: lc_version_num igs_ps_ver_all.version_number%TYPE;
1574: lc_program_type igs_ps_ver_all.course_type%TYPE;
1575: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1576:
1577: l_last_accept_date DATE;

Line 1574: lc_program_type igs_ps_ver_all.course_type%TYPE;

1570: p_ld_seq_num NUMBER)
1571: RETURN VARCHAR2 AS
1572: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1573: lc_version_num igs_ps_ver_all.version_number%TYPE;
1574: lc_program_type igs_ps_ver_all.course_type%TYPE;
1575: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1576:
1577: l_last_accept_date DATE;
1578:

Line 1575: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

1571: RETURN VARCHAR2 AS
1572: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1573: lc_version_num igs_ps_ver_all.version_number%TYPE;
1574: lc_program_type igs_ps_ver_all.course_type%TYPE;
1575: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1576:
1577: l_last_accept_date DATE;
1578:
1579: CURSOR c_get_base_id (cp_award_id NUMBER) IS

Line 1751: lc_program_cd igs_ps_ver_all.course_cd%TYPE;

1747: p_ld_cal_type VARCHAR2,
1748: p_ld_seq_num NUMBER)
1749: RETURN VARCHAR2 AS
1750:
1751: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1752: lc_version_num igs_ps_ver_all.version_number%TYPE;
1753: lc_program_type igs_ps_ver_all.course_type%TYPE;
1754: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1755:

Line 1752: lc_version_num igs_ps_ver_all.version_number%TYPE;

1748: p_ld_seq_num NUMBER)
1749: RETURN VARCHAR2 AS
1750:
1751: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1752: lc_version_num igs_ps_ver_all.version_number%TYPE;
1753: lc_program_type igs_ps_ver_all.course_type%TYPE;
1754: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1755:
1756: l_last_accept_date DATE;

Line 1753: lc_program_type igs_ps_ver_all.course_type%TYPE;

1749: RETURN VARCHAR2 AS
1750:
1751: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1752: lc_version_num igs_ps_ver_all.version_number%TYPE;
1753: lc_program_type igs_ps_ver_all.course_type%TYPE;
1754: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1755:
1756: l_last_accept_date DATE;
1757:

Line 1754: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;

1750:
1751: lc_program_cd igs_ps_ver_all.course_cd%TYPE;
1752: lc_version_num igs_ps_ver_all.version_number%TYPE;
1753: lc_program_type igs_ps_ver_all.course_type%TYPE;
1754: lc_org_unit igs_ps_ver_all.responsible_org_unit_cd%TYPE;
1755:
1756: l_last_accept_date DATE;
1757:
1758: CURSOR c_get_base_id (cp_award_id NUMBER) IS