1 PACKAGE igf_aw_award_level_hist_pkg AS
2 /* $Header: IGFWI72S.pls 120.0 2005/09/09 17:11:18 appldev noship $ */
3 /*=======================================================================+
4 | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA|
5 | All rights reserved. |
6 +=======================================================================+
7 | |
8 | DESCRIPTION |
9 | PL/SQL spec for package: IGF_AW_AWARD_LEVEL_HIST_PKG
10 | |
11 | NOTES |
12 | |
13 | This package has a flag on the end of some of the procedures called |
14 | X_MODE. Pass either 'R' for runtime, or 'I' for Install-time. |
15 | This will control how the who columns are filled in; If you are |
16 | running in runtime mode, they are taken from the profiles, whereas in |
17 | install-time mode they get defaulted with special values to indicate |
18 | that they were inserted by datamerge. |
19 | |
20 | The ADD_ROW routine will see whether a row exists by selecting |
21 | based on the primary key, and updates the row if it exists, |
22 | or inserts the row if it doesn't already exist. |
23 | |
24 | This module is called by AutoInstall (afplss.drv) on install and |
25 | upgrade. The WHENEVER SQLERROR and EXIT (at bottom) are required. |
26 | |
27 | HISTORY |
28 *=======================================================================*/
29
30 PROCEDURE insert_row (
31 x_rowid IN OUT NOCOPY VARCHAR2,
32 x_award_id IN NUMBER,
33 x_award_hist_tran_id IN NUMBER,
34 x_award_attrib_code IN VARCHAR2,
35 x_award_change_source_code IN VARCHAR2,
36 x_old_offered_amt IN NUMBER,
37 x_new_offered_amt IN NUMBER,
38 x_old_accepted_amt IN NUMBER,
39 x_new_accepted_amt IN NUMBER,
40 x_old_paid_amt IN NUMBER,
41 x_new_paid_amt IN NUMBER,
42 x_old_lock_award_flag IN VARCHAR2,
43 x_new_lock_award_flag IN VARCHAR2,
44 x_old_award_status_code IN VARCHAR2,
45 x_new_award_status_code IN VARCHAR2,
46 x_old_adplans_id IN NUMBER,
47 x_new_adplans_id IN NUMBER,
48 x_mode IN VARCHAR2 DEFAULT 'R'
49 );
50
51 PROCEDURE lock_row (
52 x_rowid IN VARCHAR2,
53 x_award_id IN NUMBER,
54 x_award_hist_tran_id IN NUMBER,
55 x_award_attrib_code IN VARCHAR2,
56 x_award_change_source_code IN VARCHAR2,
57 x_old_offered_amt IN NUMBER,
58 x_new_offered_amt IN NUMBER,
59 x_old_accepted_amt IN NUMBER,
60 x_new_accepted_amt IN NUMBER,
61 x_old_paid_amt IN NUMBER,
62 x_new_paid_amt IN NUMBER,
63 x_old_lock_award_flag IN VARCHAR2,
64 x_new_lock_award_flag IN VARCHAR2,
65 x_old_award_status_code IN VARCHAR2,
66 x_new_award_status_code IN VARCHAR2,
67 x_old_adplans_id IN NUMBER,
68 x_new_adplans_id IN NUMBER
69 );
70
71 PROCEDURE update_row (
72 x_rowid IN VARCHAR2,
73 x_award_id IN NUMBER,
74 x_award_hist_tran_id IN NUMBER,
75 x_award_attrib_code IN VARCHAR2,
76 x_award_change_source_code IN VARCHAR2,
77 x_old_offered_amt IN NUMBER,
78 x_new_offered_amt IN NUMBER,
79 x_old_accepted_amt IN NUMBER,
80 x_new_accepted_amt IN NUMBER,
81 x_old_paid_amt IN NUMBER,
82 x_new_paid_amt IN NUMBER,
83 x_old_lock_award_flag IN VARCHAR2,
84 x_new_lock_award_flag IN VARCHAR2,
85 x_old_award_status_code IN VARCHAR2,
86 x_new_award_status_code IN VARCHAR2,
87 x_old_adplans_id IN NUMBER,
88 x_new_adplans_id IN NUMBER,
89 x_mode IN VARCHAR2 DEFAULT 'R'
90 );
91
92 PROCEDURE add_row (
93 x_rowid IN OUT NOCOPY VARCHAR2,
94 x_award_id IN NUMBER,
95 x_award_hist_tran_id IN NUMBER,
96 x_award_attrib_code IN VARCHAR2,
97 x_award_change_source_code IN VARCHAR2,
98 x_old_offered_amt IN NUMBER,
99 x_new_offered_amt IN NUMBER,
100 x_old_accepted_amt IN NUMBER,
101 x_new_accepted_amt IN NUMBER,
102 x_old_paid_amt IN NUMBER,
103 x_new_paid_amt IN NUMBER,
104 x_old_lock_award_flag IN VARCHAR2,
105 x_new_lock_award_flag IN VARCHAR2,
106 x_old_award_status_code IN VARCHAR2,
107 x_new_award_status_code IN VARCHAR2,
108 x_old_adplans_id IN NUMBER,
109 x_new_adplans_id IN NUMBER,
110 x_mode IN VARCHAR2 DEFAULT 'R'
111 );
112
113 PROCEDURE delete_row (
114 x_rowid IN VARCHAR2
115 );
116
117 FUNCTION get_pk_for_validation (
118 x_award_id IN NUMBER,
119 x_award_hist_tran_id IN NUMBER,
120 x_award_attrib_code IN VARCHAR2
121 ) RETURN BOOLEAN;
122
123 PROCEDURE get_fk_igf_aw_awd_dist_plans (
124 x_adplans_id IN NUMBER
125 );
126
127 PROCEDURE get_fk_igf_aw_award (
128 x_award_id IN NUMBER
129 );
130
131 PROCEDURE before_dml (
132 p_action IN VARCHAR2,
133 x_rowid IN VARCHAR2 DEFAULT NULL,
134 x_award_id IN NUMBER DEFAULT NULL,
135 x_award_hist_tran_id IN NUMBER DEFAULT NULL,
136 x_award_attrib_code IN VARCHAR2 DEFAULT NULL,
137 x_award_change_source_code IN VARCHAR2 DEFAULT NULL,
138 x_old_offered_amt IN NUMBER DEFAULT NULL,
139 x_new_offered_amt IN NUMBER DEFAULT NULL,
140 x_old_accepted_amt IN NUMBER DEFAULT NULL,
141 x_new_accepted_amt IN NUMBER DEFAULT NULL,
142 x_old_paid_amt IN NUMBER DEFAULT NULL,
143 x_new_paid_amt IN NUMBER DEFAULT NULL,
144 x_old_lock_award_flag IN VARCHAR2 DEFAULT NULL,
145 x_new_lock_award_flag IN VARCHAR2 DEFAULT NULL,
146 x_old_award_status_code IN VARCHAR2 DEFAULT NULL,
147 x_new_award_status_code IN VARCHAR2 DEFAULT NULL,
148 x_old_adplans_id IN NUMBER DEFAULT NULL,
149 x_new_adplans_id IN NUMBER 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 );
156
157 END igf_aw_award_level_hist_pkg;