1 PACKAGE igf_ap_td_item_mst_pkg AS
2 /* $Header: IGFAI37S.pls 120.1 2005/08/02 00:18:01 appldev ship $ */
3
4 /*=======================================================================+
5 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
6 | All rights reserved. |
7 +=======================================================================+
8 | |
9 | DESCRIPTION |
10 | PL/SQL spec for package: IGF_AP_TD_ITEM_MST_PKG
11 | |
12 | NOTES |
13 | |
14 | This package has a flag on the end of some of the procedures called |
15 | X_MODE. Pass either 'R' for runtime, or 'I' for Install-time. |
16 | This will control how the who columns are filled in; If you are |
17 | running in runtime mode, they are taken from the profiles, whereas in |
18 | install-time mode they get defaulted with special values to indicate |
19 | that they were inserted by datamerge. |
20 | |
21 | The ADD_ROW routine will see whether a row exists by selecting |
22 | based on the primary key, and updates the row if it exists, |
23 | or inserts the row if it doesn't already exist. |
24 | |
25 | This module is called by AutoInstall (afplss.drv) on install and |
26 | upgrade. The WHENEVER SQLERROR and EXIT (at bottom) are required. |
27 | |
28 | HISTORY |
29 | gvarapra 13-sep-2004 FA138 - ISIR Enhancements |
30 | added new cloumn system_todo_type_code|
31 *=======================================================================*/
32
33 PROCEDURE insert_row (
34 x_rowid IN OUT NOCOPY VARCHAR2,
35 x_todo_number IN OUT NOCOPY NUMBER,
36 x_item_code IN VARCHAR2,
37 x_ci_cal_type IN VARCHAR2,
38 x_ci_sequence_number IN NUMBER,
39 x_description IN VARCHAR2,
40 x_corsp_mesg IN VARCHAR2,
41 x_career_item IN VARCHAR2,
42 x_freq_attempt IN NUMBER DEFAULT NULL,
43 x_max_attempt IN NUMBER DEFAULT NULL,
44 x_required_for_application IN VARCHAR2 DEFAULT NULL,
45 x_mode IN VARCHAR2 DEFAULT 'R',
46 x_system_todo_type_code IN VARCHAR2 DEFAULT NULL,
47 x_application_code IN VARCHAR2 DEFAULT NULL,
48 x_display_in_ss_flag IN VARCHAR2 DEFAULT NULL,
49 x_ss_instruction_txt IN VARCHAR2 DEFAULT NULL,
50 x_allow_attachment_flag IN VARCHAR2 DEFAULT NULL,
51 x_document_url_txt IN VARCHAR2 DEFAULT NULL
52 );
53
54 PROCEDURE lock_row (
55 x_rowid IN VARCHAR2,
56 x_todo_number IN NUMBER,
57 x_item_code IN VARCHAR2,
58 x_ci_cal_type IN VARCHAR2,
59 x_ci_sequence_number IN NUMBER,
60 x_description IN VARCHAR2,
61 x_corsp_mesg IN VARCHAR2,
62 x_career_item IN VARCHAR2,
63 x_freq_attempt IN NUMBER DEFAULT NULL,
64 x_max_attempt IN NUMBER DEFAULT NULL,
65 x_required_for_application IN VARCHAR2 DEFAULT NULL,
66 x_system_todo_type_code IN VARCHAR2 DEFAULT NULL,
67 x_application_code IN VARCHAR2 DEFAULT NULL,
68 x_display_in_ss_flag IN VARCHAR2 DEFAULT NULL,
69 x_ss_instruction_txt IN VARCHAR2 DEFAULT NULL,
70 x_allow_attachment_flag IN VARCHAR2 DEFAULT NULL,
71 x_document_url_txt IN VARCHAR2 DEFAULT NULL
72 );
73
74 PROCEDURE update_row (
75 x_rowid IN VARCHAR2,
76 x_todo_number IN NUMBER,
77 x_item_code IN VARCHAR2,
78 x_ci_cal_type IN VARCHAR2,
79 x_ci_sequence_number IN NUMBER,
80 x_description IN VARCHAR2,
81 x_corsp_mesg IN VARCHAR2,
82 x_career_item IN VARCHAR2,
83 x_freq_attempt IN NUMBER DEFAULT NULL,
84 x_max_attempt IN NUMBER DEFAULT NULL,
85 x_required_for_application IN VARCHAR2 DEFAULT NULL,
86 x_mode IN VARCHAR2 DEFAULT 'R',
87 x_system_todo_type_code IN VARCHAR2 DEFAULT NULL,
88 x_application_code IN VARCHAR2 DEFAULT NULL,
89 x_display_in_ss_flag IN VARCHAR2 DEFAULT NULL,
90 x_ss_instruction_txt IN VARCHAR2 DEFAULT NULL,
91 x_allow_attachment_flag IN VARCHAR2 DEFAULT NULL,
92 x_document_url_txt IN VARCHAR2 DEFAULT NULL
93 );
94
95 PROCEDURE add_row (
96 x_rowid IN OUT NOCOPY VARCHAR2,
97 x_todo_number IN OUT NOCOPY NUMBER,
98 x_item_code IN VARCHAR2,
99 x_ci_cal_type IN VARCHAR2,
100 x_ci_sequence_number IN NUMBER,
101 x_description IN VARCHAR2,
102 x_corsp_mesg IN VARCHAR2,
103 x_career_item IN VARCHAR2,
104 x_freq_attempt IN NUMBER DEFAULT NULL,
105 x_max_attempt IN NUMBER DEFAULT NULL,
106 x_required_for_application IN VARCHAR2 DEFAULT NULL,
107 x_mode IN VARCHAR2 DEFAULT 'R',
108 x_system_todo_type_code IN VARCHAR2 DEFAULT NULL,
109 x_application_code IN VARCHAR2 DEFAULT NULL,
110 x_display_in_ss_flag IN VARCHAR2 DEFAULT NULL,
111 x_ss_instruction_txt IN VARCHAR2 DEFAULT NULL,
112 x_allow_attachment_flag IN VARCHAR2 DEFAULT NULL,
113 x_document_url_txt IN VARCHAR2 DEFAULT NULL
114 );
115
116 PROCEDURE delete_row (
117 x_rowid IN VARCHAR2
118 );
119
120 FUNCTION get_pk_for_validation (
121 x_todo_number IN NUMBER
122 ) RETURN BOOLEAN;
123
124 PROCEDURE get_fk_igf_ap_appl_setup(
125 x_ci_cal_type IN VARCHAR2,
126 x_ci_sequence_number IN NUMBER,
127 x_application_code IN VARCHAR2
128 );
129
130 FUNCTION get_uk_for_validation (
131 x_item_code IN VARCHAR2,
132 x_ci_cal_type IN VARCHAR2,
133 x_ci_sequence_number IN NUMBER,
134 x_org_id IN NUMBER
135 ) RETURN BOOLEAN;
136
137 PROCEDURE before_dml (
138 p_action IN VARCHAR2,
139 x_rowid IN VARCHAR2 DEFAULT NULL,
140 x_todo_number IN NUMBER DEFAULT NULL,
141 x_item_code IN VARCHAR2 DEFAULT NULL,
142 x_ci_cal_type IN VARCHAR2 DEFAULT NULL,
143 x_ci_sequence_number IN NUMBER DEFAULT NULL,
144 x_description IN VARCHAR2 DEFAULT NULL,
145 x_corsp_mesg IN VARCHAR2 DEFAULT NULL,
146 x_career_item IN VARCHAR2 DEFAULT NULL,
147 x_freq_attempt IN NUMBER DEFAULT NULL,
148 x_max_attempt IN NUMBER DEFAULT NULL,
149 x_required_for_application IN VARCHAR2 DEFAULT NULL,
150 x_creation_date IN DATE DEFAULT NULL,
151 x_created_by IN NUMBER DEFAULT NULL,
152 x_last_update_date IN DATE DEFAULT NULL,
153 x_last_updated_by IN NUMBER DEFAULT NULL,
154 x_last_update_login IN NUMBER DEFAULT NULL,
155 x_system_todo_type_code IN VARCHAR2 DEFAULT NULL,
156 x_application_code IN VARCHAR2 DEFAULT NULL,
157 x_display_in_ss_flag IN VARCHAR2 DEFAULT NULL,
158 x_ss_instruction_txt IN VARCHAR2 DEFAULT NULL,
159 x_allow_attachment_flag IN VARCHAR2 DEFAULT NULL,
160 x_document_url_txt IN VARCHAR2 DEFAULT NULL
161 );
162
163 END igf_ap_td_item_mst_pkg;