APPS.IGF_AW_LOCK_ASSGN_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

Line 16: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

12: retcode OUT NOCOPY NUMBER,
13: p_award_year IN VARCHAR2,
14: p_run_type IN VARCHAR2,
15: p_pid_group IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
16: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
17: p_run_mode IN VARCHAR2,
18: p_item_code IN igf_aw_item.item_code%TYPE,
19: p_term IN VARCHAR2
20: ) IS

Line 46: person_id igf_ap_fa_base_rec_all.person_id%TYPE,

42: TYPE CpregrpCurTyp IS REF CURSOR ;
43: cur_per_grp CpregrpCurTyp ;
44:
45: TYPE CpergrpTyp IS RECORD(
46: person_id igf_ap_fa_base_rec_all.person_id%TYPE,
47: person_number igs_pe_person_base_v.person_number%TYPE
48: );
49: per_grp_rec CpergrpTyp ;
50:

Line 54: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

50:
51:
52: --Cursor below retrieves all the students belonging to a given AWARD YEAR
53: CURSOR c_per_awd_yr(
54: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
55: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
56: ) IS
57: SELECT fa.base_id
58: FROM igf_ap_fa_base_rec_all fa

Line 55: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

51:
52: --Cursor below retrieves all the students belonging to a given AWARD YEAR
53: CURSOR c_per_awd_yr(
54: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
55: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
56: ) IS
57: SELECT fa.base_id
58: FROM igf_ap_fa_base_rec_all fa
59: WHERE fa.ci_cal_type = c_ci_cal_type

Line 58: FROM igf_ap_fa_base_rec_all fa

54: c_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
55: c_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
56: ) IS
57: SELECT fa.base_id
58: FROM igf_ap_fa_base_rec_all fa
59: WHERE fa.ci_cal_type = c_ci_cal_type
60: AND fa.ci_sequence_number = c_ci_sequence_number
61: ORDER BY fa.base_id;
62:

Line 91: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

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:
95: