1 PACKAGE igf_ap_todo_grps_prc_pkg AS
2 /* $Header: IGFAP28S.pls 120.4 2006/04/20 02:58:09 veramach ship $ */
3 /*=======================================================================+
4 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | |
8 | DESCRIPTION |
9 | PL/SQL body for package: IGF_AP_TODO_GRPS_PRC_PKG |
10 | |
11 | NOTES: |
12 | This process adds one or more To Do Items to the given Student or to|
13 | the group of students using Person ID Groups for a given Award Year.|
14 | |
15 | HISTORY |
16 | Who When What |
17 | bvisvana 20-Jun-2005 FA 140 - To Do Item Process |
18 | Included Status 1 to Status 15 corresponding |
19 | to the 15 to do items in main procedure |
20 | brajendr 12-Oct-2002 Changes the paramter order as specified in |
21 | the concurrent Job |
22 | Modified the Messages IGF_AP_NO_BASEID |
23 | |
24 *=======================================================================*/
25
26 FUNCTION assign_todo(
27 p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
28 p_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
29 p_awd_cal_type IN igs_ca_inst.cal_type%TYPE,
30 p_awd_seq_num IN igs_ca_inst.sequence_number%TYPE,
31 p_upd_mode IN VARCHAR2,
32 p_item_number_1 IN igf_ap_td_item_mst_all.todo_number%TYPE,
33 p_status_1 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
34 p_item_number_2 IN igf_ap_td_item_mst_all.todo_number%TYPE,
35 p_status_2 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
36 p_item_number_3 IN igf_ap_td_item_mst_all.todo_number%TYPE,
37 p_status_3 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
38 p_item_number_4 IN igf_ap_td_item_mst_all.todo_number%TYPE,
39 p_status_4 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
40 p_item_number_5 IN igf_ap_td_item_mst_all.todo_number%TYPE,
41 p_status_5 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
42 p_item_number_6 IN igf_ap_td_item_mst_all.todo_number%TYPE,
43 p_status_6 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
44 p_item_number_7 IN igf_ap_td_item_mst_all.todo_number%TYPE,
45 p_status_7 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
46 p_item_number_8 IN igf_ap_td_item_mst_all.todo_number%TYPE,
47 p_status_8 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
48 p_item_number_9 IN igf_ap_td_item_mst_all.todo_number%TYPE,
49 p_status_9 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
50 p_item_number_10 IN igf_ap_td_item_mst_all.todo_number%TYPE,
51 p_status_10 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
52 p_item_number_11 IN igf_ap_td_item_mst_all.todo_number%TYPE,
53 p_status_11 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
54 p_item_number_12 IN igf_ap_td_item_mst_all.todo_number%TYPE,
55 p_status_12 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
56 p_item_number_13 IN igf_ap_td_item_mst_all.todo_number%TYPE,
57 p_status_13 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
58 p_item_number_14 IN igf_ap_td_item_mst_all.todo_number%TYPE,
59 p_status_14 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
60 p_item_number_15 IN igf_ap_td_item_mst_all.todo_number%TYPE,
61 p_status_15 IN igf_ap_td_item_inst_all.status%TYPE DEFAULT NULL,
62 p_calling_from IN VARCHAR2
63 ) RETURN BOOLEAN;
64
65 PROCEDURE main(
66 errbuf OUT NOCOPY VARCHAR2,
67 retcode OUT NOCOPY NUMBER,
68 p_award_year IN VARCHAR2,
69 p_person_id_grp IN NUMBER,
70 p_base_id IN NUMBER,
71 p_upd_mode IN VARCHAR2,
72 p_item_1 IN NUMBER,
73 p_status_1 IN VARCHAR2 DEFAULT NULL,
74 p_item_2 IN NUMBER,
75 p_status_2 IN VARCHAR2 DEFAULT NULL,
76 p_item_3 IN NUMBER,
77 p_status_3 IN VARCHAR2 DEFAULT NULL,
78 p_item_4 IN NUMBER,
79 p_status_4 IN VARCHAR2 DEFAULT NULL,
80 p_item_5 IN NUMBER,
81 p_status_5 IN VARCHAR2 DEFAULT NULL,
82 p_item_6 IN NUMBER,
83 p_status_6 IN VARCHAR2 DEFAULT NULL,
84 p_item_7 IN NUMBER,
85 p_status_7 IN VARCHAR2 DEFAULT NULL,
86 p_item_8 IN NUMBER,
87 p_status_8 IN VARCHAR2 DEFAULT NULL,
88 p_item_9 IN NUMBER,
89 p_status_9 IN VARCHAR2 DEFAULT NULL,
90 p_item_10 IN NUMBER,
91 p_status_10 IN VARCHAR2 DEFAULT NULL,
92 p_item_11 IN NUMBER,
93 p_status_11 IN VARCHAR2 DEFAULT NULL,
94 p_item_12 IN NUMBER,
95 p_status_12 IN VARCHAR2 DEFAULT NULL,
96 p_item_13 IN NUMBER,
97 p_status_13 IN VARCHAR2 DEFAULT NULL,
98 p_item_14 IN NUMBER,
99 p_status_14 IN VARCHAR2 DEFAULT NULL,
100 p_item_15 IN NUMBER,
101 p_status_15 IN VARCHAR2 DEFAULT NULL
102 );
103
104
105 END igf_ap_todo_grps_prc_pkg;