1 package IGS_EN_CAL_CONF_PKG AS
2 /* $Header: IGSEI26S.pls 120.0 2005/06/02 03:51:46 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_S_CONTROL_NUM in out NOCOPY NUMBER,
6 X_COMMENCE_CUTOFF_DT_ALIAS in VARCHAR2,
7 X_COMMENCEMENT_DT_ALIAS in VARCHAR2,
8 X_EFFECT_ENR_STRT_DT_ALIAS in VARCHAR2,
9 X_RECORD_OPEN_DT_ALIAS in VARCHAR2,
10 X_RECORD_CUTOFF_DT_ALIAS in VARCHAR2,
11 X_SUB_UNIT_DT_ALIAS in VARCHAR2,
12 X_VARIATION_CUTOFF_DT_ALIAS in VARCHAR2,
13 X_ENR_FORM_DUE_DT_ALIAS in VARCHAR2,
14 X_ENR_PCKG_PROD_DT_ALIAS in VARCHAR2,
15 X_LOAD_EFFECT_DT_ALIAS in VARCHAR2,
16 X_ENR_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
17 X_INVALID_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
18 X_LAPSE_DT_ALIAS in VARCHAR2,
19 X_ENR_CLEANUP_DT_ALIAS in VARCHAR2,
20 X_MODE in VARCHAR2 default 'R',
21 X_GRADING_SCHEMA_DT_ALIAS in VARCHAR2,
22 X_BEGIN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
23 X_CLEAN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
24 X_PLANNING_OPEN_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
25 X_SCHEDULE_OPEN_DT_ALIAS IN VARCHAR2 ,
26 X_AUDIT_STATUS_DT_ALIAS IN VARCHAR2 DEFAULT NULL
27 );
28 procedure LOCK_ROW (
29 X_ROWID IN VARCHAR2,
30 X_S_CONTROL_NUM in NUMBER,
31 X_COMMENCE_CUTOFF_DT_ALIAS in VARCHAR2,
32 X_COMMENCEMENT_DT_ALIAS in VARCHAR2,
33 X_EFFECT_ENR_STRT_DT_ALIAS in VARCHAR2,
34 X_RECORD_OPEN_DT_ALIAS in VARCHAR2,
35 X_RECORD_CUTOFF_DT_ALIAS in VARCHAR2,
36 X_SUB_UNIT_DT_ALIAS in VARCHAR2,
37 X_VARIATION_CUTOFF_DT_ALIAS in VARCHAR2,
38 X_ENR_FORM_DUE_DT_ALIAS in VARCHAR2,
39 X_ENR_PCKG_PROD_DT_ALIAS in VARCHAR2,
40 X_LOAD_EFFECT_DT_ALIAS in VARCHAR2,
41 X_ENR_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
42 X_INVALID_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
43 X_LAPSE_DT_ALIAS in VARCHAR2,
44 X_ENR_CLEANUP_DT_ALIAS in VARCHAR2,
45 X_GRADING_SCHEMA_DT_ALIAS in VARCHAR2 ,
46 X_BEGIN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
47 X_CLEAN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
48 X_PLANNING_OPEN_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
49 X_SCHEDULE_OPEN_DT_ALIAS IN VARCHAR2 ,
50 X_AUDIT_STATUS_DT_ALIAS IN VARCHAR2 DEFAULT NULL
51 );
52 procedure UPDATE_ROW (
53 X_ROWID IN VARCHAR2,
54 X_S_CONTROL_NUM in NUMBER,
55 X_COMMENCE_CUTOFF_DT_ALIAS in VARCHAR2,
56 X_COMMENCEMENT_DT_ALIAS in VARCHAR2,
57 X_EFFECT_ENR_STRT_DT_ALIAS in VARCHAR2,
58 X_RECORD_OPEN_DT_ALIAS in VARCHAR2,
59 X_RECORD_CUTOFF_DT_ALIAS in VARCHAR2,
60 X_SUB_UNIT_DT_ALIAS in VARCHAR2,
61 X_VARIATION_CUTOFF_DT_ALIAS in VARCHAR2,
62 X_ENR_FORM_DUE_DT_ALIAS in VARCHAR2,
63 X_ENR_PCKG_PROD_DT_ALIAS in VARCHAR2,
64 X_LOAD_EFFECT_DT_ALIAS in VARCHAR2,
65 X_ENR_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
66 X_INVALID_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
67 X_LAPSE_DT_ALIAS in VARCHAR2,
68 X_ENR_CLEANUP_DT_ALIAS in VARCHAR2,
69 X_MODE in VARCHAR2 default 'R',
70 X_GRADING_SCHEMA_DT_ALIAS in VARCHAR2,
71 X_BEGIN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
72 X_CLEAN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
73 X_PLANNING_OPEN_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
74 X_SCHEDULE_OPEN_DT_ALIAS IN VARCHAR2 ,
75 X_AUDIT_STATUS_DT_ALIAS IN VARCHAR2 DEFAULT NULL
76 );
77 procedure ADD_ROW (
78 X_ROWID in out NOCOPY VARCHAR2,
79 X_S_CONTROL_NUM in out NOCOPY NUMBER,
80 X_COMMENCE_CUTOFF_DT_ALIAS in VARCHAR2,
81 X_COMMENCEMENT_DT_ALIAS in VARCHAR2,
82 X_EFFECT_ENR_STRT_DT_ALIAS in VARCHAR2,
83 X_RECORD_OPEN_DT_ALIAS in VARCHAR2,
84 X_RECORD_CUTOFF_DT_ALIAS in VARCHAR2,
85 X_SUB_UNIT_DT_ALIAS in VARCHAR2,
86 X_VARIATION_CUTOFF_DT_ALIAS in VARCHAR2,
87 X_ENR_FORM_DUE_DT_ALIAS in VARCHAR2,
88 X_ENR_PCKG_PROD_DT_ALIAS in VARCHAR2,
89 X_LOAD_EFFECT_DT_ALIAS in VARCHAR2,
90 X_ENR_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
91 X_INVALID_RULE_CUTOFF_DT_ALIAS in VARCHAR2,
92 X_LAPSE_DT_ALIAS in VARCHAR2,
93 X_ENR_CLEANUP_DT_ALIAS in VARCHAR2,
94 X_MODE in VARCHAR2 default 'R',
95 X_GRADING_SCHEMA_DT_ALIAS in VARCHAR2,
96 X_BEGIN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
97 X_CLEAN_TRANS_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
98 X_PLANNING_OPEN_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
99 X_SCHEDULE_OPEN_DT_ALIAS IN VARCHAR2 ,
100 X_AUDIT_STATUS_DT_ALIAS IN VARCHAR2 DEFAULT NULL
101 );
102 procedure DELETE_ROW (
103 X_ROWID IN VARCHAR2
104 );
105
106 FUNCTION Get_PK_For_Validation (
107 x_s_control_num IN NUMBER
108 )
109 RETURN BOOLEAN ;
110
111 PROCEDURE GET_FK_IGS_CA_DA (
112 x_dt_alias IN VARCHAR2
113 );
114 procedure Check_constraints(
115 column_name IN VARCHAR2 DEFAULT NULL,
116 column_value IN VARCHAR2 DEFAULT NULL
117 );
118 PROCEDURE Before_DML (
119 p_action IN VARCHAR2,
120 x_rowid IN VARCHAR2 DEFAULT NULL,
121 x_s_control_num IN NUMBER DEFAULT NULL,
122 x_commence_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
123 x_commencement_dt_alias IN VARCHAR2 DEFAULT NULL,
124 x_effect_enr_strt_dt_alias IN VARCHAR2 DEFAULT NULL,
125 x_record_open_dt_alias IN VARCHAR2 DEFAULT NULL,
126 x_record_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
127 x_sub_unit_dt_alias IN VARCHAR2 DEFAULT NULL,
128 x_variation_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
129 x_enr_form_due_dt_alias IN VARCHAR2 DEFAULT NULL,
130 x_enr_pckg_prod_dt_alias IN VARCHAR2 DEFAULT NULL,
131 x_load_effect_dt_alias IN VARCHAR2 DEFAULT NULL,
132 x_enr_rule_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
133 x_invalid_rule_cutoff_dt_alias IN VARCHAR2 DEFAULT NULL,
134 x_enr_cleanup_dt_alias IN VARCHAR2 DEFAULT NULL,
135 x_lapse_dt_alias IN VARCHAR2 DEFAULT NULL,
136 x_creation_date IN DATE DEFAULT NULL,
137 x_created_by IN NUMBER DEFAULT NULL,
138 x_last_update_date IN DATE DEFAULT NULL,
139 x_last_updated_by IN NUMBER DEFAULT NULL,
140 x_last_update_login IN NUMBER DEFAULT NULL,
141 x_grading_schema_dt_alias in VARCHAR2 DEFAULT NULL,
142 x_begin_trans_dt_alias IN VARCHAR2 DEFAULT NULL,
143 x_clean_trans_dt_alias IN VARCHAR2 DEFAULT NULL,
144 X_PLANNING_OPEN_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
145 X_SCHEDULE_OPEN_DT_ALIAS IN VARCHAR2 DEFAULT NULL,
146 X_AUDIT_STATUS_DT_ALIAS IN VARCHAR2 DEFAULT NULL
147 );
148 end IGS_EN_CAL_CONF_PKG;