APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_FC_SAR_CD_MST

Line 1289: pv_column_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE, --gets the SAR Field name

1285:
1286: PROCEDURE l_validate_data ( pn_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
1287: pv_isir_id IN igf_ap_isir_matched.isir_id%TYPE,
1288: pv_item_value IN igf_ap_inst_ver_item.item_value%TYPE,
1289: pv_column_name IN igf_fc_sar_cd_mst.sar_field_name%TYPE, --gets the SAR Field name
1290: pv_isir_map_column IN igf_ap_inst_ver_item.isir_map_col%TYPE,
1291: pv_ci_cal_type IN igf_ap_fa_base_rec.ci_cal_type%TYPE,
1292: pv_ci_sequence_number IN igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
1293: pv_update_ssn IN OUT NOCOPY VARCHAR2

Line 1317: CURSOR cur_get_sar_field_desc (pv_column_name igf_fc_sar_cd_mst.sar_field_name%TYPE,

1313: ln_sequence_number igs_ca_inst.sequence_number%TYPE := pv_ci_sequence_number;
1314: lv_item_value igf_ap_inst_ver_item.item_value%TYPE;
1315: l_mode VARCHAR2(30);
1316:
1317: CURSOR cur_get_sar_field_desc (pv_column_name igf_fc_sar_cd_mst.sar_field_name%TYPE,
1318: pv_lookup_type VARCHAR2) IS
1319: SELECT lkup.meaning
1320: FROM igf_lookups_view lkup
1321: WHERE lkup.lookup_type = pv_lookup_type

Line 1325: l_column_name igf_fc_sar_cd_mst.sar_field_name%TYPE ;

1321: WHERE lkup.lookup_type = pv_lookup_type
1322: AND lkup.lookup_code = pv_column_name
1323: AND lkup.enabled_flag = 'Y' ;
1324:
1325: l_column_name igf_fc_sar_cd_mst.sar_field_name%TYPE ;
1326: l_lookup_type VARCHAR2(60) ;
1327: l_sar_col_desc igf_lookups_view.meaning%TYPE ;
1328:
1329: BEGIN

Line 1462: Igf_fc_sar_cd_mst sar

1458: ivi.incl_in_tolerance, sar.sar_field_name column_name
1459: FROM igf_ap_batch_aw_map map,
1460: igf_ap_fa_base_rec_all fabase,
1461: igf_ap_inst_ver_item ivi,
1462: Igf_fc_sar_cd_mst sar
1463: WHERE fabase.base_id = pn_base_id
1464: AND map.ci_cal_type = fabase.ci_cal_type
1465: AND map.ci_sequence_number = fabase.ci_sequence_number
1466: AND ivi.base_id = pn_base_id