APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGF_AP_ISIR_MATCHED

Line 2037: igf_ap_isir_matched_pkg.update_row(

2033:
2034: BEGIN
2035:
2036:
2037: igf_ap_isir_matched_pkg.update_row(
2038: x_Mode => 'R',
2039: x_rowid => p_rowid,
2040: x_isir_id => p_isir_id,
2041: x_base_id => p_base_id,

Line 2363: igf_ap_isir_matched_pkg.insert_row(

2359:
2360: BEGIN
2361: l_rowid:= NULL;
2362: l_isir_id := NULL;
2363: igf_ap_isir_matched_pkg.insert_row(
2364: x_Mode => 'R',
2365: x_rowid => l_rowid,
2366: x_isir_id => l_isir_id,
2367: x_base_id => p_base_id,

Line 5914: igf_ap_isir_matched im

5910: IS
5911: SELECT
5912: im.transaction_num
5913: FROM
5914: igf_ap_isir_matched im
5915: WHERE
5916: im.base_id =p_base_id and
5917: im.transaction_num = p_transaction_num and
5918: rownum = 1 ;

Line 5946: FROM igf_ap_isir_matched

5942: CURSOR c_get_rowid(p_base_id NUMBER,
5943: p_transn_num VARCHAR2)
5944: IS
5945: SELECT rowid,isir_id
5946: FROM igf_ap_isir_matched
5947: WHERE transaction_num=p_transn_num
5948: AND base_id=p_base_id
5949: AND system_record_type='ORIGINAL';
5950:

Line 5997: isir_rec IGF_AP_ISIR_MATCHED%ROWTYPE;

5993:
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);