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.

[Home] [Help]

APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGF_AP_TD_ITEM_MST

Line 127: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE

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
126: CURSOR c_item_details(
127: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
128: ) IS
129: SELECT description
130: FROM igf_ap_td_item_mst
131: WHERE todo_number = cp_todo_number;

Line 130: FROM igf_ap_td_item_mst

126: CURSOR c_item_details(
127: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
128: ) IS
129: SELECT description
130: FROM igf_ap_td_item_mst
131: WHERE todo_number = cp_todo_number;
132:
133: -- Get the details of
134: CURSOR c_person_number(

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 160: lc_item_description igf_ap_td_item_mst.description%TYPE;

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;
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;

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 439: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE

435: */
436:
437: -- Get the details of Item codes and its descritpions
438: CURSOR c_item_details(
439: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
440: ) IS
441: SELECT item_code, description, required_for_application, freq_attempt, max_attempt, career_item, system_todo_type_code
442: FROM igf_ap_td_item_mst
443: WHERE todo_number = cp_todo_number;

Line 442: FROM igf_ap_td_item_mst

438: CURSOR c_item_details(
439: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
440: ) IS
441: SELECT item_code, description, required_for_application, freq_attempt, max_attempt, career_item, system_todo_type_code
442: FROM igf_ap_td_item_mst
443: WHERE todo_number = cp_todo_number;
444:
445:
446: CURSOR c_chk_career_exists(

Line 448: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE

444:
445:
446: CURSOR c_chk_career_exists(
447: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
448: cp_todo_number igf_ap_td_item_mst.todo_number%TYPE
449: ) IS
450: SELECT 1 value, fab.base_id base_id
451: FROM igf_ap_fa_base_rec fab,
452: igf_ap_td_item_inst inst,

Line 453: igf_ap_td_item_mst mst

449: ) IS
450: SELECT 1 value, fab.base_id base_id
451: FROM igf_ap_fa_base_rec fab,
452: igf_ap_td_item_inst inst,
453: igf_ap_td_item_mst mst
454: WHERE fab.person_id = cp_person_id
455: AND mst.todo_number = cp_todo_number
456: AND mst.career_item = 'Y'
457: AND inst.item_sequence_number = mst.todo_number

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: /*