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

Line 28: p_acad_cal_type IGS_CA_INST.cal_type%type;

24: p_academic_period IN VARCHAR2,
25: p_admission_cat IN VARCHAR2,
26: p_org_id IN NUMBER )
27: IS
28: p_acad_cal_type IGS_CA_INST.cal_type%type;
29: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%type;
30: BEGIN -- admp_ins_acadci_roll
31: -- Routine to rollover all admission period details from the old
32: -- academic period to a new academic period. This can be restricted

Line 29: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%type;

25: p_admission_cat IN VARCHAR2,
26: p_org_id IN NUMBER )
27: IS
28: p_acad_cal_type IGS_CA_INST.cal_type%type;
29: p_acad_ci_sequence_number IGS_CA_INST.sequence_number%type;
30: BEGIN -- admp_ins_acadci_roll
31: -- Routine to rollover all admission period details from the old
32: -- academic period to a new academic period. This can be restricted
33: -- to an admission category

Line 48: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

44:
45: DECLARE
46: cst_admission CONSTANT VARCHAR2(9) := 'ADMISSION';
47: cst_error CONSTANT VARCHAR2(1) := 'E';
48: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
49: v_message_name VARCHAR2(30);
50: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
51: v_return_type VARCHAR2(1);
52: v_s_log_type VARCHAR2(8);

Line 54: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

