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_AP_TD_ITEM_MST_ALL

Line 156: FROM igf_ap_td_item_mst_all

152: CURSOR c_item_descrption(
153: cp_item_number IN NUMBER
154: ) IS
155: SELECT description
156: FROM igf_ap_td_item_mst_all
157: WHERE todo_number = cp_item_number;
158:
159: parameter_rec c_get_parameters%ROWTYPE;
160: lc_item_description igf_ap_td_item_mst.description%TYPE;

Line 170: l_item_description igf_ap_td_item_mst_all.description%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
174:

Line 417: p_todo_number IN igf_ap_td_item_mst_all.todo_number%TYPE,

413:
414:
415: PROCEDURE add_to_do(
416: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
417: p_todo_number IN igf_ap_td_item_mst_all.todo_number%TYPE,
418: p_item_cnt IN NUMBER,
419: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
420: p_status IN igf_ap_td_item_inst_all.status%TYPE,
421: p_upd_mode IN VARCHAR2

Line 671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%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,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%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,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,

671: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
672: p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,

673: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
674: p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,

675: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
676: p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,

677: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
678: p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,

679: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
680: p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,

681: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
682: p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,

683: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
684: p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,

685: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
686: p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,

687: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
688: p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,

689: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
690: p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,

691: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
692: p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,

693: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
694: p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,
700: p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
701: p_calling_from IN VARCHAR2

Line 699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,

695: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
696: p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
697: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
698: p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
699: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,
700: p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
701: p_calling_from IN VARCHAR2
702: ) RETURN BOOLEAN AS
703: /*