1 PACKAGE IGS_FI_F_TYP_CA_INST_PKG AS
2 /* $Header: IGSSI49S.pls 120.3 2005/09/03 10:49:30 appldev ship $*/
3 --by vvutukur on 11-jan-2002 as part of Bug 2175865
4 --since subaccount is moved from detail to master of fee types
5 --removing the subaccount_id column in all the calls.
6 procedure INSERT_ROW (
7 X_ROWID in out NOCOPY VARCHAR2,
8 X_FEE_TYPE in VARCHAR2,
9 X_FEE_CAL_TYPE in VARCHAR2,
10 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
11 X_FEE_TYPE_CI_STATUS in VARCHAR2,
12 X_START_DT_ALIAS in VARCHAR2,
13 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
14 X_END_DT_ALIAS in VARCHAR2,
15 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
16 X_RETRO_DT_ALIAS in VARCHAR2,
17 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
18 X_S_CHG_METHOD_TYPE in VARCHAR2,
19 X_RUL_SEQUENCE_NUMBER in NUMBER,
20 X_ORG_ID in NUMBER default NULL,
21 X_MODE in VARCHAR2 default 'R',
22 X_INITIAL_DEFAULT_AMOUNT in NUMBER DEFAULT NULL,
23 x_acct_hier_id IN NUMBER DEFAULT NULL,
24 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
25 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
26 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
27 x_ret_gl_ccid IN NUMBER DEFAULT NULL,
28 x_ret_account_cd IN VARCHAR2 DEFAULT NULL,
29 x_retention_level_code IN VARCHAR2 DEFAULT NULL,
30 x_complete_ret_flag IN VARCHAR2 DEFAULT NULL,
31 x_nonzero_billable_cp_flag IN VARCHAR2 DEFAULT NULL,
32 X_SCOPE_RUL_SEQUENCE_NUM IN NUMBER DEFAULT NULL,
33 X_ELM_RNG_ORDER_NAME IN VARCHAR2 DEFAULT NULL,
34 X_MAX_CHG_ELEMENTS IN NUMBER DEFAULT NULL
35 );
36 procedure LOCK_ROW (
37 X_ROWID in VARCHAR2,
38 X_FEE_TYPE in VARCHAR2,
39 X_FEE_CAL_TYPE in VARCHAR2,
40 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
41 X_FEE_TYPE_CI_STATUS in VARCHAR2,
42 X_START_DT_ALIAS in VARCHAR2,
43 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
44 X_END_DT_ALIAS in VARCHAR2,
45 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
46 X_RETRO_DT_ALIAS in VARCHAR2,
47 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
48 X_S_CHG_METHOD_TYPE in VARCHAR2,
49 X_RUL_SEQUENCE_NUMBER in NUMBER,
50 X_INITIAL_DEFAULT_AMOUNT in NUMBER DEFAULT NULL,
51 x_acct_hier_id IN NUMBER DEFAULT NULL,
52 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
53 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
54 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
55 x_ret_gl_ccid IN NUMBER DEFAULT NULL,
56 x_ret_account_cd IN VARCHAR2 DEFAULT NULL,
57 x_retention_level_code IN VARCHAR2 DEFAULT NULL,
58 x_complete_ret_flag IN VARCHAR2 DEFAULT NULL,
59 x_nonzero_billable_cp_flag IN VARCHAR2 DEFAULT NULL,
60 X_SCOPE_RUL_SEQUENCE_NUM IN NUMBER DEFAULT NULL,
61 X_ELM_RNG_ORDER_NAME IN VARCHAR2 DEFAULT NULL,
62 X_MAX_CHG_ELEMENTS IN NUMBER DEFAULT NULL
63 );
64 procedure UPDATE_ROW (
65 X_ROWID in VARCHAR2,
66 X_FEE_TYPE in VARCHAR2,
67 X_FEE_CAL_TYPE in VARCHAR2,
68 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
69 X_FEE_TYPE_CI_STATUS in VARCHAR2,
70 X_START_DT_ALIAS in VARCHAR2,
71 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
72 X_END_DT_ALIAS in VARCHAR2,
73 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
74 X_RETRO_DT_ALIAS in VARCHAR2,
75 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
76 X_S_CHG_METHOD_TYPE in VARCHAR2,
77 X_RUL_SEQUENCE_NUMBER in NUMBER,
78 X_MODE in VARCHAR2 default 'R',
79 X_INITIAL_DEFAULT_AMOUNT in NUMBER DEFAULT NULL ,
80 x_acct_hier_id IN NUMBER DEFAULT NULL,
81 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
82 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
83 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
84 x_ret_gl_ccid IN NUMBER DEFAULT NULL,
85 x_ret_account_cd IN VARCHAR2 DEFAULT NULL,
86 x_retention_level_code IN VARCHAR2 DEFAULT NULL,
87 x_complete_ret_flag IN VARCHAR2 DEFAULT NULL,
88 x_nonzero_billable_cp_flag IN VARCHAR2 DEFAULT NULL,
89 X_SCOPE_RUL_SEQUENCE_NUM IN NUMBER DEFAULT NULL,
90 X_ELM_RNG_ORDER_NAME IN VARCHAR2 DEFAULT NULL,
91 X_MAX_CHG_ELEMENTS IN NUMBER DEFAULT NULL
92 );
93 procedure ADD_ROW (
94 X_ROWID in out NOCOPY VARCHAR2,
95 X_FEE_TYPE in VARCHAR2,
96 X_FEE_CAL_TYPE in VARCHAR2,
97 X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
98 X_FEE_TYPE_CI_STATUS in VARCHAR2,
99 X_START_DT_ALIAS in VARCHAR2,
100 X_START_DAI_SEQUENCE_NUMBER in NUMBER,
101 X_END_DT_ALIAS in VARCHAR2,
102 X_END_DAI_SEQUENCE_NUMBER in NUMBER,
103 X_RETRO_DT_ALIAS in VARCHAR2,
104 X_RETRO_DAI_SEQUENCE_NUMBER in NUMBER,
105 X_S_CHG_METHOD_TYPE in VARCHAR2,
106 X_RUL_SEQUENCE_NUMBER in NUMBER,
107 X_ORG_ID in NUMBER default NULL,
108 X_MODE in VARCHAR2 default 'R',
109 X_INITIAL_DEFAULT_AMOUNT in NUMBER DEFAULT NULL ,
110 x_acct_hier_id IN NUMBER DEFAULT NULL,
111 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
112 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
113 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
114 x_ret_gl_ccid IN NUMBER DEFAULT NULL,
115 x_ret_account_cd IN VARCHAR2 DEFAULT NULL,
116 x_retention_level_code IN VARCHAR2 DEFAULT NULL,
117 x_complete_ret_flag IN VARCHAR2 DEFAULT NULL,
118 x_nonzero_billable_cp_flag IN VARCHAR2 DEFAULT NULL,
119 X_SCOPE_RUL_SEQUENCE_NUM IN NUMBER DEFAULT NULL,
120 X_ELM_RNG_ORDER_NAME IN VARCHAR2 DEFAULT NULL,
121 X_MAX_CHG_ELEMENTS IN NUMBER DEFAULT NULL
122 );
123
124 FUNCTION Get_PK_For_Validation (
125 x_fee_type IN VARCHAR2,
126 x_fee_cal_type IN VARCHAR2,
127 x_fee_ci_sequence_number IN NUMBER
128 ) RETURN BOOLEAN;
129 PROCEDURE Check_Constraints (
130 column_name IN VARCHAR2 DEFAULT NULL,
131 column_value IN VARCHAR2 DEFAULT NULL
132 );
133 PROCEDURE Before_DML (
134 p_action IN VARCHAR2,
135 x_rowid IN VARCHAR2 DEFAULT NULL,
136 x_fee_type IN VARCHAR2 DEFAULT NULL,
137 x_fee_cal_type IN VARCHAR2 DEFAULT NULL,
138 x_fee_ci_sequence_number IN NUMBER DEFAULT NULL,
139 x_fee_type_ci_status IN VARCHAR2 DEFAULT NULL,
140 x_start_dt_alias IN VARCHAR2 DEFAULT NULL,
141 x_start_dai_sequence_number IN NUMBER DEFAULT NULL,
142 x_end_dt_alias IN VARCHAR2 DEFAULT NULL,
143 x_end_dai_sequence_number IN NUMBER DEFAULT NULL,
144 x_retro_dt_alias IN VARCHAR2 DEFAULT NULL,
145 x_retro_dai_sequence_number IN NUMBER DEFAULT NULL,
146 x_s_chg_method_type IN VARCHAR2 DEFAULT NULL,
147 x_rul_sequence_number IN NUMBER DEFAULT NULL,
148 x_org_id in NUMBER DEFAULT NULL,
149 x_creation_date IN DATE DEFAULT NULL,
150 x_created_by IN NUMBER DEFAULT NULL,
151 x_last_update_date IN DATE DEFAULT NULL,
152 x_last_updated_by IN NUMBER DEFAULT NULL,
153 x_last_update_login IN NUMBER DEFAULT NULL,
154 x_initial_default_amount in NUMBER DEFAULT NULL,
155 x_acct_hier_id IN NUMBER DEFAULT NULL,
156 x_rec_gl_ccid IN NUMBER DEFAULT NULL,
157 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
158 x_rec_account_cd IN VARCHAR2 DEFAULT NULL,
159 x_ret_gl_ccid IN NUMBER DEFAULT NULL,
160 x_ret_account_cd IN VARCHAR2 DEFAULT NULL,
161 x_retention_level_code IN VARCHAR2 DEFAULT NULL,
162 x_complete_ret_flag IN VARCHAR2 DEFAULT NULL,
163 x_nonzero_billable_cp_flag IN VARCHAR2 DEFAULT NULL,
164 X_SCOPE_RUL_SEQUENCE_NUM IN NUMBER DEFAULT NULL,
165 X_ELM_RNG_ORDER_NAME IN VARCHAR2 DEFAULT NULL,
166 X_MAX_CHG_ELEMENTS IN NUMBER DEFAULT NULL
167 );
168 PROCEDURE GET_FK_IGS_CA_INST (
169 x_cal_type IN VARCHAR2,
170 x_sequence_number IN NUMBER
171 );
172 PROCEDURE GET_FK_IGS_CA_DA_INST (
173 x_dt_alias IN VARCHAR2,
174 x_sequence_number IN NUMBER,
175 x_cal_type IN VARCHAR2,
176 x_ci_sequence_number IN NUMBER
177 );
178 PROCEDURE GET_FK_IGS_FI_FEE_STR_STAT (
179 x_fee_structure_status IN VARCHAR2
180 );
181
182 PROCEDURE GET_FK_IGS_RU_RULE (
183 x_sequence_number IN NUMBER
184 );
185 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
186 x_s_chg_method_type IN VARCHAR2
187 );
188
189 PROCEDURE GET_FK_IGS_FI_ELM_RNG_ORDS (
190 x_elm_rng_order_name IN VARCHAR2
191 );
192 PROCEDURE GET_FK1_IGS_RU_RULE (
193 x_scope_rul_sequence_num IN NUMBER
194 );
195 end IGS_FI_F_TYP_CA_INST_PKG;