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_EN_NSC_PKG dependencies on IGS_CA_INST

Line 16: l_load_cal_type igs_ca_inst.cal_type%TYPE;

12: l_doc_inst_params igs_en_doc_instances.doc_inst_params%TYPE;
13: l_ant_grad_date DATE;
14: l_grad_type VARCHAR2(25);
15: l_load_term_cd VARCHAR2(20);
16: l_load_cal_type igs_ca_inst.cal_type%TYPE;
17: l_load_cal_seq igs_ca_inst.sequence_number%TYPE;
18: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
19: l_found BOOLEAN := FALSE;
20: TYPE t_counts IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;

Line 17: l_load_cal_seq igs_ca_inst.sequence_number%TYPE;

13: l_ant_grad_date DATE;
14: l_grad_type VARCHAR2(25);
15: l_load_term_cd VARCHAR2(20);
16: l_load_cal_type igs_ca_inst.cal_type%TYPE;
17: l_load_cal_seq igs_ca_inst.sequence_number%TYPE;
18: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
19: l_found BOOLEAN := FALSE;
20: TYPE t_counts IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
21: g_counts t_counts ;

Line 18: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

14: l_grad_type VARCHAR2(25);
15: l_load_term_cd VARCHAR2(20);
16: l_load_cal_type igs_ca_inst.cal_type%TYPE;
17: l_load_cal_seq igs_ca_inst.sequence_number%TYPE;
18: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
19: l_found BOOLEAN := FALSE;
20: TYPE t_counts IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
21: g_counts t_counts ;
22:

Line 38: FROM igs_ca_inst

34: CURSOR c_cal_data (l_c_cal_type VARCHAR2,l_c_seq_number NUMBER) IS
35: SELECT start_dt ,
36: end_dt ,
37: alternate_code
38: FROM igs_ca_inst
39: WHERE cal_type = l_c_cal_type
40: AND sequence_number = l_c_seq_number;
41:
42: -- Type of student record

Line 87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

83:
84: FUNCTION Get_Enrollment_Status (
85: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
86: p_student_id IN igs_pe_person.person_id%TYPE ,
87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
91: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

Line 88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

84: FUNCTION Get_Enrollment_Status (
85: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
86: p_student_id IN igs_pe_person.person_id%TYPE ,
87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
91: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
92: x_credit_points OUT NOCOPY NUMBER,

Line 89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

85: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
86: p_student_id IN igs_pe_person.person_id%TYPE ,
87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
91: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
92: x_credit_points OUT NOCOPY NUMBER,
93: x_status_date OUT NOCOPY DATE,

Line 90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

86: p_student_id IN igs_pe_person.person_id%TYPE ,
87: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
88: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
89: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
90: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
91: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
92: x_credit_points OUT NOCOPY NUMBER,
93: x_status_date OUT NOCOPY DATE,
94: x_grad_level OUT NOCOPY VARCHAR2,

Line 113: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

109: FUNCTION Get_Status_Change_Date (
110: p_student_id IN igs_pe_person.person_id%TYPE,
111: p_old_status IN VARCHAR2,
112: p_new_status IN VARCHAR2,
113: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
114: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
115: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
116: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
117: ) RETURN DATE;

Line 114: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

110: p_student_id IN igs_pe_person.person_id%TYPE,
111: p_old_status IN VARCHAR2,
112: p_new_status IN VARCHAR2,
113: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
114: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
115: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
116: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
117: ) RETURN DATE;
118:

Line 115: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

111: p_old_status IN VARCHAR2,
112: p_new_status IN VARCHAR2,
113: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
114: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
115: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
116: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
117: ) RETURN DATE;
118:
119:

Line 116: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE

112: p_new_status IN VARCHAR2,
113: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
114: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
115: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
116: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
117: ) RETURN DATE;
118:
119:
120:

Line 127: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

