APPS.IGF_AP_LG_VER_IMP dependencies on IGF_AP_INST_VER_ITEM_ALL

Line 133: PROCEDURE check_dup_ver ( p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE,

129:
130: END print_log_process;
131:
132:
133: PROCEDURE check_dup_ver ( p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE,
134: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
135: p_dup_ver OUT NOCOPY BOOLEAN ) IS
136: /*
137: || Created By : masehgal

Line 147: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS

143: || (reverse chronological order - newest change first)
144: */
145:
146: CURSOR chk_dup ( cp_base_id igf_ap_isir_matched.base_id%TYPE,
147: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
148: SELECT 1
149: FROM igf_ap_inst_ver_item_all
150: WHERE base_id = cp_base_id
151: AND isir_map_col = cp_sar_num ;

Line 149: FROM igf_ap_inst_ver_item_all

145:
146: CURSOR chk_dup ( cp_base_id igf_ap_isir_matched.base_id%TYPE,
147: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
148: SELECT 1
149: FROM igf_ap_inst_ver_item_all
150: WHERE base_id = cp_base_id
151: AND isir_map_col = cp_sar_num ;
152: l_count NUMBER ;
153:

Line 177: PROCEDURE chk_corr_items (p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE,

173:
174: END check_dup_ver ;
175:
176:
177: PROCEDURE chk_corr_items (p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE,
178: p_pay_isir_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
179: p_corr_exist OUT NOCOPY BOOLEAN ) IS
180: /*
181: || Created By : masehgal

Line 221: p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS

217: END chk_corr_items ;
218:
219:
220: PROCEDURE delete_ver_items ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
221: p_sar_num IN igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
222: /*
223: || Created By : masehgal
224: || Created On : 28-May-2003
225: || Purpose : deletion of Ver Items

Line 233: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS

229: || (reverse chronological order - newest change first)
230: */
231:
232: CURSOR del_ver_items( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
233: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
234: SELECT rowid
235: FROM igf_ap_inst_ver_item_all
236: WHERE base_id = cp_base_id
237: AND isir_map_col = cp_sar_num ;

Line 235: FROM igf_ap_inst_ver_item_all

231:
232: CURSOR del_ver_items( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
233: cp_sar_num igf_ap_inst_ver_item_all.isir_map_col%TYPE ) IS
234: SELECT rowid
235: FROM igf_ap_inst_ver_item_all
236: WHERE base_id = cp_base_id
237: AND isir_map_col = cp_sar_num ;
238: lv_rowid del_ver_items%ROWTYPE;
239: