eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_LG_COA_IMP dependencies on IGS_CA_INST

Line 16: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,

12: g_log_tab LogTab;
13:
14:
15: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
16: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
17: p_delete_flag IN VARCHAR2 ) IS
18: /*
19: || Created By : masehgal
20: || Created On : 28-May-2003

Line 297: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

293:
294:
295:
296: PROCEDURE check_dup_coa_term ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
297: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
298: p_ld_seq_num IN igs_ca_inst.sequence_number%TYPE,
299: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
300: p_dup_term OUT NOCOPY BOOLEAN ) IS
301: /*

Line 298: p_ld_seq_num IN igs_ca_inst.sequence_number%TYPE,

294:
295:
296: PROCEDURE check_dup_coa_term ( p_item_code IN igf_aw_coa_itm_terms.item_code%TYPE,
297: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
298: p_ld_seq_num IN igs_ca_inst.sequence_number%TYPE,
299: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
300: p_dup_term OUT NOCOPY BOOLEAN ) IS
301: /*
302: || Created By : masehgal

Line 313: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

309: */
310:
311: CURSOR chk_dup_term ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
312: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
313: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
314: cp_ld_seq_num igs_ca_inst.sequence_number%TYPE) IS
315: SELECT 1
316: FROM igf_aw_coa_itm_terms
317: WHERE base_id = cp_base_id

Line 314: cp_ld_seq_num igs_ca_inst.sequence_number%TYPE) IS

310:
311: CURSOR chk_dup_term ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
312: cp_item_code igf_aw_coa_itm_terms.item_code%TYPE,
313: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
314: cp_ld_seq_num igs_ca_inst.sequence_number%TYPE) IS
315: SELECT 1
316: FROM igf_aw_coa_itm_terms
317: WHERE base_id = cp_base_id
318: AND item_code = cp_item_code

Line 442: l_alternate_code igs_ca_inst.alternate_code%TYPE ;

438: g_skip_record BOOLEAN := FALSE ;
439: g_skip_item_insert BOOLEAN := FALSE ;
440: g_award_year_status igf_ap_batch_aw_map.award_year_status_code%TYPE ;
441: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
442: l_alternate_code igs_ca_inst.alternate_code%TYPE ;
443: l_rec_processed NUMBER;
444: l_rec_imported NUMBER;
445: l_rec_error NUMBER;
446: l_last_person_number igf_aw_li_coa_ints.person_number%TYPE ;

Line 506: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,

502:
503: person_rec c_get_persons%ROWTYPE ;
504:
505: -- cursor to get alternate code for award year
506: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
507: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
508: SELECT alternate_code
509: FROM igs_ca_inst
510: WHERE cal_type = cp_ci_cal_type

Line 507: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS

503: person_rec c_get_persons%ROWTYPE ;
504:
505: -- cursor to get alternate code for award year
506: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
507: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
508: SELECT alternate_code
509: FROM igs_ca_inst
510: WHERE cal_type = cp_ci_cal_type
511: AND sequence_number = cp_ci_sequence_number ;

Line 509: FROM igs_ca_inst

505: -- cursor to get alternate code for award year
506: CURSOR c_alternate_code( cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,
507: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE ) IS
508: SELECT alternate_code
509: FROM igs_ca_inst
510: WHERE cal_type = cp_ci_cal_type
511: AND sequence_number = cp_ci_sequence_number ;
512:
513: -- check COA Setup done

Line 530: CURSOR cur_get_cal_info ( cp_alternate_code igs_ca_inst.alternate_code%TYPE ) IS

526: WHERE base_id = cp_base_id
527: AND item_code = cp_item_code ;
528: l_item_rec cur_get_items%ROWTYPE ;
529:
530: CURSOR cur_get_cal_info ( cp_alternate_code igs_ca_inst.alternate_code%TYPE ) IS
531: SELECT cal_type, sequence_number
532: FROM igs_ca_inst
533: WHERE alternate_code = cp_alternate_code ;
534:

Line 532: FROM igs_ca_inst

528: l_item_rec cur_get_items%ROWTYPE ;
529:
530: CURSOR cur_get_cal_info ( cp_alternate_code igs_ca_inst.alternate_code%TYPE ) IS
531: SELECT cal_type, sequence_number
532: FROM igs_ca_inst
533: WHERE alternate_code = cp_alternate_code ;
534:
535: l_load_cal_type igs_ca_inst.cal_type%TYPE ;
536: l_load_seq_num igs_ca_inst.sequence_number%TYPE ;

Line 535: l_load_cal_type igs_ca_inst.cal_type%TYPE ;

531: SELECT cal_type, sequence_number
532: FROM igs_ca_inst
533: WHERE alternate_code = cp_alternate_code ;
534:
535: l_load_cal_type igs_ca_inst.cal_type%TYPE ;
536: l_load_seq_num igs_ca_inst.sequence_number%TYPE ;
537:
538: l_old_item igf_aw_coa_items.item_code%TYPE;
539:

Line 536: l_load_seq_num igs_ca_inst.sequence_number%TYPE ;

532: FROM igs_ca_inst
533: WHERE alternate_code = cp_alternate_code ;
534:
535: l_load_cal_type igs_ca_inst.cal_type%TYPE ;
536: l_load_seq_num igs_ca_inst.sequence_number%TYPE ;
537:
538: l_old_item igf_aw_coa_items.item_code%TYPE;
539:
540: BEGIN