APPS.IGF_AW_GEN_002 dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 1255: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,

1251:
1252:
1253: --Procedure for Comparing ISIR Applications
1254: PROCEDURE compare_isirs(
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

Line 1256: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,

1252:
1253: --Procedure for Comparing ISIR Applications
1254: PROCEDURE compare_isirs(
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

Line 1277: CURSOR c_get_org_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

1273: brajendr 28-Nov-2002 Modified the parameters. Removed the Row Type and changed to ISIR ID
1274: ***************************************************************/
1275:
1276: -- Get ISIR details
1277: CURSOR c_get_org_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
1278: SELECT *
1279: FROM igf_ap_isir_matched
1280: WHERE isir_id = cp_isir_id;
1281: