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.IGS_AD_IMP_025 dependencies on IGS_PE_TEACH_PERIODS_ALL

Line 63: || Obsoleted start_date and end_date columns of igs_pe_housing_int and igs_pe_teach_periods_all

59: || kumma Replaced the ref cursor type validatecur with 2 normal cursors
60: || validate_teach_cur and validate_cal , bug # 2423670
61: || kumma 16-JUN-2002 Added validations for START_DATE to be not null, bug # 2423988
62: || gmaheswa 1-nov-2004 calender type and sequence number can be of active/future load calender.
63: || Obsoleted start_date and end_date columns of igs_pe_housing_int and igs_pe_teach_periods_all
64: || Modified the duplicated record check to be based on cal_type and sequence_number of a person.
65: */
66:
67: l_rule VARCHAR2(1);

Line 90: CURSOR dup_chk_housing_cur(cp_person_id igs_pe_teach_periods_all.person_id%TYPE,

86: i.interface_run_id = cp_interface_run_id AND
87: ai.interface_run_id = cp_interface_run_id;
88:
89: --Cursor to check whether the Record in Interface Table already exists in OSS table
90: CURSOR dup_chk_housing_cur(cp_person_id igs_pe_teach_periods_all.person_id%TYPE,
91: cp_cal_type igs_pe_teach_periods_all.cal_type%TYPE,
92: cp_sequence_number igs_pe_teach_periods_all.sequence_number%TYPE) IS
93: SELECT p.rowid,p.* -- selecting all fields of the interface table...
94: FROM igs_pe_teach_periods_all p

Line 91: cp_cal_type igs_pe_teach_periods_all.cal_type%TYPE,

87: ai.interface_run_id = cp_interface_run_id;
88:
89: --Cursor to check whether the Record in Interface Table already exists in OSS table
90: CURSOR dup_chk_housing_cur(cp_person_id igs_pe_teach_periods_all.person_id%TYPE,
91: cp_cal_type igs_pe_teach_periods_all.cal_type%TYPE,
92: cp_sequence_number igs_pe_teach_periods_all.sequence_number%TYPE) IS
93: SELECT p.rowid,p.* -- selecting all fields of the interface table...
94: FROM igs_pe_teach_periods_all p
95: WHERE p.person_id = cp_person_id AND

Line 92: cp_sequence_number igs_pe_teach_periods_all.sequence_number%TYPE) IS

88:
89: --Cursor to check whether the Record in Interface Table already exists in OSS table
90: CURSOR dup_chk_housing_cur(cp_person_id igs_pe_teach_periods_all.person_id%TYPE,
91: cp_cal_type igs_pe_teach_periods_all.cal_type%TYPE,
92: cp_sequence_number igs_pe_teach_periods_all.sequence_number%TYPE) IS
93: SELECT p.rowid,p.* -- selecting all fields of the interface table...
94: FROM igs_pe_teach_periods_all p
95: WHERE p.person_id = cp_person_id AND
96: p.cal_type = cp_cal_type AND

Line 94: FROM igs_pe_teach_periods_all p

90: CURSOR dup_chk_housing_cur(cp_person_id igs_pe_teach_periods_all.person_id%TYPE,
91: cp_cal_type igs_pe_teach_periods_all.cal_type%TYPE,
92: cp_sequence_number igs_pe_teach_periods_all.sequence_number%TYPE) IS
93: SELECT p.rowid,p.* -- selecting all fields of the interface table...
94: FROM igs_pe_teach_periods_all p
95: WHERE p.person_id = cp_person_id AND
96: p.cal_type = cp_cal_type AND
97: p.sequence_number = cp_sequence_number;
98:

Line 107: l_teaching_period_id igs_pe_teach_periods_all.teaching_period_id%TYPE;

103: PROCEDURE crt_pe_house_status(
104: p_housing_rec IN housing_cur%ROWTYPE
105: ) AS
106: l_rowid VARCHAR2(25);
107: l_teaching_period_id igs_pe_teach_periods_all.teaching_period_id%TYPE;
108: l_error_code igs_pe_housing_int.error_code%TYPE;
109: l_org_id NUMBER(15);
110: BEGIN
111: -- Call Log header

Line 386: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

382: WHERE phi.status = '2' AND
383: phi.interface_run_id = l_interface_run_id AND
384: EXISTS
385: (SELECT 1
386: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
387: WHERE phi.interface_id = ai.interface_id AND
388: ai.interface_run_id = l_interface_run_id AND
389: ai.person_id = pi.person_id AND
390: UPPER(phi.cal_type) = pi.cal_type AND

Line 424: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

420: phi.interface_run_id = l_interface_run_id AND
421: phi.match_ind IS NULL AND
422: EXISTS
423: (SELECT 1
424: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
425: WHERE phi.interface_id = ai.interface_id AND
426: ai.interface_run_id = l_interface_run_id AND
427: pi.person_id = ai.person_id AND
428: pi.TEACH_PERIOD_RESID_STAT_CD = UPPER(phi.TEACH_PERIOD_RESID_STAT_CD) AND

Line 442: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

438: UPDATE igs_pe_housing_int phi
439: SET status = 3,
440: match_ind = 20,
441: dup_teaching_period_id = (SELECT pi.teaching_period_id
442: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
443: WHERE ai.interface_id = phi.interface_id AND
444: ai.interface_run_id = l_interface_run_id AND
445: ai.person_id = pi.person_id AND
446: UPPER(phi.cal_type) = pi.cal_type AND

Line 454: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai

450: phi.interface_run_id = l_interface_run_id AND
451: phi.match_ind IS NULL AND
452: EXISTS
453: (SELECT 1
454: FROM igs_pe_teach_periods_all pi, igs_ad_interface_all ai
455: WHERE ai.interface_run_id = l_interface_run_id AND
456: ai.interface_id = phi.interface_id AND
457: ai.person_id = pi.person_id AND
458: UPPER(phi.cal_type) = pi.cal_type AND