APPS.IGF_AP_SS_PKG dependencies on IGF_AP_FA_BASE_REC_ALL

Line 60: igf_ap_fa_base_rec_all fabase ,

56: CURSOR cur_get_ver_data (pn_base_id number) is
57: SELECT lkup.lookup_code col_name,
58: verf.item_value col_val
59: FROM igf_ap_inst_ver_item verf ,
60: igf_ap_fa_base_rec_all fabase ,
61: igf_ap_batch_aw_map map ,
62: igf_fc_sar_cd_mst sar ,
63: igf_lookups_view lkup
64: WHERE fabase.base_id = verf.base_id

Line 1127: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

1123:
1124: PROCEDURE save_as_correction_isir(
1125: p_org_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1126: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1127: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1128: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1129: p_corr_status IN VARCHAR2 ,
1130: x_msg_count OUT NOCOPY NUMBER,
1131: x_msg_data OUT NOCOPY VARCHAR2,

Line 1128: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

1124: PROCEDURE save_as_correction_isir(
1125: p_org_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1126: p_mod_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
1127: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1128: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1129: p_corr_status IN VARCHAR2 ,
1130: x_msg_count OUT NOCOPY NUMBER,
1131: x_msg_data OUT NOCOPY VARCHAR2,
1132: x_return_status OUT NOCOPY VARCHAR2,

Line 1159: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1155: WHERE isir_id = p_isir_id;
1156:
1157: -- Get the details of
1158: CURSOR c_get_pymt_isir(
1159: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1160: ) IS
1161: SELECT isir_id
1162: FROM igf_ap_isir_matched
1163: WHERE base_id = c_base_id

Line 1169: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1165: AND payment_isir = 'Y' ;
1166:
1167: -- Get the details of
1168: CURSOR c_get_active_isir(
1169: c_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1170: ) IS
1171: SELECT *
1172: FROM igf_ap_isir_matched
1173: WHERE base_id = c_base_id

Line 1334: CURSOR cur_get_max_trans( c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

1330: FROM igf_ap_isir_matched
1331: WHERE isir_id = p_isir_id;
1332:
1333: --Cursor to get the Max Transaction Number from Prev SIMULATION ISIR Ids
1334: CURSOR cur_get_max_trans( c_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1335: SELECT NVL(MAX(NVL(transaction_num,0)),0)+1
1336: FROM igf_ap_isir_matched
1337: WHERE system_record_type='SIMULATION'
1338: AND base_id = c_base_id;

Line 1431: -- igf_ap_fa_base_rec_all fabase ,

1427: -- CURSOR cur_get_ver_data (pn_base_id number) is
1428: -- SELECT lkup.lookup_code col_name,
1429: -- verf.item_value col_val
1430: -- FROM igf_ap_inst_ver_item verf ,
1431: -- igf_ap_fa_base_rec_all fabase ,
1432: -- igf_ap_batch_aw_map map ,
1433: -- igf_fc_sar_cd_mst sar ,
1434: -- igf_lookups_view lkup
1435: -- WHERE fabase.base_id = verf.base_id