DBA Data[Home] [Help]

APPS.IGF_AW_GEN_002 dependencies on IGF_AP_FA_BASE_REC

Line 48: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

44:
45: PROCEDURE compare_isirs(
46: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
47: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
48: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
49: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
50: p_corr_status igf_ap_isir_corr.correction_status%TYPE DEFAULT NULL
51: );
52:

Line 49: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

45: PROCEDURE compare_isirs(
46: p_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
47: p_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE,
48: p_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
49: p_seq_num igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
50: p_corr_status igf_ap_isir_corr.correction_status%TYPE DEFAULT NULL
51: );
52:
53:

Line 67: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,

63: || (reverse chronological order - newest change first)
64: */
65: PROCEDURE get_resource_need
66: (
67: p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
68: p_resource_f OUT NOCOPY NUMBER,
69: p_resource_i OUT NOCOPY NUMBER,
70: p_unmet_need_f OUT NOCOPY NUMBER,
71: p_unmet_need_i OUT NOCOPY NUMBER,