APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGF_AP_FA_BASE_REC

Line 1859: || igf_ap_fa_base_rec_pkg.insert_row

1855: || cursor SSN_CUR.
1856: || rajagupt 06-Oct-2005 Bug#4068548 - added a new cursor ssn_cur
1857: || rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
1858: || added new parameter award_fmly_contribution_type to
1859: || igf_ap_fa_base_rec_pkg.insert_row
1860: */
1861: -- cursor to get the ssn no of a person
1862: CURSOR ssn_cur(cp_person_id number) IS
1863: SELECT api_person_id,api_person_id_uf, end_dt

Line 1899: igf_ap_fa_base_rec_pkg.insert_row(

1895: END IF;
1896:
1897: END IF;
1898:
1899: igf_ap_fa_base_rec_pkg.insert_row(
1900: x_Mode => 'R',
1901: x_rowid => l_rowid,
1902: x_base_id => l_base_id,
1903: x_ci_cal_type => p_ci_cal_type,

Line 5892: CURSOR c_igf_ap_fa_base_rec(p_person_id NUMBER,

5888: WHERE
5889: CI_CAL_TYPE = p_ci_cal_type
5890: AND CI_SEQUENCE_NUMBER = p_ci_sequence_number;
5891:
5892: CURSOR c_igf_ap_fa_base_rec(p_person_id NUMBER,
5893: p_ci_cal_type VARCHAR2,
5894: p_sequence_number VARCHAR2
5895: )
5896: IS

Line 5900: igf_ap_fa_base_rec fa

5896: IS
5897: SELECT
5898: base_id
5899: FROM
5900: igf_ap_fa_base_rec fa
5901: WHERE
5902: fa.ci_cal_type =p_ci_cal_type
5903: AND fa.ci_sequence_number = p_sequence_number
5904: AND fa.person_id = p_person_id;

Line 5998: c_igf_ap_fa_base_rec_rec c_igf_ap_fa_base_rec%ROWTYPE;

5994: oss_country_code VARCHAR2(5):='US';
5995: igs_ps_participate_fa_prog VARCHAR2(25):='Y';
5996: c_award_det_rec c_award_det%ROWTYPE;
5997: isir_rec IGF_AP_ISIR_MATCHED%ROWTYPE;
5998: c_igf_ap_fa_base_rec_rec c_igf_ap_fa_base_rec%ROWTYPE;
5999: c_transaction_num_rec c_transaction_num%ROWTYPE;
6000: b_batch_year_found BOOLEAN :=FALSE;
6001: l_ci_cal_type VARCHAR2(10);
6002: l_ci_sequence_number NUMBER;

Line 6026: lv_fa_base_id c_igf_ap_fa_base_rec_rec.base_id%TYPE;

6022: lv_person_number c_int_data_rec.person_number%TYPE;
6023: lv_ci_cal_type VARCHAR2(10);
6024: lv_ci_sequence_number NUMBER;
6025: lv_person_id NUMBER;
6026: lv_fa_base_id c_igf_ap_fa_base_rec_rec.base_id%TYPE;
6027:
6028: l_ret_profile VARCHAR2(2);
6029: l_updated VARCHAR2(1):='N';
6030: l_num_recrd_passed NUMBER:=0;