123: */
124: PROCEDURE Create_Header_Record (
125: p_school_code IN VARCHAR2,
126: p_branch_code IN VARCHAR2,
127: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
128: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
129: p_report_flag IN VARCHAR2,
130: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
131: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE

Line 128: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

124: PROCEDURE Create_Header_Record (
125: p_school_code IN VARCHAR2,
126: p_branch_code IN VARCHAR2,
127: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
128: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
129: p_report_flag IN VARCHAR2,
130: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
131: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE
132: ) ;

Line 171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

167: */
168:
169: PROCEDURE Get_Student_Data (
170: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
175: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

Line 172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

168:
169: PROCEDURE Get_Student_Data (
170: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
175: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
176: p_student_data IN OUT NOCOPY student_data_type,

Line 173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

169: PROCEDURE Get_Student_Data (
170: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
175: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
176: p_student_data IN OUT NOCOPY student_data_type,
177: p_nslc_condition IN varchar2

Line 174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

170: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
171: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
172: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
173: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
174: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
175: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
176: p_student_data IN OUT NOCOPY student_data_type,
177: p_nslc_condition IN varchar2
178: );

Line 245: l_load_cal_type igs_ca_inst.cal_type%TYPE;

241:
242: l_api_name CONSTANT VARCHAR2(30) := 'Create_Snapshot';
243: cst_valid CONSTANT VARCHAR2(30) := 'VALID';
244: l_student_data student_data_type;
245: l_load_cal_type igs_ca_inst.cal_type%TYPE;
246: l_acad_cal_seq igs_ca_inst.sequence_number%TYPE;
247: l_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE :=NULL;
248: l_branch_code VARCHAR2(20);
249: l_load_term_s_date DATE;

Line 246: l_acad_cal_seq igs_ca_inst.sequence_number%TYPE;

242: l_api_name CONSTANT VARCHAR2(30) := 'Create_Snapshot';
243: cst_valid CONSTANT VARCHAR2(30) := 'VALID';
244: l_student_data student_data_type;
245: l_load_cal_type igs_ca_inst.cal_type%TYPE;
246: l_acad_cal_seq igs_ca_inst.sequence_number%TYPE;
247: l_snapshot_id igs_en_doc_instances.doc_inst_id%TYPE :=NULL;
248: l_branch_code VARCHAR2(20);
249: l_load_term_s_date DATE;
250: l_load_term_e_date DATE;

Line 256: FROM igs_ca_inst_rel

252:
253: CURSOR c_acad_term IS
254: SELECT sup_cal_type,
255: sup_ci_sequence_number
256: FROM igs_ca_inst_rel
257: WHERE sub_cal_type = l_load_cal_type
258: AND sub_ci_sequence_number = l_load_cal_seq
259: AND sup_cal_type IN
260: (SELECT cal_type

Line 1147: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1143:
1144: PROCEDURE Create_Header_Record (
1145: p_school_code IN VARCHAR2,
1146: p_branch_code IN VARCHAR2,
1147: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1148: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1149: p_report_flag IN VARCHAR2,
1150: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1151: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE

Line 1148: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

1144: PROCEDURE Create_Header_Record (
1145: p_school_code IN VARCHAR2,
1146: p_branch_code IN VARCHAR2,
1147: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1148: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1149: p_report_flag IN VARCHAR2,
1150: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1151: x_snapshot_id OUT NOCOPY igs_en_doc_instances.doc_inst_id%TYPE
1152: ) IS

Line 1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1382:
1383:
1384: PROCEDURE Get_Student_Data (
1385: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1390: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

Line 1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

1383:
1384: PROCEDURE Get_Student_Data (
1385: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1390: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1391: p_student_data IN OUT NOCOPY student_data_type,

Line 1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

1384: PROCEDURE Get_Student_Data (
1385: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1390: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1391: p_student_data IN OUT NOCOPY student_data_type,
1392: p_nslc_condition IN VARCHAR2

Line 1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

1385: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1386: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1387: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1388: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1389: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1390: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1391: p_student_data IN OUT NOCOPY student_data_type,
1392: p_nslc_condition IN VARCHAR2
1393: )IS

Line 1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

1713:
1714: FUNCTION Get_Enrollment_Status (
1715: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1716: p_student_id IN igs_pe_person.person_id%TYPE ,
1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1721: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,

Line 1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

1714: FUNCTION Get_Enrollment_Status (
1715: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1716: p_student_id IN igs_pe_person.person_id%TYPE ,
1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1721: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1722: x_credit_points OUT NOCOPY NUMBER,

Line 1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

1715: p_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1716: p_student_id IN igs_pe_person.person_id%TYPE ,
1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1721: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1722: x_credit_points OUT NOCOPY NUMBER,
1723: x_status_date OUT NOCOPY DATE,

Line 1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,

1716: p_student_id IN igs_pe_person.person_id%TYPE ,
1717: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
1718: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1719: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
1720: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE,
1721: p_prev_snapshot_id IN igs_en_doc_instances.doc_inst_id%TYPE,
1722: x_credit_points OUT NOCOPY NUMBER,
1723: x_status_date OUT NOCOPY DATE,
1724: x_grad_level OUT NOCOPY VARCHAR2,

Line 2030: CURSOR cur_strt_date(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) is

2026: cst_load CONSTANT igs_ca_type.s_cal_cat%TYPE := 'LOAD';
2027: l_valid_pgm VARCHAR2(1);
2028:
2029: --fetch start dateof the academic calendar for which the job is run
2030: CURSOR cur_strt_date(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) is
2031: SELECT to_char(start_dt,'mm-dd-yyyy')
2032: FROM igs_ca_inst
2033: WHERE cal_type = cp_cal_type
2034: AND sequence_number = cp_seq_number;

Line 2032: FROM igs_ca_inst

2028:
2029: --fetch start dateof the academic calendar for which the job is run
2030: CURSOR cur_strt_date(cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) is
2031: SELECT to_char(start_dt,'mm-dd-yyyy')
2032: FROM igs_ca_inst
2033: WHERE cal_type = cp_cal_type
2034: AND sequence_number = cp_seq_number;
2035:
2036: -- fetch all acad calendars that start or end in the calendar year of the

Line 2042: igs_ca_inst ci,

2038: CURSOR acad_cal(cp_start_year VARCHAR2
2039: ) IS
2040: SELECT ci.cal_type, ci.SEQUENCE_NUMBER
2041: FROM igs_ca_type ct,
2042: igs_ca_inst ci,
2043: igs_ca_stat cs
2044: WHERE ci.cal_type = ct.cal_type
2045: AND ct.s_cal_cat = 'ACADEMIC'
2046: AND ct.closed_ind = 'N'

Line 2056: cp_cal_type IGS_CA_INST.cal_type%TYPE,

2052: );
2053:
2054: --for all acad calendars that are in teh calendar year, get teh subordinate load cals.
2055: CURSOR c_load_cal_instance(
2056: cp_cal_type IGS_CA_INST.cal_type%TYPE,
2057: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2058: SELECT ci.cal_type,
2059: ci.sequence_number
2060: FROM igs_ca_type ct,

Line 2057: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

2053:
2054: --for all acad calendars that are in teh calendar year, get teh subordinate load cals.
2055: CURSOR c_load_cal_instance(
2056: cp_cal_type IGS_CA_INST.cal_type%TYPE,
2057: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2058: SELECT ci.cal_type,
2059: ci.sequence_number
2060: FROM igs_ca_type ct,
2061: igs_ca_inst ci,

Line 2061: igs_ca_inst ci,

2057: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2058: SELECT ci.cal_type,
2059: ci.sequence_number
2060: FROM igs_ca_type ct,
2061: igs_ca_inst ci,
2062: igs_ca_stat cs,
2063: igs_ca_inst_rel cir
2064: WHERE ct.closed_ind = 'N' AND
2065: cs.s_cal_status = cst_active AND

Line 2063: igs_ca_inst_rel cir

2059: ci.sequence_number
2060: FROM igs_ca_type ct,
2061: igs_ca_inst ci,
2062: igs_ca_stat cs,
2063: igs_ca_inst_rel cir
2064: WHERE ct.closed_ind = 'N' AND
2065: cs.s_cal_status = cst_active AND
2066: ci.cal_status = cs.cal_status AND
2067: ct.s_cal_cat = cst_load AND

Line 2076: CURSOR cur_spa(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_load_cal_type igs_ca_inst.cal_type%TYPE,

2072: cir.sup_ci_sequence_number = cp_sequence_number;
2073:
2074: --fetch course that have unit attempts in the term .
2075: -- smaddali modified cursor form perf bug#4914052
2076: CURSOR cur_spa(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2077: cp_load_cal_seq igs_ca_inst.sequence_number%TYPE) IS
2078: SELECT DISTINCT spa.course_cd, spa.version_number
2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,
2080: igs_ca_load_to_teach_v lod

Line 2077: cp_load_cal_seq igs_ca_inst.sequence_number%TYPE) IS

2073:
2074: --fetch course that have unit attempts in the term .
2075: -- smaddali modified cursor form perf bug#4914052
2076: CURSOR cur_spa(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2077: cp_load_cal_seq igs_ca_inst.sequence_number%TYPE) IS
2078: SELECT DISTINCT spa.course_cd, spa.version_number
2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,
2080: igs_ca_load_to_teach_v lod
2081: WHERE spa.person_id = p_student_id

Line 2613: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,

2609: FUNCTION Get_Status_Change_Date (
2610: p_student_id IN igs_pe_person.person_id%TYPE,
2611: p_old_status IN VARCHAR2,
2612: p_new_status IN VARCHAR2,
2613: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2614: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
2615: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2616: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
2617: ) RETURN DATE

Line 2614: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,

2610: p_student_id IN igs_pe_person.person_id%TYPE,
2611: p_old_status IN VARCHAR2,
2612: p_new_status IN VARCHAR2,
2613: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2614: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
2615: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2616: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
2617: ) RETURN DATE
2618: -------------------------------------------------------------------------------------------

Line 2615: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,

2611: p_old_status IN VARCHAR2,
2612: p_new_status IN VARCHAR2,
2613: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2614: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
2615: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2616: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
2617: ) RETURN DATE
2618: -------------------------------------------------------------------------------------------
2619: --Change History:

Line 2616: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE

2612: p_new_status IN VARCHAR2,
2613: p_load_cal_type IN igs_ca_inst.cal_type%TYPE,
2614: p_load_cal_seq IN igs_ca_inst.sequence_number%TYPE,
2615: p_acad_cal_type IN igs_ca_inst.cal_type%TYPE,
2616: p_acad_cal_seq IN igs_ca_inst.sequence_number%TYPE
2617: ) RETURN DATE
2618: -------------------------------------------------------------------------------------------
2619: --Change History:
2620: --Who When What

Line 2710: CURSOR c_drop_units(p_teach_cal_type IGS_CA_INST.cal_type%TYPE,

2706:
2707: -- modified by ckasu as a prt of bug 5073484.
2708: -- List of all history units
2709:
2710: CURSOR c_drop_units(p_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2711: p_teach_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2712: SELECT ut.course_cd ,
2713: pr.version_number cr_ver_number ,
2714: ut.unit_cd ,

Line 2711: p_teach_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

2707: -- modified by ckasu as a prt of bug 5073484.
2708: -- List of all history units
2709:
2710: CURSOR c_drop_units(p_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2711: p_teach_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
2712: SELECT ut.course_cd ,
2713: pr.version_number cr_ver_number ,
2714: ut.unit_cd ,
2715: ut.version_number unit_ver_number,