APPS.IGS_EN_GEN_018 dependencies on IGS_PS_UNIT_OFR_OPT

Line 548: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

544: cst_primary VARCHAR2(40):='PRIMARY';
545:
546: l_person_id igs_pe_person.person_id%TYPE;
547: l_person_type VARCHAR2(30);
548: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
549: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
550: l_usec_status igs_ps_unit_ver.unit_status%TYPE;
551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;

Line 549: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;

545:
546: l_person_id igs_pe_person.person_id%TYPE;
547: l_person_type VARCHAR2(30);
548: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
549: l_rel_type igs_ps_unit_ofr_opt.relation_type%TYPE;
550: l_usec_status igs_ps_unit_ver.unit_status%TYPE;
551: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
552: l_acad_seq_num igs_ca_inst.sequence_number%TYPE;
553: l_acad_alt_cd igs_ca_inst.alternate_code%TYPE;

Line 579: l_sup_unit igs_ps_unit_ofr_opt.uoo_id%TYPE;

575: l_processed_rec BOOLEAN := FALSE; -- Boolean to indicate if any records where processed
576: l_batch_desc VARCHAR2(100);
577: l_core_indicator_code igs_en_su_attempt.core_indicator_code%TYPE;
578: l_sup_units_list VARCHAR2(2000);
579: l_sup_unit igs_ps_unit_ofr_opt.uoo_id%TYPE;
580: l_sub_success VARCHAR2(2000);
581: l_sub_waitlist VARCHAR2(2000);
582: l_sub_failed VARCHAR2(2000);
583: l_save_message_no NUMBER;

Line 1265: FROM igs_ps_unit_ofr_opt

1261: cp_location_cd IN VARCHAR2,
1262: cp_unit_class IN VARCHAR2) IS
1263: SELECT NVL(relation_type,'NONE')||'*'||uoo_id||'*'||unit_section_status||'*'||NVL(auditable_ind,'N')||'*'||sup_uoo_id uoo_info
1264: -- Gives all required uoo information
1265: FROM igs_ps_unit_ofr_opt
1266: WHERE unit_cd = cp_unit_cd AND version_number = cp_unit_ver
1267: AND cal_type = cp_cal_type AND ci_sequence_number = cp_ci_sequence_number
1268: AND location_cd = cp_location_cd AND unit_class = cp_unit_class;
1269:

Line 1340: FROM igs_ps_unit_ofr_opt

1336:
1337:
1338: CURSOR c_get_unit_cd (cp_uoo_id NUMBER) IS
1339: SELECT unit_cd
1340: FROM igs_ps_unit_ofr_opt
1341: WHERE uoo_id=cp_uoo_id;
1342:
1343:
1344: l_uoo_ids_list VARCHAR2(2000);