APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_INST_VER_ITEM

Line 1165: FROM igf_ap_inst_ver_item ivi

1161: */
1162:
1163: CURSOR cur_get_ver_data (pn_base_id NUMBER) IS
1164: SELECT COUNT(ivi.isir_map_col)
1165: FROM igf_ap_inst_ver_item ivi
1166: WHERE ivi.base_id = pn_base_id
1167: AND ivi.waive_flag <> 'Y'
1168: AND ( ivi.item_value IS NULL AND NVL(USE_BLANK_FLAG,'N') <> 'Y' )
1169: AND rownum = 1;

Line 1209: pv_isir_map_column igf_ap_inst_ver_item.isir_map_col%TYPE,

1205:
1206: PROCEDURE l_create_corr_record(
1207: pn_base_id igf_ap_fa_base_rec.base_id%TYPE ,
1208: pn_isir_id igf_ap_isir_matched.isir_id%TYPE ,
1209: pv_isir_map_column igf_ap_inst_ver_item.isir_map_col%TYPE,
1210: pv_cal_type igs_ca_inst.cal_type%TYPE,
1211: pn_sequence_number igs_ca_inst.sequence_number%TYPE,
1212: pv_retval VARCHAR2,
1213: pv_item_value igf_ap_inst_ver_item.item_value%TYPE,

Line 1213: pv_item_value igf_ap_inst_ver_item.item_value%TYPE,

1209: pv_isir_map_column igf_ap_inst_ver_item.isir_map_col%TYPE,
1210: pv_cal_type igs_ca_inst.cal_type%TYPE,
1211: pn_sequence_number igs_ca_inst.sequence_number%TYPE,
1212: pv_retval VARCHAR2,
1213: pv_item_value igf_ap_inst_ver_item.item_value%TYPE,
1214: pv_mode VARCHAR2
1215: ) IS
1216:
1217: lv_rowid VARCHAR2(30);

Line 1288: pv_item_value IN igf_ap_inst_ver_item.item_value%TYPE,

1284:
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 ,

Line 1290: pv_isir_map_column IN igf_ap_inst_ver_item.isir_map_col%TYPE,

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
1294: ) IS

Line 1314: lv_item_value igf_ap_inst_ver_item.item_value%TYPE;

1310: lv_rows integer;
1311: ln_isir_id igf_ap_isir_matched.isir_id%TYPE := pv_isir_id;
1312: lv_cal_type igs_ca_inst.cal_type%TYPE := pv_ci_cal_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

Line 1461: igf_ap_inst_ver_item ivi,

1457: SELECT ivi.base_id, ivi.udf_vern_item_seq_num, ivi.item_value, ivi.isir_map_col,
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

Line 1478: FROM igf_ap_inst_ver_item ivi

1474: CURSOR cur_get_ver_item_count(
1475: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1476: ) IS
1477: SELECT ivi.base_id
1478: FROM igf_ap_inst_ver_item ivi
1479: WHERE ivi.base_id = cp_base_id
1480: AND ivi.waive_flag <> 'Y'
1481: AND ( (ivi.item_value IS NOT NULL) OR
1482: (ivi.item_value IS NULL AND NVL(USE_BLANK_FLAG,'N') = 'Y' )