APPS.IGF_DB_SF_INTEGRATION dependencies on IGF_AP_AWARD_YEAR_V

Line 132: FUNCTION validate_award_year(p_cal_type igf_ap_award_year_v.cal_type%TYPE,

128: g_v_currency igs_fi_control_all.currency_cd%TYPE := NULL;
129: g_print_msg VARCHAR2(200);
130: lv_locking_success VARCHAR2(1);
131:
132: FUNCTION validate_award_year(p_cal_type igf_ap_award_year_v.cal_type%TYPE,
133: p_sequence_number igf_ap_award_year_v.sequence_number%TYPE)
134: RETURN BOOLEAN AS
135: /***********************************************************************************************
136:

Line 133: p_sequence_number igf_ap_award_year_v.sequence_number%TYPE)

129: g_print_msg VARCHAR2(200);
130: lv_locking_success VARCHAR2(1);
131:
132: FUNCTION validate_award_year(p_cal_type igf_ap_award_year_v.cal_type%TYPE,
133: p_sequence_number igf_ap_award_year_v.sequence_number%TYPE)
134: RETURN BOOLEAN AS
135: /***********************************************************************************************
136:
137: Created By : Sarakshi

Line 148: FROM igf_ap_award_year_v

144: ********************************************************************************************** */
145:
146: CURSOR cur_val IS
147: SELECT 'X'
148: FROM igf_ap_award_year_v
149: WHERE cal_type = p_cal_type
150: AND sequence_number = p_sequence_number;
151: l_temp VARCHAR2(1);
152: BEGIN

Line 1467: l_cal_type igf_ap_award_year_v.cal_type%TYPE;

1463: l_v_status VARCHAR2(1);
1464:
1465: l_n_person_id hz_parties.party_id%TYPE;
1466: l_rec_disb cur_disb%ROWTYPE;
1467: l_cal_type igf_ap_award_year_v.cal_type%TYPE;
1468: l_sequence_number igf_ap_award_year_v.sequence_number%TYPE;
1469: l_record_count NUMBER :=0;
1470: l_ld_cal_type igf_aw_awd_ld_cal_v.ld_cal_type%TYPE;
1471: l_ld_sequence_number igf_aw_awd_ld_cal_v.ld_sequence_number%TYPE;

Line 1468: l_sequence_number igf_ap_award_year_v.sequence_number%TYPE;

1464:
1465: l_n_person_id hz_parties.party_id%TYPE;
1466: l_rec_disb cur_disb%ROWTYPE;
1467: l_cal_type igf_ap_award_year_v.cal_type%TYPE;
1468: l_sequence_number igf_ap_award_year_v.sequence_number%TYPE;
1469: l_record_count NUMBER :=0;
1470: l_ld_cal_type igf_aw_awd_ld_cal_v.ld_cal_type%TYPE;
1471: l_ld_sequence_number igf_aw_awd_ld_cal_v.ld_sequence_number%TYPE;
1472: