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

Line 25: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

21: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
24: p_uoo_id IN NUMBER ,
25: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
26: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
27: p_override_enrolled_cp IN NUMBER ,
28: p_override_eftsu IN NUMBER ,
29: p_truncate_ind IN VARCHAR2 ,

Line 26: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

22: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
23: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
24: p_uoo_id IN NUMBER ,
25: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
26: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
27: p_override_enrolled_cp IN NUMBER ,
28: p_override_eftsu IN NUMBER ,
29: p_truncate_ind IN VARCHAR2 ,
30: p_sca_cp_total IN NUMBER,

Line 71: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,

67: p_unit_version_number IGS_EN_SU_ATTEMPT_ALL.version_number%TYPE ,
68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
70: p_uoo_id IN NUMBER ,
71: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
72: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
73: p_override_enrolled_cp IN NUMBER ,
74: p_override_eftsu IN NUMBER ,
75: p_truncate_ind IN VARCHAR2 ,

Line 72: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,

68: p_teach_cal_type IGS_EN_SU_ATTEMPT_ALL.cal_type%TYPE ,
69: p_teach_sequence_number IGS_EN_SU_ATTEMPT_ALL.ci_sequence_number%TYPE ,
70: p_uoo_id IN NUMBER ,
71: p_load_cal_type IGS_CA_INST_ALL.cal_type%TYPE ,
72: p_load_sequence_number IGS_CA_INST_ALL.sequence_number%TYPE ,
73: p_override_enrolled_cp IN NUMBER ,
74: p_override_eftsu IN NUMBER ,
75: p_truncate_ind IN VARCHAR2 ,
76: p_sca_cp_total IN NUMBER ,

Line 143: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;

139: Function Enrs_Get_Acad_Alt_Cd(
140: p_cal_type IN VARCHAR2 ,
141: p_ci_sequence_number IN NUMBER )
142: RETURN VARCHAR2 AS
143: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
144: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
145: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
146: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
147: v_message_name Varchar2(30);

Line 144: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

140: p_cal_type IN VARCHAR2 ,
141: p_ci_sequence_number IN NUMBER )
142: RETURN VARCHAR2 AS
143: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
144: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
145: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
146: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
147: v_message_name Varchar2(30);
148: BEGIN

Line 145: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;