50: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
51: v_return_type VARCHAR2(1);
52: v_s_log_type VARCHAR2(8);
53: CURSOR c_ci (
54: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
55: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
56: SELECT ci.alternate_code
57: FROM IGS_CA_INST ci
58: WHERE ci.cal_type = cp_acad_cal_type AND

Line 55: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

51: v_return_type VARCHAR2(1);
52: v_s_log_type VARCHAR2(8);
53: CURSOR c_ci (
54: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
55: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
56: SELECT ci.alternate_code
57: FROM IGS_CA_INST ci
58: WHERE ci.cal_type = cp_acad_cal_type AND
59: ci.sequence_number = cp_acad_ci_sequence_number;

Line 57: FROM IGS_CA_INST ci

53: CURSOR c_ci (
54: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
55: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
56: SELECT ci.alternate_code
57: FROM IGS_CA_INST ci
58: WHERE ci.cal_type = cp_acad_cal_type AND
59: ci.sequence_number = cp_acad_ci_sequence_number;
60: CURSOR c_cir (
61: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

Line 61: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

57: FROM IGS_CA_INST ci
58: WHERE ci.cal_type = cp_acad_cal_type AND
59: ci.sequence_number = cp_acad_ci_sequence_number;
60: CURSOR c_cir (
61: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
62: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
63: SELECT ci.cal_type,
64: ci.sequence_number,
65: ci.prior_ci_sequence_number

Line 62: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

58: WHERE ci.cal_type = cp_acad_cal_type AND
59: ci.sequence_number = cp_acad_ci_sequence_number;
60: CURSOR c_cir (
61: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
62: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
63: SELECT ci.cal_type,
64: ci.sequence_number,
65: ci.prior_ci_sequence_number
66: FROM IGS_CA_INST_REL cir,

Line 66: FROM IGS_CA_INST_REL cir,

62: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
63: SELECT ci.cal_type,
64: ci.sequence_number,
65: ci.prior_ci_sequence_number
66: FROM IGS_CA_INST_REL cir,
67: IGS_CA_INST ci,
68: IGS_CA_TYPE cat
69: WHERE cat.cal_type = ci.cal_type AND
70: cat.s_cal_cat = cst_admission AND

Line 67: IGS_CA_INST ci,

63: SELECT ci.cal_type,
64: ci.sequence_number,
65: ci.prior_ci_sequence_number
66: FROM IGS_CA_INST_REL cir,
67: IGS_CA_INST ci,
68: IGS_CA_TYPE cat
69: WHERE cat.cal_type = ci.cal_type AND
70: cat.s_cal_cat = cst_admission AND
71: cir.sup_cal_type = cp_acad_cal_type AND

Line 228: IGS_CA_INST_REL cir

224: cp_version_number IGS_AD_PRD_PS_OF_OPT.version_number%TYPE,
225: cp_acad_cal_type IGS_AD_PRD_PS_OF_OPT.acad_cal_type%TYPE) IS
226: SELECT 'x'
227: FROM IGS_PS_OFR_PAT cop,
228: IGS_CA_INST_REL cir
229: WHERE cir.sub_cal_type = p_adm_cal_type AND
230: cir.sub_ci_sequence_number = p_new_adm_ci_sequence_number AND
231: cop.course_cd = cp_course_cd AND
232: cop.version_number = cp_version_number AND

Line 276: FROM IGS_CA_INST

272:
273: CURSOR c_start_end_dt IS
274: SELECT start_dt,
275: end_dt
276: FROM IGS_CA_INST
277: WHERE cal_type = p_adm_cal_type AND
278: sequence_number = p_new_adm_ci_sequence_number;
279: v_dt_rec c_start_end_dt%ROWTYPE;
280: BEGIN

Line 527: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;

523: --Routine to rollover all details from the old admission period to the new.
524: DECLARE
525: cst_error CONSTANT VARCHAR2(1) := 'E';
526: cst_warn CONSTANT VARCHAR2(1) := 'W';
527: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
528: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
529: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
530: v_message_name VARCHAR2(30);
531: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;

Line 528: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;

524: DECLARE
525: cst_error CONSTANT VARCHAR2(1) := 'E';
526: cst_warn CONSTANT VARCHAR2(1) := 'W';
527: v_ci_start_dt IGS_CA_INST.start_dt%TYPE;
528: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
529: v_creation_dt IGS_GE_S_LOG.creation_dt%TYPE;
530: v_message_name VARCHAR2(30);
531: v_s_log_type IGS_GE_S_LOG.s_log_type%TYPE;
532: v_adm_calendar VARCHAR2(50);

Line 541: v_start_dt IGS_CA_INST.start_dt%TYPE;

537: v_apcoo_exist VARCHAR2(1);
538: v_apac2_exist VARCHAR2(1);
539: --parameters required by call to IGS_AD_INS_ADMPERD.admp_val_adm_ci as OUT NOCOPY
540: -- parameters they are not used for any other purpose
541: v_start_dt IGS_CA_INST.start_dt%TYPE;
542: v_end_dt IGS_CA_INST.end_dt%TYPE;
543: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
544: CURSOR c_apcoo IS
545: SELECT 'X'

Line 542: v_end_dt IGS_CA_INST.end_dt%TYPE;

538: v_apac2_exist VARCHAR2(1);
539: --parameters required by call to IGS_AD_INS_ADMPERD.admp_val_adm_ci as OUT NOCOPY
540: -- parameters they are not used for any other purpose
541: v_start_dt IGS_CA_INST.start_dt%TYPE;
542: v_end_dt IGS_CA_INST.end_dt%TYPE;
543: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
544: CURSOR c_apcoo IS
545: SELECT 'X'
546: FROM IGS_AD_PRD_PS_OF_OPT apcoo

Line 543: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

539: --parameters required by call to IGS_AD_INS_ADMPERD.admp_val_adm_ci as OUT NOCOPY
540: -- parameters they are not used for any other purpose
541: v_start_dt IGS_CA_INST.start_dt%TYPE;
542: v_end_dt IGS_CA_INST.end_dt%TYPE;
543: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
544: CURSOR c_apcoo IS
545: SELECT 'X'
546: FROM IGS_AD_PRD_PS_OF_OPT apcoo
547: WHERE apcoo.adm_cal_type = p_adm_cal_type AND

Line 554: FROM IGS_CA_INST ci

550: apcoo.admission_cat = p_admission_cat);
551: CURSOR c_ci IS
552: SELECT ci.start_dt,
553: ci.end_dt
554: FROM IGS_CA_INST ci
555: WHERE ci.cal_type = p_adm_cal_type AND
556: ci.sequence_number = p_new_adm_ci_sequence_number;
557: CURSOR c_apac1 IS
558: SELECT apac.adm_cal_type,