[Home] [Help]
34: ) RETURN VARCHAR2;
35:
36: FUNCTION chk_pell_orig (
37: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
38: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
39: ) RETURN VARCHAR2;
40:
41: FUNCTION make_awarding_isir (
42: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
39: ) RETURN VARCHAR2;
40:
41: FUNCTION make_awarding_isir (
42: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
43: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
44: ) RETURN VARCHAR2;
45:
46:
47: FUNCTION are_corrections_exists (
53: ) RETURN VARCHAR2;
54:
55: PROCEDURE delete_isir_validations (
56: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
57: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2,
60: x_return_status OUT NOCOPY VARCHAR2
61: );
61: );
62:
63: PROCEDURE delete_isir (
64: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
65: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: x_return_status OUT NOCOPY VARCHAR2
69: );
86: p_status OUT NOCOPY VARCHAR2
87: );
88:
89: FUNCTION get_isir_message_class (
90: p_message_class IN igf_ap_isir_matched_all.message_class_txt%TYPE
91: ) RETURN VARCHAR2;
92:
93: PROCEDURE upd_ant_data_awd_prc_status(
94: p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
90: p_message_class IN igf_ap_isir_matched_all.message_class_txt%TYPE
91: ) RETURN VARCHAR2;
92:
93: PROCEDURE upd_ant_data_awd_prc_status(
94: p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
95: p_new_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
96: p_upd_ant_val IN VARCHAR2,
97: p_anticip_status OUT NOCOPY VARCHAR2,
98: p_awd_prc_status OUT NOCOPY VARCHAR2
91: ) RETURN VARCHAR2;
92:
93: PROCEDURE upd_ant_data_awd_prc_status(
94: p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
95: p_new_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
96: p_upd_ant_val IN VARCHAR2,
97: p_anticip_status OUT NOCOPY VARCHAR2,
98: p_awd_prc_status OUT NOCOPY VARCHAR2
99: );