141: p_ci_sequence_number IN NUMBER )
142: RETURN VARCHAR2 AS
143: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
144: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
145: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
146: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
147: v_message_name Varchar2(30);
148: BEGIN
149: RETURN IGS_EN_GEN_002.enrp_get_acad_alt_cd(p_cal_type,

Line 146: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;

142: RETURN VARCHAR2 AS
143: v_acad_cal_type IGS_CA_INST.cal_type%TYPE;
144: v_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
145: v_acad_ci_start_dt IGS_CA_INST.start_dt%TYPE;
146: v_acad_ci_end_dt IGS_CA_INST.end_dt%TYPE;
147: v_message_name Varchar2(30);
148: BEGIN
149: RETURN IGS_EN_GEN_002.enrp_get_acad_alt_cd(p_cal_type,
150: p_ci_sequence_number,

Line 300: CURSOR c_all_cur_load_cal (cp_cal_type igs_ca_inst.cal_type%TYPE,

296:
297: cst_active VARCHAR2(10);
298: cst_load VARCHAR2(10);
299:
300: CURSOR c_all_cur_load_cal (cp_cal_type igs_ca_inst.cal_type%TYPE,
301: cp_effective_dt DATE
302: )
303: IS
304: SELECT DISTINCT ci.cal_type,

Line 311: igs_ca_inst ci,

307: ci.start_dt,
308: ci.end_dt,
309: ci.description
310: FROM igs_ca_type ct,
311: igs_ca_inst ci,
312: igs_ca_stat cs,
313: igs_ca_inst_rel cir
314: WHERE cs.s_cal_status = cst_active
315: AND ci.cal_status = cs.cal_status

Line 313: igs_ca_inst_rel cir

309: ci.description
310: FROM igs_ca_type ct,
311: igs_ca_inst ci,
312: igs_ca_stat cs,
313: igs_ca_inst_rel cir
314: WHERE cs.s_cal_status = cst_active
315: AND ci.cal_status = cs.cal_status
316: AND ct.s_cal_cat = cst_load
317: AND ci.cal_type = ct.cal_type

Line 370: CURSOR c_all_fut_load_cal (cp_cal_type igs_ca_inst.cal_type%TYPE,

366:
367: cst_active VARCHAR2(10);
368: cst_load VARCHAR2(10);
369:
370: CURSOR c_all_fut_load_cal (cp_cal_type igs_ca_inst.cal_type%TYPE,
371: cp_cur_cal_erly_st_dt igs_ca_inst.start_dt%TYPE)
372: IS
373: SELECT DISTINCT ci.cal_type,
374: ci.sequence_number,

Line 371: cp_cur_cal_erly_st_dt igs_ca_inst.start_dt%TYPE)

367: cst_active VARCHAR2(10);
368: cst_load VARCHAR2(10);
369:
370: CURSOR c_all_fut_load_cal (cp_cal_type igs_ca_inst.cal_type%TYPE,
371: cp_cur_cal_erly_st_dt igs_ca_inst.start_dt%TYPE)
372: IS
373: SELECT DISTINCT ci.cal_type,
374: ci.sequence_number,
375: ci.alternate_code,

Line 380: igs_ca_inst ci,

376: ci.start_dt,
377: ci.end_dt,
378: ci.description
379: FROM igs_ca_type ct,
380: igs_ca_inst ci,
381: igs_ca_stat cs,
382: igs_ca_inst_rel cir
383: WHERE cs.s_cal_status = cst_active
384: AND ci.cal_status = cs.cal_status

Line 382: igs_ca_inst_rel cir

378: ci.description
379: FROM igs_ca_type ct,
380: igs_ca_inst ci,
381: igs_ca_stat cs,
382: igs_ca_inst_rel cir
383: WHERE cs.s_cal_status = cst_active
384: AND ci.cal_status = cs.cal_status
385: AND ct.s_cal_cat = cst_load
386: AND ci.cal_type = ct.cal_type

Line 395: l_cur_cal_erly_st_dt igs_ca_inst.start_dt%TYPE;

391: ORDER BY ci.start_dt ;
392:
393: l_future_ld_cal_table_info load_cal_table_type;
394: l_cur_load_cal_table_info_str VARCHAR2(2000);
395: l_cur_cal_erly_st_dt igs_ca_inst.start_dt%TYPE;
396: l_cur_load_cal_table_info load_cal_table_type;
397: l_next_row NUMBER;
398:
399: BEGIN

Line 470: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

466: l_nth_occurence INTEGER;
467: l_seqno_caltype_info VARCHAR2(2000);
468: l_load_cal_table_info load_cal_table_type ;
469: l_seqno_and_caltype VARCHAR2(100);
470: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
471: l_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
472: l_cal_seq_sep_index INTEGER;
473: l_next_row INTEGER;
474: CURSOR c_get_cal_inst_info(cp_caltype IGS_CA_INST.CAL_TYPE%TYPE,

Line 471: l_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

467: l_seqno_caltype_info VARCHAR2(2000);
468: l_load_cal_table_info load_cal_table_type ;
469: l_seqno_and_caltype VARCHAR2(100);
470: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
471: l_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
472: l_cal_seq_sep_index INTEGER;
473: l_next_row INTEGER;
474: CURSOR c_get_cal_inst_info(cp_caltype IGS_CA_INST.CAL_TYPE%TYPE,
475: cp_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE)

Line 474: CURSOR c_get_cal_inst_info(cp_caltype IGS_CA_INST.CAL_TYPE%TYPE,

470: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
471: l_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
472: l_cal_seq_sep_index INTEGER;
473: l_next_row INTEGER;
474: CURSOR c_get_cal_inst_info(cp_caltype IGS_CA_INST.CAL_TYPE%TYPE,
475: cp_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE)
476: IS
477: SELECT ci.cal_type,
478: ci.sequence_number,

Line 475: cp_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE)

471: l_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
472: l_cal_seq_sep_index INTEGER;
473: l_next_row INTEGER;
474: CURSOR c_get_cal_inst_info(cp_caltype IGS_CA_INST.CAL_TYPE%TYPE,
475: cp_cal_seqno IGS_CA_INST.SEQUENCE_NUMBER%TYPE)
476: IS
477: SELECT ci.cal_type,
478: ci.sequence_number,
479: ci.alternate_code,

Line 483: FROM igs_ca_inst ci

479: ci.alternate_code,
480: ci.start_dt,
481: ci.end_dt,
482: ci.description
483: FROM igs_ca_inst ci
484: WHERE ci.cal_type = cp_caltype
485: AND ci.sequence_number = cp_cal_seqno;
486:
487: c_load_cal_rec c_get_cal_inst_info%ROWTYPE;