DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_AW_COA_GROUP_ALL

Line 180: PROCEDURE ovrd_coa_exist( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

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: );

Line 181: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

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: --

Line 182: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

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

Line 194: p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

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: );

Line 195: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

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: --

Line 196: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

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

Line 251: PROCEDURE insert_coa_items( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

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

Line 252: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%TYPE,

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: );

Line 253: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

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:

Line 267: PROCEDURE insert_coa_terms( p_coa_code IN igf_aw_coa_group_all.coa_code%TYPE,

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

Line 268: p_cal_type IN igf_aw_coa_group_all.ci_cal_type%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: );

Line 269: p_sequence_number IN igf_aw_coa_group_all.ci_sequence_number%TYPE,

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: