APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_CA_INST_ALL

Line 2923: PROCEDURE get_fk_igs_ca_inst_all (

2919:
2920: END get_fk_igs_ps_unt_crclm_all;
2921: ---------------------------------------------------------------
2922:
2923: PROCEDURE get_fk_igs_ca_inst_all (
2924: x_cal_type IN VARCHAR2,
2925: x_sequence_number IN NUMBER
2926: ) AS
2927: /*

Line 2957: END get_fk_igs_ca_inst_all;

2953: RETURN;
2954: END IF;
2955: CLOSE cur_rowid;
2956:
2957: END get_fk_igs_ca_inst_all;
2958:
2959:
2960: PROCEDURE get_fk_igs_ca_inst_all1 (
2961: x_cal_type IN VARCHAR2,

Line 2960: PROCEDURE get_fk_igs_ca_inst_all1 (

2956:
2957: END get_fk_igs_ca_inst_all;
2958:
2959:
2960: PROCEDURE get_fk_igs_ca_inst_all1 (
2961: x_cal_type IN VARCHAR2,
2962: x_sequence_number IN NUMBER
2963: ) AS
2964: /*

Line 2994: END get_fk_igs_ca_inst_all1;

2990: RETURN;
2991: END IF;
2992: CLOSE cur_rowid;
2993:
2994: END get_fk_igs_ca_inst_all1;
2995: ---------------------------------------------------------------
2996: PROCEDURE Before_DML (
2997: p_action IN VARCHAR2,
2998: x_rowid IN VARCHAR2 ,

Line 3343: Igs_ca_inst_all ci

3339: CURSOR c_occurs(cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE , cp_version_number igs_ps_unit_ver.version_number%TYPE) IS
3340: SELECT uso.unit_section_occurrence_id
3341: FROM Igs_ps_usec_occurs_all uso,
3342: Igs_ps_unit_ofr_opt_all us,
3343: Igs_ca_inst_all ci
3344: WHERE uso.uoo_id=us.uoo_id
3345: AND us.cal_type=ci.cal_type
3346: AND us.ci_sequence_number = ci.sequence_number
3347: AND TRUNC (ci.end_dt) > TRUNC (SYSDATE)

Line 3359: igs_ca_inst_all c

3355: CURSOR c_title(cp_unit_cd VARCHAR2, cp_version_number NUMBER) IS
3356: SELECT a.*,a.rowid
3357: FROM igs_ps_usec_ref a ,
3358: igs_ps_unit_ofr_opt_all b,
3359: igs_ca_inst_all c
3360: WHERE a.uoo_id= b.uoo_id
3361: AND b.unit_cd= cp_unit_cd
3362: AND b.version_number = cp_version_number
3363: AND b.cal_type=c.cal_type