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_LOOKUPS_VIEW

Line 48: FROM igf_lookups_view

44: AND sequence_number = cp_ci_sequence_number ;
45:
46: CURSOR c_get_parameters ( cp_lkup_type VARCHAR2 ) IS
47: SELECT meaning, lookup_code
48: FROM igf_lookups_view
49: WHERE lookup_type = cp_lkup_type
50: AND lookup_code IN ('AWARD_YEAR','PERSON_NUMBER','PERSON_ID_GROUP','ITEM_CODE',
51: 'PARAMETER_PASS','ISIR_FIELD') ;
52: l_lkup_type VARCHAR2(60) ;

Line 68: igf_lookups_view lkup

64: cp_lkup_type VARCHAR2 ) IS
65: SELECT lkup.meaning meaning
66: FROM igf_ap_batch_aw_map map,
67: Igf_fc_sar_cd_mst sar ,
68: igf_lookups_view lkup
69: WHERE map.ci_cal_type = cp_ci_cal_type
70: AND map.ci_sequence_number = cp_ci_sequence_number
71: AND sar.sys_award_year = map.sys_award_year
72: AND sar.sar_field_name = cp_isir_field

Line 102: lv_isir_field igf_lookups_view.meaning%TYPE ;

98: parameter_rec c_get_parameters%ROWTYPE ;
99: verif_item_pmpt_rec c_get_verif_item%ROWTYPE ;
100: lc_item_description igf_ap_td_item_mst.description%TYPE ;
101: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE ;
102: lv_isir_field igf_lookups_view.meaning%TYPE ;
103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;
104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;

Line 103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;

99: verif_item_pmpt_rec c_get_verif_item%ROWTYPE ;
100: lc_item_description igf_ap_td_item_mst.description%TYPE ;
101: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE ;
102: lv_isir_field igf_lookups_view.meaning%TYPE ;
103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;
104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;

Line 105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;

101: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE ;
102: lv_isir_field igf_lookups_view.meaning%TYPE ;
103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;
104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;
108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;

Line 106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;

102: lv_isir_field igf_lookups_view.meaning%TYPE ;
103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;
104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;
108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;

Line 107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;

103: lv_incl_in_tol igf_lookups_view.meaning%TYPE ;
104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;
108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:

Line 108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;

104:
105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;
108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:
112: l_person_number igs_pe_person_base_v.person_number%TYPE;

Line 109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;

105: lv_award_year_pmpt igf_lookups_view.meaning%TYPE ;
106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;
108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:
112: l_person_number igs_pe_person_base_v.person_number%TYPE;
113: l_group_desc igs_pe_persid_group_all.description%TYPE;

Line 110: l_para_pass igf_lookups_view.meaning%TYPE ;

106: lv_person_number_pmpt igf_lookups_view.meaning%TYPE ;
107: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE ;
108: lv_item_code_pmpt igf_lookups_view.meaning%TYPE ;
109: lv_isir_field_pmpt igf_lookups_view.meaning%TYPE ;
110: l_para_pass igf_lookups_view.meaning%TYPE ;
111:
112: l_person_number igs_pe_person_base_v.person_number%TYPE;
113: l_group_desc igs_pe_persid_group_all.description%TYPE;
114: l_item_description igf_ap_td_item_mst_all.description%TYPE;

Line 407: lv_meaning igf_lookups_view.meaning%TYPE;

403: || (reverse chronological order - newest change first)
404: */
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

Line 416: igf_lookups_view lkup

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
419: AND map.ci_sequence_number = fabase.ci_sequence_number
420: AND sar.sys_award_year = map.sys_award_year

Line 603: FROM igf_lookups_view

599: --- Get the Person Number prompt
600: CURSOR c_get_parameters ( cp_lkup_type VARCHAR2 ,
601: cp_lkup_code VARCHAR2 ) IS
602: SELECT meaning
603: FROM igf_lookups_view
604: WHERE lookup_type = cp_lkup_type
605: AND lookup_code = cp_lkup_code ;
606: l_lkup_type VARCHAR2(30) ;
607: l_lkup_code VARCHAR2(30) ;

Line 615: l_person_number igf_lookups_view.meaning%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:
618:
619: BEGIN