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_VER_GRPS_PRC_PKG dependencies on IGF_AP_FA_BASE_REC

Line 8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,

4: lb_return_value BOOLEAN := FALSE;
5:
6: PROCEDURE log_input_params( p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
7: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 78: CURSOR c_person_number( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ) IS

74: AND lkup.lookup_code = sar.sar_field_name
75: AND lkup.enabled_flag = 'Y' ;
76:
77: -- Get the person_number
78: CURSOR c_person_number( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ) IS
79: SELECT pe.person_number
80: FROM igs_pe_person_base_v pe,
81: igf_ap_fa_base_rec_all fa
82: WHERE pe.person_id = fa.person_id

Line 81: igf_ap_fa_base_rec_all fa

77: -- Get the person_number
78: CURSOR c_person_number( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ) IS
79: SELECT pe.person_number
80: FROM igs_pe_person_base_v pe,
81: igf_ap_fa_base_rec_all fa
82: WHERE pe.person_id = fa.person_id
83: AND fa.base_id = cp_base_id;
84:
85: -- Get the details of group

Line 320: FUNCTION dup_ver_item ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,

316: NULL;
317: END log_input_params ;
318:
319:
320: FUNCTION dup_ver_item ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
321: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE
322: ) RETURN BOOLEAN AS
323:
324: /*

Line 370: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,

366:
367:
368:
369: FUNCTION add_ver_item(
370: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 409: CURSOR cur_isir_desc (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,

405:
406: lv_rowid ROWID := NULL ;
407: lv_meaning igf_lookups_view.meaning%TYPE;
408: l_isir_map_col igf_fc_sar_cd_mst.sar_field_number%TYPE;
409: CURSOR cur_isir_desc (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
410: lv_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
411: cp_lkup_type VARCHAR2 ) IS
412: SELECT sar.sar_field_number isir_map_col, lkup.meaning meaning
413: FROM igf_ap_batch_aw_map map,

Line 414: igf_ap_fa_base_rec_all fabase,

410: lv_isir_field igf_ap_inst_ver_item.isir_map_col%TYPE,
411: cp_lkup_type VARCHAR2 ) IS
412: SELECT sar.sar_field_number isir_map_col, lkup.meaning meaning
413: FROM igf_ap_batch_aw_map map,
414: igf_ap_fa_base_rec_all fabase,
415: Igf_fc_sar_cd_mst sar ,
416: igf_lookups_view lkup
417: WHERE fabase.base_id = p_base_id
418: AND map.ci_cal_type = fabase.ci_cal_type

Line 533: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

529: errbuf OUT NOCOPY VARCHAR2,
530: retcode OUT NOCOPY NUMBER,
531: p_awd_yr IN VARCHAR2,
532: p_prs_grp_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
533: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,
535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 580: CURSOR c_fa_base( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ,

576: full_name igs_pe_person_base_v.full_name%TYPE );
577: c_person_id_grp_rec c_person_id_grp_recTyp ;
578:
579: -- Check whether the sudent exists in the FA system or not.
580: CURSOR c_fa_base( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ,
581: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,
582: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
583: ) IS
584: SELECT base_id

Line 581: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,

577: c_person_id_grp_rec c_person_id_grp_recTyp ;
578:
579: -- Check whether the sudent exists in the FA system or not.
580: CURSOR c_fa_base( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ,
581: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,
582: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
583: ) IS
584: SELECT base_id
585: FROM igf_ap_fa_base_rec

Line 582: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

578:
579: -- Check whether the sudent exists in the FA system or not.
580: CURSOR c_fa_base( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ,
581: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,
582: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
583: ) IS
584: SELECT base_id
585: FROM igf_ap_fa_base_rec
586: WHERE person_id = cp_person_id

Line 585: FROM igf_ap_fa_base_rec

581: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,
582: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
583: ) IS
584: SELECT base_id
585: FROM igf_ap_fa_base_rec
586: WHERE person_id = cp_person_id
587: AND ci_cal_type = cp_ci_cal_type
588: AND ci_sequence_number = cp_ci_sequence_number ;
589:

Line 592: CURSOR c_person_details( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS

588: AND ci_sequence_number = cp_ci_sequence_number ;
589:
590:
591: -- Get the person number and person name with the person id.
592: CURSOR c_person_details( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
593: SELECT pe.person_number, pe.full_name, fa.person_id
594: FROM igf_ap_fa_base_rec fa, igs_pe_person_base_v pe
595: WHERE fa.base_id = cp_base_id
596: AND fa.person_id = pe.person_id;

Line 594: FROM igf_ap_fa_base_rec fa, igs_pe_person_base_v pe

590:
591: -- Get the person number and person name with the person id.
592: CURSOR c_person_details( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
593: SELECT pe.person_number, pe.full_name, fa.person_id
594: FROM igf_ap_fa_base_rec fa, igs_pe_person_base_v pe
595: WHERE fa.base_id = cp_base_id
596: AND fa.person_id = pe.person_id;
597:
598:

Line 609: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE ;

605: AND lookup_code = cp_lkup_code ;
606: l_lkup_type VARCHAR2(30) ;
607: l_lkup_code VARCHAR2(30) ;
608:
609: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE ;
610: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
611: lc_person_details_rec c_person_details%ROWTYPE ;
612: ln_base_id_rec c_fa_base%ROWTYPE ;
613: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE ;

Line 610: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

606: l_lkup_type VARCHAR2(30) ;
607: l_lkup_code VARCHAR2(30) ;
608:
609: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE ;
610: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
611: lc_person_details_rec c_person_details%ROWTYPE ;
612: ln_base_id_rec c_fa_base%ROWTYPE ;
613: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE ;
614: ln_stdnt_count NUMBER := 0;

Line 613: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE ;

609: lv_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE ;
610: lv_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
611: lc_person_details_rec c_person_details%ROWTYPE ;
612: ln_base_id_rec c_fa_base%ROWTYPE ;
613: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE ;
614: ln_stdnt_count NUMBER := 0;
615: l_person_number igf_lookups_view.meaning%TYPE;
616: l_datatype VARCHAR2(30);
617: