APPS.IGF_AW_LOCK_ASSGN_PKG dependencies on IGS_CA_INST_ALL

Line 87: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

83: WHERE party_id = c_person_id;
84:
85: l_person_no c_person_no%ROWTYPE;
86:
87: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
88: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
89: lv_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
90: ln_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
91: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 88: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

84:
85: l_person_no c_person_no%ROWTYPE;
86:
87: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
88: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
89: lv_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
90: ln_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
91: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
92: lv_err_msg fnd_new_messages.message_name%TYPE;

Line 89: lv_ld_cal_type igs_ca_inst_all.cal_type%TYPE;

85: l_person_no c_person_no%ROWTYPE;
86:
87: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
88: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
89: lv_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
90: ln_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
91: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
92: lv_err_msg fnd_new_messages.message_name%TYPE;
93: lv_return_flag VARCHAR2(1);

Line 90: ln_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;

86:
87: lv_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
88: ln_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
89: lv_ld_cal_type igs_ca_inst_all.cal_type%TYPE;
90: ln_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE;
91: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
92: lv_err_msg fnd_new_messages.message_name%TYPE;
93: lv_return_flag VARCHAR2(1);
94: