APPS.IGF_AW_GEN_002 dependencies on IGF_AP_ISIR_CORR

Line 1259: p_corr_status igf_ap_isir_corr.correction_status%TYPE

1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
1257: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1258: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1259: p_corr_status igf_ap_isir_corr.correction_status%TYPE
1260: ) AS
1261:
1262: /***************************************************************
1263: Created By : mesriniv

Line 1322: FROM igf_ap_isir_corr

1318: v_seq_num NUMBER,
1319: v_sar_fld VARCHAR2
1320: ) IS
1321: SELECT row_id , isirc_id,correction_status
1322: FROM igf_ap_isir_corr
1323: WHERE isir_id = v_isir_id
1324: AND ci_cal_type = v_cal_type
1325: AND ci_sequence_number = v_seq_num
1326: AND sar_field_number = v_sar_fld ;

Line 1331: l_isirc_id igf_ap_isir_corr.isirc_id%TYPE;

1327:
1328:
1329: lc_chg_code igf_lookups_view.lookup_code%TYPE;
1330: l_rowid VARCHAR2(25);
1331: l_isirc_id igf_ap_isir_corr.isirc_id%TYPE;
1332: p_batch_id igf_ap_isir_corr.batch_id%TYPE;
1333: lv_corr_status VARCHAR2(30);
1334:
1335: l_chk_corr_exists chk_corr_exists%rowtype;

Line 1332: p_batch_id igf_ap_isir_corr.batch_id%TYPE;

1328:
1329: lc_chg_code igf_lookups_view.lookup_code%TYPE;
1330: l_rowid VARCHAR2(25);
1331: l_isirc_id igf_ap_isir_corr.isirc_id%TYPE;
1332: p_batch_id igf_ap_isir_corr.batch_id%TYPE;
1333: lv_corr_status VARCHAR2(30);
1334:
1335: l_chk_corr_exists chk_corr_exists%rowtype;
1336:

Line 1365: igf_ap_isir_corr_pkg.insert_row(

1361: CLOSE chk_corr_exists;
1362:
1363: IF l_chk_corr_exists.isirc_id IS NULL THEN
1364:
1365: igf_ap_isir_corr_pkg.insert_row(
1366: X_ROWID => l_rowid,
1367: X_ISIRC_ID => l_isirc_id,
1368: X_ISIR_ID => p_isir_pay.isir_id,
1369: X_CI_SEQUENCE_NUMBER => p_seq_num,

Line 1386: igf_ap_isir_corr_pkg.update_row(

1382: lv_corr_status := 'HOLD' ;
1383: ELSE
1384: lv_corr_status := p_corr_status ;
1385: END IF;
1386: igf_ap_isir_corr_pkg.update_row(
1387: X_ROWID => l_rowid,
1388: X_ISIRC_ID => l_chk_corr_exists.isirc_id,
1389: X_ISIR_ID => p_isir_pay.isir_id,
1390: X_CI_SEQUENCE_NUMBER => p_seq_num,