[Home] [Help]
176: -- ovrd_coa_exist will check if there are any overridden coa items
177: -- for a coa group
178: --
179:
180: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
181: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
182: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
183: p_exist OUT NOCOPY VARCHAR2
184: );
177: -- for a coa group
178: --
179:
180: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
181: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
182: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
183: p_exist OUT NOCOPY VARCHAR2
184: );
185: --
178: --
179:
180: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
181: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
182: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
183: p_exist OUT NOCOPY VARCHAR2
184: );
185: --
186: -- Bug 2613546,2606001
190: -- delete coa group childs
191: --
192:
193: PROCEDURE delete_coa( p_record IN VARCHAR2,
194: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
195: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
196: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
197: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE DEFAULT NULL
198: );
191: --
192:
193: PROCEDURE delete_coa( p_record IN VARCHAR2,
194: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
195: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
196: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
197: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE DEFAULT NULL
198: );
199: --
192:
193: PROCEDURE delete_coa( p_record IN VARCHAR2,
194: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
195: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
196: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
197: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE DEFAULT NULL
198: );
199: --
200: -- Bug 2613546,2606001
247: -- routine to add coa items in overide table with default
248: -- term %
249: --
250:
251: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
252: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
253: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
254: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,
255: p_count OUT NOCOPY NUMBER
248: -- term %
249: --
250:
251: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
252: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
253: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
254: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,
255: p_count OUT NOCOPY NUMBER
256: );
249: --
250:
251: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
252: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
253: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
254: p_item_code IN igf_aw_coa_grp_item_all.item_code%TYPE,
255: p_count OUT NOCOPY NUMBER
256: );
257:
263: -- routine to add coa items in overide table with 0
264: -- term % once a new term is added
265: --
266:
267: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
268: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
269: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
270: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
271: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
264: -- term % once a new term is added
265: --
266:
267: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
268: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
269: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
270: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
271: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
272: );
265: --
266:
267: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,
268: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,
269: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,
270: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
271: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE
272: );
273: