APPS.IGF_SP_CREATE_BASE_REC dependencies on IGS_CA_INST

Line 112: l_cal_type igs_ca_inst.cal_type%TYPE;

108: -- instead of igs_pe_prsid_grp_mem_v. This fix is done to remove
109: -- Non-mergable view exists in the select and to reduce shared memory
110: -- within the acceptable limit
111: -------------------------------------------------------------------------------------
112: l_cal_type igs_ca_inst.cal_type%TYPE;
113: l_sequence_number igs_ca_inst.sequence_number%TYPE;
114: l_message VARCHAR2(4000);
115: l_status BOOLEAN;
116: l_base_id igf_ap_fa_base_rec.base_id%TYPE;

Line 113: l_sequence_number igs_ca_inst.sequence_number%TYPE;

109: -- Non-mergable view exists in the select and to reduce shared memory
110: -- within the acceptable limit
111: -------------------------------------------------------------------------------------
112: l_cal_type igs_ca_inst.cal_type%TYPE;
113: l_sequence_number igs_ca_inst.sequence_number%TYPE;
114: l_message VARCHAR2(4000);
115: l_status BOOLEAN;
116: l_base_id igf_ap_fa_base_rec.base_id%TYPE;
117: l_count NUMBER(1) := 0;

Line 352: (p_cal_type IN igs_ca_inst.cal_type%TYPE,

348: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
349: END create_base_record;
350:
351: FUNCTION create_fa_base_record
352: (p_cal_type IN igs_ca_inst.cal_type%TYPE,
353: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
354: p_person_id IN igs_pe_person.person_id%TYPE,
355: p_base_id OUT NOCOPY igf_ap_fa_base_rec.base_id%TYPE,
356: p_message OUT NOCOPY VARCHAR2)

Line 353: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,

349: END create_base_record;
350:
351: FUNCTION create_fa_base_record
352: (p_cal_type IN igs_ca_inst.cal_type%TYPE,
353: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
354: p_person_id IN igs_pe_person.person_id%TYPE,
355: p_base_id OUT NOCOPY igf_ap_fa_base_rec.base_id%TYPE,
356: p_message OUT NOCOPY VARCHAR2)
357: RETURN BOOLEAN

Line 398: cp_cal_type igs_ca_inst.cal_type%TYPE,

394: /*
395: cursor to see whether the FA records for the passsed in person id exists or not
396: */
397: CURSOR c_exists (cp_person_id igs_pe_person.person_id%TYPE,
398: cp_cal_type igs_ca_inst.cal_type%TYPE,
399: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
400: SELECT base_id
401: FROM igf_ap_fa_base_rec
402: WHERE person_id = cp_person_id

Line 399: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS

395: cursor to see whether the FA records for the passsed in person id exists or not
396: */
397: CURSOR c_exists (cp_person_id igs_pe_person.person_id%TYPE,
398: cp_cal_type igs_ca_inst.cal_type%TYPE,
399: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
400: SELECT base_id
401: FROM igf_ap_fa_base_rec
402: WHERE person_id = cp_person_id
403: AND ci_cal_type = cp_cal_type