APPS.IGS_PS_GEN_003 dependencies on IGS_CA_INST

Line 528: p_source_cal_type igs_ca_inst.cal_type%type ;

524: shtatiko 05-FEB-2003 Bug# 2550392, Added code to log information wherever needed to make
525: log file more informative.
526: */
527:
528: p_source_cal_type igs_ca_inst.cal_type%type ;
529: p_source_sequence_number igs_ca_inst.sequence_number%type;
530: p_dest_cal_type igs_ca_inst.cal_type%type;
531: p_dest_sequence_number igs_ca_inst.sequence_number%type;
532: p_org_unit_cd igs_or_unit.org_unit_cd%type;

Line 529: p_source_sequence_number igs_ca_inst.sequence_number%type;

525: log file more informative.
526: */
527:
528: p_source_cal_type igs_ca_inst.cal_type%type ;
529: p_source_sequence_number igs_ca_inst.sequence_number%type;
530: p_dest_cal_type igs_ca_inst.cal_type%type;
531: p_dest_sequence_number igs_ca_inst.sequence_number%type;
532: p_org_unit_cd igs_or_unit.org_unit_cd%type;
533: v_check CHAR;

Line 530: p_dest_cal_type igs_ca_inst.cal_type%type;

526: */
527:
528: p_source_cal_type igs_ca_inst.cal_type%type ;
529: p_source_sequence_number igs_ca_inst.sequence_number%type;
530: p_dest_cal_type igs_ca_inst.cal_type%type;
531: p_dest_sequence_number igs_ca_inst.sequence_number%type;
532: p_org_unit_cd igs_or_unit.org_unit_cd%type;
533: v_check CHAR;
534: v_coi_rec IGS_PS_OFR_INST%ROWTYPE;

Line 531: p_dest_sequence_number igs_ca_inst.sequence_number%type;

527:
528: p_source_cal_type igs_ca_inst.cal_type%type ;
529: p_source_sequence_number igs_ca_inst.sequence_number%type;
530: p_dest_cal_type igs_ca_inst.cal_type%type;
531: p_dest_sequence_number igs_ca_inst.sequence_number%type;
532: p_org_unit_cd igs_or_unit.org_unit_cd%type;
533: v_check CHAR;
534: v_coi_rec IGS_PS_OFR_INST%ROWTYPE;
535: v_message VARCHAR2(30);

Line 554: FROM IGS_CA_INST

550: CURSOR c_check_cal_instance_exist(
551: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
552: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS
553: SELECT 'x'
554: FROM IGS_CA_INST
555: WHERE cal_type = cp_cal_type AND
556: sequence_number = cp_sequence_number;
557: CURSOR c_get_cal_instance_dates(
558: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,

Line 561: FROM IGS_CA_INST

557: CURSOR c_get_cal_instance_dates(
558: cp_cal_type IGS_PS_OFR_INST.cal_type%TYPE,
559: cp_sequence_number IGS_PS_OFR_INST.version_number%TYPE) IS
560: SELECT start_dt, end_dt
561: FROM IGS_CA_INST
562: WHERE cal_type = cp_cal_type AND
563: sequence_number = cp_sequence_number;
564: CURSOR c_course_offering_instance IS
565: SELECT coi.course_cd,

Line 603: l_start_dt igs_ca_inst.start_dt%TYPE;

599: x_rowid VARCHAR2(25);
600: INVALID EXCEPTION;
601: VALID EXCEPTION;
602:
603: l_start_dt igs_ca_inst.start_dt%TYPE;
604: l_end_dt igs_ca_inst.end_dt%TYPE;
605:
606: BEGIN
607: -- Parameter Validation

Line 604: l_end_dt igs_ca_inst.end_dt%TYPE;

600: INVALID EXCEPTION;
601: VALID EXCEPTION;
602:
603: l_start_dt igs_ca_inst.start_dt%TYPE;
604: l_end_dt igs_ca_inst.end_dt%TYPE;
605:
606: BEGIN
607: -- Parameter Validation
608: -- Adding the default org id parameter as part of MULTI-ORG changes

Line 1043: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b, igs_ca_inst_all c

1039: AND uoo_id = p_n_uoo_id;
1040:
1041: CURSOR c_occur(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
1042: SELECT b.occurrence_identifier,a.unit_cd,a.version_number,a.location_cd,a.unit_class,c.alternate_code
1043: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b, igs_ca_inst_all c
1044: WHERE a.uoo_id=b.uoo_id
1045: AND b.unit_section_occurrence_id=cp_unit_section_occurrence_id
1046: AND a.cal_type=c.cal_type
1047: AND a.ci_sequence_number=c.sequence_number;