1 package IGS_CA_INST_PKG AS
2 /* $Header: IGSCI12S.pls 120.0 2005/06/01 18:52:11 appldev noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_CAL_TYPE in VARCHAR2,
6 X_SEQUENCE_NUMBER in NUMBER,
7 X_START_DT in DATE,
8 X_END_DT in DATE,
9 X_CAL_STATUS in VARCHAR2,
10 X_ALTERNATE_CODE in VARCHAR2,
11 X_SUP_CAL_STATUS_DIFFER_IND in VARCHAR2,
12 X_PRIOR_CI_SEQUENCE_NUMBER in NUMBER,
13 X_ORG_ID in NUMBER default NULL,
14 X_MODE in VARCHAR2 default 'R',
15 X_SS_DISPLAYED in VARCHAR2 default 'N' ,
16 X_DESCRIPTION IN VARCHAR2 ,
17 X_IVR_DISPLAY_IND in VARCHAR2 default 'N',
18 X_TERM_INSTRUCTION_TIME IN NUMBER DEFAULT NULL,
19 X_PLANNING_FLAG in VARCHAR2 default 'N',
20 X_SCHEDULE_FLAG in VARCHAR2 default 'N',
21 X_ADMIN_FLAG in VARCHAR2 default 'N'
22 );
23 procedure LOCK_ROW (
24 X_ROWID in VARCHAR2,
25 X_CAL_TYPE in VARCHAR2,
26 X_SEQUENCE_NUMBER in NUMBER,
27 X_START_DT in DATE,
28 X_END_DT in DATE,
29 X_CAL_STATUS in VARCHAR2,
30 X_ALTERNATE_CODE in VARCHAR2,
31 X_SUP_CAL_STATUS_DIFFER_IND in VARCHAR2,
32 X_PRIOR_CI_SEQUENCE_NUMBER in NUMBER,
33 X_SS_DISPLAYED in VARCHAR2 default 'N',
34 X_DESCRIPTION IN VARCHAR2 ,
35 X_IVR_DISPLAY_IND in VARCHAR2 default 'N',
36 X_TERM_INSTRUCTION_TIME IN NUMBER DEFAULT NULL,
37 X_PLANNING_FLAG in VARCHAR2 default 'N',
38 X_SCHEDULE_FLAG in VARCHAR2 default 'N',
39 X_ADMIN_FLAG in VARCHAR2 default 'N'
40 );
41 procedure UPDATE_ROW (
42 X_ROWID in VARCHAR2,
43 X_CAL_TYPE in VARCHAR2,
44 X_SEQUENCE_NUMBER in NUMBER,
45 X_START_DT in DATE,
46 X_END_DT in DATE,
47 X_CAL_STATUS in VARCHAR2,
48 X_ALTERNATE_CODE in VARCHAR2,
49 X_SUP_CAL_STATUS_DIFFER_IND in VARCHAR2,
50 X_PRIOR_CI_SEQUENCE_NUMBER in NUMBER,
51 X_MODE in VARCHAR2 default 'R',
52 X_SS_DISPLAYED in VARCHAR2 default NULL,
53 X_DESCRIPTION IN VARCHAR2 ,
54 X_IVR_DISPLAY_IND in VARCHAR2 default 'N',
55 X_TERM_INSTRUCTION_TIME IN NUMBER DEFAULT NULL,
56 X_PLANNING_FLAG in VARCHAR2 default 'N',
57 X_SCHEDULE_FLAG in VARCHAR2 default 'N',
58 X_ADMIN_FLAG in VARCHAR2 default 'N'
59 );
60 procedure ADD_ROW (
61 X_ROWID in out NOCOPY VARCHAR2,
62 X_CAL_TYPE in VARCHAR2,
63 X_SEQUENCE_NUMBER in NUMBER,
64 X_START_DT in DATE,
65 X_END_DT in DATE,
66 X_CAL_STATUS in VARCHAR2,
67 X_ALTERNATE_CODE in VARCHAR2,
68 X_SUP_CAL_STATUS_DIFFER_IND in VARCHAR2,
69 X_PRIOR_CI_SEQUENCE_NUMBER in NUMBER,
70 X_ORG_ID in NUMBER default NULL,
71 X_MODE in VARCHAR2 default 'R',
72 X_SS_DISPLAYED in VARCHAR2 default 'N',
73 X_DESCRIPTION IN VARCHAR2 ,
74 X_IVR_DISPLAY_IND in VARCHAR2 default 'N',
75 X_TERM_INSTRUCTION_TIME IN NUMBER DEFAULT NULL ,
76 X_PLANNING_FLAG in VARCHAR2 default 'N',
77 X_SCHEDULE_FLAG in VARCHAR2 default 'N',
78 X_ADMIN_FLAG in VARCHAR2 default 'N'
79 );
80 procedure DELETE_ROW (
81 X_ROWID in VARCHAR2
82 );
83
84 FUNCTION Get_PK_For_Validation (
85 x_cal_type IN VARCHAR2,
86 x_sequence_number IN NUMBER
87 ) RETURN BOOLEAN;
88
89 FUNCTION Get_UK_For_Validation (
90 x_cal_type IN VARCHAR2,
91 x_sequence_number IN NUMBER,
92 x_start_dt IN DATE,
93 x_end_dt IN DATE
94 )RETURN BOOLEAN ;
95
96 FUNCTION Get_UK2_For_Validation (
97 x_cal_type IN VARCHAR2,
98 x_start_dt IN DATE,
99 x_end_dt IN DATE
100 )RETURN BOOLEAN;
101
102 PROCEDURE GET_FK_IGS_CA_TYPE (
103 x_cal_type IN VARCHAR2
104 );
105
106 PROCEDURE GET_FK_IGS_CA_STAT (
107 x_cal_status IN VARCHAR2
108 );
109
110 PROCEDURE GET_FK_IGS_CA_INST (
111 x_cal_type IN VARCHAR2,
112 x_sequence_number IN NUMBER
113 );
114
115 PROCEDURE Check_Constraints (
116 Column_Name IN VARCHAR2 DEFAULT NULL,
117 Column_Value IN VARCHAR2 DEFAULT NULL
118 );
119
120 PROCEDURE Before_DML (
121 p_action IN VARCHAR2,
122 x_rowid IN VARCHAR2 DEFAULT NULL,
123 x_cal_type IN VARCHAR2 DEFAULT NULL,
124 x_sequence_number IN NUMBER DEFAULT NULL,
125 x_start_dt IN DATE DEFAULT NULL,
126 x_end_dt IN DATE DEFAULT NULL,
127 x_cal_status IN VARCHAR2 DEFAULT NULL,
128 x_alternate_code IN VARCHAR2 DEFAULT NULL,
129 x_sup_cal_status_differ_ind IN VARCHAR2 DEFAULT NULL,
130 x_prior_ci_sequence_number IN NUMBER DEFAULT NULL,
131 x_org_id in NUMBER default NULL,
132 x_creation_date IN DATE DEFAULT NULL,
133 x_created_by IN NUMBER DEFAULT NULL,
134 x_last_update_date IN DATE DEFAULT NULL,
135 x_last_updated_by IN NUMBER DEFAULT NULL,
136 x_last_update_login IN NUMBER DEFAULT NULL,
137 x_ss_displayed IN VARCHAR2 DEFAULT 'N',
138 x_description IN VARCHAR2 DEFAULT NULL,
139 x_ivr_display_ind IN VARCHAR2 DEFAULT 'N',
140 x_term_instruction_time IN NUMBER DEFAULT NULL,
141 x_planning_flag in varchar2 default 'N',
142 x_schedule_flag in varchar2 default 'N',
143 x_admin_flag in varchar2 default 'N'
144 );
145
146 END igs_ca_inst_pkg;