279: -- sjadhav
280: -- routine to add coa items in students coa table
281: --
282:
283: PROCEDURE insert_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
284: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
285: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
286: p_result OUT NOCOPY VARCHAR2
287: );
293: -- sjadhav
294: -- routine to delete coa items-terms from students coa table
295: --
296:
297: PROCEDURE delete_stu_coa_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
298: p_ld_cal_type IN igf_aw_coa_ld_all.ld_cal_type%TYPE,
299: p_ld_sequence_number IN igf_aw_coa_ld_all.ld_sequence_number%TYPE,
300: p_result OUT NOCOPY VARCHAR2
301: );
306: -- sjadhav
307: -- routine to delete coa items from students coa table
308: --
309:
310: PROCEDURE delete_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
311: p_result OUT NOCOPY VARCHAR2,
312: p_item_code IN igf_aw_coa_items.item_code%TYPE DEFAULT NULL
313: );
314:
318: -- sjadhav
319: -- routine to update coa items-amount in students coa table
320: --
321:
322: PROCEDURE update_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
323: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE DEFAULT NULL,
324: p_result OUT NOCOPY VARCHAR2
325: );
326:
319: -- routine to update coa items-amount in students coa table
320: --
321:
322: PROCEDURE update_stu_coa_items( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
323: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE DEFAULT NULL,
324: p_result OUT NOCOPY VARCHAR2
325: );
326:
327:
332: -- routine to get pell att code from attend map form
333: --
334:
335:
336: PROCEDURE insert_existing_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
337: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
338: p_result OUT NOCOPY VARCHAR2
339: );
340:
333: --
334:
335:
336: PROCEDURE insert_existing_terms( p_base_id IN igf_aw_coa_itm_terms.base_id%TYPE,
337: p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
338: p_result OUT NOCOPY VARCHAR2
339: );
340:
341: