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_TODO_GRPS_PRC_PKG dependencies on IGF_LOOKUPS_VIEW

Line 121: FROM igf_lookups_view

117: AND sequence_number = cp_ci_sequence_number;
118:
119: CURSOR c_get_parameters IS
120: SELECT meaning, lookup_code
121: FROM igf_lookups_view
122: WHERE lookup_type='IGF_GE_PARAMETERS'
123: AND lookup_code IN ('AWARD_YEAR','PERSON_NUMBER','PERSON_ID_GROUP','ITEM_CODE','PARAMETER_PASS','UPDATE_TD_MODE');
124:
125: -- Get the details of Item codes and its descritpions

Line 162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;

158:
159: parameter_rec c_get_parameters%ROWTYPE;
160: lc_item_description igf_ap_td_item_mst.description%TYPE;
161: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE;
162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;
163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;
166: lv_status_pmpt igf_lookups_view.meaning%TYPE;

Line 163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;

159: parameter_rec c_get_parameters%ROWTYPE;
160: lc_item_description igf_ap_td_item_mst.description%TYPE;
161: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE;
162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;
163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;
166: lv_status_pmpt igf_lookups_view.meaning%TYPE;
167: l_para_pass igf_lookups_view.meaning%TYPE;

Line 164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;

160: lc_item_description igf_ap_td_item_mst.description%TYPE;
161: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE;
162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;
163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;
166: lv_status_pmpt igf_lookups_view.meaning%TYPE;
167: l_para_pass igf_lookups_view.meaning%TYPE;
168: l_person_number hz_parties.party_number%TYPE;

Line 165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;

161: lv_awd_alternate_code igs_ca_inst.alternate_code%TYPE;
162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;
163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;
166: lv_status_pmpt igf_lookups_view.meaning%TYPE;
167: l_para_pass igf_lookups_view.meaning%TYPE;
168: l_person_number hz_parties.party_number%TYPE;
169: l_group_desc igs_pe_persid_group_all.description%TYPE;

Line 166: lv_status_pmpt igf_lookups_view.meaning%TYPE;

162: lv_award_year_pmpt igf_lookups_view.meaning%TYPE;
163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;
166: lv_status_pmpt igf_lookups_view.meaning%TYPE;
167: l_para_pass igf_lookups_view.meaning%TYPE;
168: l_person_number hz_parties.party_number%TYPE;
169: l_group_desc igs_pe_persid_group_all.description%TYPE;
170: l_item_description igf_ap_td_item_mst_all.description%TYPE;

Line 167: l_para_pass igf_lookups_view.meaning%TYPE;

163: lv_person_number_pmpt igf_lookups_view.meaning%TYPE;
164: lv_person_id_grp_pmpt igf_lookups_view.meaning%TYPE;
165: lv_item_code_pmpt igf_lookups_view.meaning%TYPE;
166: lv_status_pmpt igf_lookups_view.meaning%TYPE;
167: l_para_pass igf_lookups_view.meaning%TYPE;
168: l_person_number hz_parties.party_number%TYPE;
169: l_group_desc igs_pe_persid_group_all.description%TYPE;
170: l_item_description igf_ap_td_item_mst_all.description%TYPE;
171: l_upd_mode_pmpt igf_lookups_view.meaning%TYPE;

Line 171: l_upd_mode_pmpt igf_lookups_view.meaning%TYPE;

167: l_para_pass igf_lookups_view.meaning%TYPE;
168: l_person_number hz_parties.party_number%TYPE;
169: l_group_desc igs_pe_persid_group_all.description%TYPE;
170: l_item_description igf_ap_td_item_mst_all.description%TYPE;
171: l_upd_mode_pmpt igf_lookups_view.meaning%TYPE;
172:
173: BEGIN
174:
175: -- Set all the Prompts for the Input Parameters

Line 761: FROM igf_lookups_view

757:
758: --- Get the Person Number prompt
759: CURSOR c_get_parameters IS
760: SELECT meaning
761: FROM igf_lookups_view
762: WHERE lookup_type='IGF_GE_PARAMETERS'
763: AND lookup_code IN ('PERSON_NUMBER');
764:
765:

Line 769: l_person_number igf_lookups_view.meaning%TYPE;

765:
766: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
767: lc_person_details_rec c_person_details%ROWTYPE;
768: ln_item_cnt NUMBER(3) := 0;
769: l_person_number igf_lookups_view.meaning%TYPE;
770:
771:
772: PROCEDURE each_student_todo(
773: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,