1 PACKAGE igf_ap_td_item_inst_pkg AS
2 /* $Header: IGFAI15S.pls 120.1 2005/08/03 03:14:10 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_INST_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 | Who When What |
30 | masehgal 28-Apr-2002 # 2303509 Added get uk for validation |
31 | bkkumar 04-jun-2003 Added legacy_ record_flag in the tbh calls|
32 | #2858504 |
33 *=======================================================================*/
34
35 PROCEDURE insert_row (
36 x_rowid IN OUT NOCOPY VARCHAR2,
37 x_base_id IN NUMBER,
38 x_item_sequence_number IN NUMBER,
39 x_status IN VARCHAR2,
40 x_status_date IN DATE,
41 x_add_date IN DATE,
42 x_corsp_date IN DATE,
43 x_corsp_count IN NUMBER,
44 x_inactive_flag IN VARCHAR2,
45 x_freq_attempt IN NUMBER DEFAULT NULL,
46 x_max_attempt IN NUMBER DEFAULT NULL,
47 x_required_for_application IN VARCHAR2 DEFAULT NULL,
48 x_mode IN VARCHAR2 DEFAULT 'R' ,
49 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
50 x_clprl_id IN NUMBER DEFAULT NULL
51 );
52
53 PROCEDURE lock_row (
54 x_rowid IN VARCHAR2,
55 x_base_id IN NUMBER,
56 x_item_sequence_number IN NUMBER,
57 x_status IN VARCHAR2,
58 x_status_date IN DATE,
59 x_add_date IN DATE,
60 x_corsp_date IN DATE,
61 x_corsp_count IN NUMBER,
62 x_inactive_flag 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_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
67 x_clprl_id IN NUMBER DEFAULT NULL
68 );
69
70 PROCEDURE update_row (
71 x_rowid IN VARCHAR2,
72 x_base_id IN NUMBER,
73 x_item_sequence_number IN NUMBER,
74 x_status IN VARCHAR2,
75 x_status_date IN DATE,
76 x_add_date IN DATE,
77 x_corsp_date IN DATE,
78 x_corsp_count IN NUMBER,
79 x_inactive_flag IN VARCHAR2,
80 x_freq_attempt IN NUMBER DEFAULT NULL,
81 x_max_attempt IN NUMBER DEFAULT NULL,
82 x_required_for_application IN VARCHAR2 DEFAULT NULL,
83 x_mode IN VARCHAR2 DEFAULT 'R' ,
84 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
85 x_clprl_id IN NUMBER DEFAULT NULL
86 );
87
88 PROCEDURE add_row (
89 x_rowid IN OUT NOCOPY VARCHAR2,
90 x_base_id IN NUMBER,
91 x_item_sequence_number IN NUMBER,
92 x_status IN VARCHAR2,
93 x_status_date IN DATE,
94 x_add_date IN DATE,
95 x_corsp_date IN DATE,
96 x_corsp_count IN NUMBER,
97 x_inactive_flag IN VARCHAR2,
98 x_freq_attempt IN NUMBER DEFAULT NULL,
99 x_max_attempt IN NUMBER DEFAULT NULL,
100 x_required_for_application IN VARCHAR2 DEFAULT NULL,
101 x_mode IN VARCHAR2 DEFAULT 'R' ,
102 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
103 x_clprl_id IN NUMBER DEFAULT NULL
104 );
105
106 PROCEDURE delete_row (
107 x_rowid IN VARCHAR2
108 );
109
110 FUNCTION get_pk_for_validation (
111 x_base_id IN NUMBER,
112 x_item_sequence_number IN NUMBER
113 ) RETURN BOOLEAN;
114
115
116 -- # 2303509 Added Check for Uniqueness
117 FUNCTION get_uk_for_validation (
118 x_base_id IN NUMBER,
119 x_item_sequence_number IN NUMBER
120 ) RETURN BOOLEAN;
121
122
123 PROCEDURE get_fk_igf_ap_fa_base_rec (
124 x_base_id IN NUMBER
125 );
126
127 PROCEDURE get_fk_igf_ap_td_item_mst (
128 x_todo_number IN NUMBER
129 );
130
131 PROCEDURE before_dml (
132 p_action IN VARCHAR2,
133 x_rowid IN VARCHAR2 DEFAULT NULL,
134 x_base_id IN NUMBER DEFAULT NULL,
135 x_item_sequence_number IN NUMBER DEFAULT NULL,
136 x_status IN VARCHAR2 DEFAULT NULL,
137 x_status_date IN DATE DEFAULT NULL,
138 x_add_date IN DATE DEFAULT NULL,
139 x_corsp_date IN DATE DEFAULT NULL,
140 x_corsp_count IN NUMBER DEFAULT NULL,
141 x_inactive_flag IN VARCHAR2 DEFAULT NULL,
142 x_freq_attempt IN NUMBER DEFAULT NULL,
143 x_max_attempt IN NUMBER DEFAULT NULL,
144 x_required_for_application IN VARCHAR2 DEFAULT NULL,
145 x_legacy_record_flag IN VARCHAR2 DEFAULT NULL,
146 x_creation_date IN DATE DEFAULT NULL,
147 x_created_by IN NUMBER DEFAULT NULL,
148 x_last_update_date IN DATE DEFAULT NULL,
149 x_last_updated_by IN NUMBER DEFAULT NULL,
150 x_last_update_login IN NUMBER DEFAULT NULL,
151 x_clprl_id IN NUMBER DEFAULT NULL
152 );
153
154 PROCEDURE after_dml(
155 p_action IN VARCHAR2
156 );
157
158
159 END igf_ap_td_item_inst_pkg;