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 IGS_PE_PERSID_GROUP_ALL

Line 169: l_group_desc igs_pe_persid_group_all.description%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;
172:
173: BEGIN

Line 667: p_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,

663: END add_to_do;
664:
665: FUNCTION assign_todo(
666: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
667: p_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
668: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
669: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
670: p_upd_mode IN VARCHAR2,
671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 727: /* CURSOR c_person_id_grp (cp_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS

723: c_person_id_grp c_person_id_grpCurTyp ;
724: TYPE c_person_id_grp_recTyp IS RECORD ( person_id igs_pe_person_base_v.person_id%TYPE, person_number igs_pe_person_base_v.person_number%TYPE, full_name igs_pe_person_base_v.full_name%TYPE );
725: c_person_id_grp_rec c_person_id_grp_recTyp ;
726:
727: /* CURSOR c_person_id_grp (cp_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS
728: SELECT person_id, person_number, full_name
729: FROM igs_pe_prsid_grp_mem_v
730: WHERE group_id = cp_person_id_grp
731: AND TRUNC(SYSDATE) BETWEEN NVL(start_date,TRUNC(SYSDATE)) AND NVL(end_date,TRUNC(SYSDATE));