DBA Data[Home] [Help]

APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGS_CA_INST

Line 1210: pv_cal_type igs_ca_inst.cal_type%TYPE,

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,
1214: pv_mode VARCHAR2

Line 1211: pn_sequence_number igs_ca_inst.sequence_number%TYPE,

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,
1214: pv_mode VARCHAR2
1215: ) IS

Line 1312: lv_cal_type igs_ca_inst.cal_type%TYPE := pv_ci_cal_type;

1308: lv_retval igf_ap_isir_corr.original_value%TYPE;
1309: lv_stmt VARCHAR2(2000);
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:

Line 1313: ln_sequence_number igs_ca_inst.sequence_number%TYPE := pv_ci_sequence_number;

1309: lv_stmt VARCHAR2(2000);
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,

Line 1507: lv_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1503: lv_get_sys_year c_get_sys_year%ROWTYPE;
1504:
1505: rec_selected cur_selected_rec%ROWTYPE ;
1506: rec_get_ver_data cur_get_ver_data%ROWTYPE ;
1507: lv_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1508: lv_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1509: lv_ver_status VARCHAR2(30);
1510: ln_tot_count NUMBER(15);
1511: lv_efc_isir_rec igf_ap_isir_matched%ROWTYPE;

Line 1508: lv_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1504:
1505: rec_selected cur_selected_rec%ROWTYPE ;
1506: rec_get_ver_data cur_get_ver_data%ROWTYPE ;
1507: lv_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1508: lv_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1509: lv_ver_status VARCHAR2(30);
1510: ln_tot_count NUMBER(15);
1511: lv_efc_isir_rec igf_ap_isir_matched%ROWTYPE;
1512: p_efc_ret_status VARCHAR2(30);