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_AP_TD_ITEM_MST

Line 11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

7: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

8: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

9: p_prs_grp_id IN VARCHAR2 ,
10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

10: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

11: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

12: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

13: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

14: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

15: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

16: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

17: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
25: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE

Line 22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

18: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
25: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
26: ) AS

Line 23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

19: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
25: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
26: ) AS
27: /*

Line 24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

20: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
25: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
26: ) AS
27: /*
28: || Created By : masehgal

Line 25: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE

21: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
22: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
23: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
24: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
25: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
26: ) AS
27: /*
28: || Created By : masehgal
29: || Created On : 26-Sep-2002

Line 55: CURSOR c_item_details( cp_todo_number igf_ap_td_item_mst.todo_number%TYPE ) IS

51: 'PARAMETER_PASS','ISIR_FIELD') ;
52: l_lkup_type VARCHAR2(60) ;
53:
54: -- Get the details of Item codes and its descritpions
55: CURSOR c_item_details( cp_todo_number igf_ap_td_item_mst.todo_number%TYPE ) IS
56: SELECT description
57: FROM igf_ap_td_item_mst
58: WHERE todo_number = cp_todo_number ;
59:

Line 57: FROM igf_ap_td_item_mst

53:
54: -- Get the details of Item codes and its descritpions
55: CURSOR c_item_details( cp_todo_number igf_ap_td_item_mst.todo_number%TYPE ) IS
56: SELECT description
57: FROM igf_ap_td_item_mst
58: WHERE todo_number = cp_todo_number ;
59:
60: -- Get Verification Item Descrition
61: CURSOR c_get_verif_item (cp_ci_cal_type igs_ca_inst.cal_type%TYPE ,

Line 92: CURSOR c_item_descrption( cp_item_number IN igf_ap_td_item_mst_all.todo_number%TYPE ) IS

88: FROM igs_pe_persid_group
89: WHERE group_id = cp_person_id_grp;
90:
91: -- Get Item Description
92: CURSOR c_item_descrption( cp_item_number IN igf_ap_td_item_mst_all.todo_number%TYPE ) IS
93: SELECT description
94: FROM igf_ap_td_item_mst_all
95: WHERE todo_number = cp_item_number;
96:

Line 94: FROM igf_ap_td_item_mst_all

90:
91: -- Get Item Description
92: CURSOR c_item_descrption( cp_item_number IN igf_ap_td_item_mst_all.todo_number%TYPE ) IS
93: SELECT description
94: FROM igf_ap_td_item_mst_all
95: WHERE todo_number = cp_item_number;
96:
97:
98: parameter_rec c_get_parameters%ROWTYPE ;

Line 100: lc_item_description igf_ap_td_item_mst.description%TYPE ;

96:
97:
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:

Line 114: l_item_description igf_ap_td_item_mst_all.description%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;
115:
116:
117: BEGIN
118:

Line 374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

370: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE ,
371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

371: p_awd_cal_type IN igs_ca_inst.cal_type%TYPE ,
372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

372: p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE ,
373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

373: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE ,
374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

374: p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

375: p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

376: p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

377: p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

378: p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

379: p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

Line 384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

380: p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
388: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE

Line 385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

381: p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
388: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
389: ) RETURN BOOLEAN AS

Line 386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

382: p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
388: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
389: ) RETURN BOOLEAN AS
390: /*

Line 387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,

383: p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
388: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
389: ) RETURN BOOLEAN AS
390: /*
391: || Created By : masehgal

Line 388: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE

384: p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
385: p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
386: p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
387: p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE ,
388: p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
389: ) RETURN BOOLEAN AS
390: /*
391: || Created By : masehgal
392: || Created On : 26-Sep-2002

Line 535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,

531: p_awd_yr IN VARCHAR2,
532: p_prs_grp_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
533: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,
535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,

532: p_prs_grp_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
533: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,
535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,

533: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,
535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,

534: p_isir_field IN igf_ap_inst_ver_item.isir_map_col%TYPE,
535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,

535: p_item_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,

536: p_item_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,

537: p_item_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,

538: p_item_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,

539: p_item_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,

540: p_item_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,

Line 545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,

541: p_item_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
549: p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE

Line 546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,

542: p_item_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
549: p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
550: ) IS

Line 547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,

543: p_item_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
549: p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
550: ) IS
551: /*

Line 548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,

544: p_item_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
549: p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
550: ) IS
551: /*
552: || Created By : masehgal

Line 549: p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE

545: p_item_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
546: p_item_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
547: p_item_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
548: p_item_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
549: p_item_15 IN igf_ap_td_item_mst_all.todo_number%TYPE
550: ) IS
551: /*
552: || Created By : masehgal
553: || Created On : 26-Sep-2002