[Home] [Help]
90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_PM_SCHEDULES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_PM_SCHEDULES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_pm_schedules_v_rec_type IS
100: CURSOR oks_pm_schedules_v_pk_csr (p_id IN NUMBER) IS
101: SELECT
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_pm_schedules_v_rec_type IS
100: CURSOR oks_pm_schedules_v_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: RULE_ID,
96: FUNCTION get_rec (
97: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN oks_pm_schedules_v_rec_type IS
100: CURSOR oks_pm_schedules_v_pk_csr (p_id IN NUMBER) IS
101: SELECT
102: ID,
103: RULE_ID,
104: PMA_RULE_ID,
121: PROGRAM_APPLICATION_ID,
122: PROGRAM_ID,
123: PROGRAM_UPDATE_DATE,
124: REQUEST_ID
125: FROM Oks_Pm_Schedules_V
126: WHERE oks_pm_schedules_v.id = p_id;
127: l_oks_pm_schedules_v_pk oks_pm_schedules_v_pk_csr%ROWTYPE;
128: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
129: BEGIN
122: PROGRAM_ID,
123: PROGRAM_UPDATE_DATE,
124: REQUEST_ID
125: FROM Oks_Pm_Schedules_V
126: WHERE oks_pm_schedules_v.id = p_id;
127: l_oks_pm_schedules_v_pk oks_pm_schedules_v_pk_csr%ROWTYPE;
128: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
123: PROGRAM_UPDATE_DATE,
124: REQUEST_ID
125: FROM Oks_Pm_Schedules_V
126: WHERE oks_pm_schedules_v.id = p_id;
127: l_oks_pm_schedules_v_pk oks_pm_schedules_v_pk_csr%ROWTYPE;
128: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
131: -- Get current database values
124: REQUEST_ID
125: FROM Oks_Pm_Schedules_V
126: WHERE oks_pm_schedules_v.id = p_id;
127: l_oks_pm_schedules_v_pk oks_pm_schedules_v_pk_csr%ROWTYPE;
128: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_pm_schedules_v_pk_csr (p_oks_pm_schedules_v_rec.id);
128: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
129: BEGIN
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_pm_schedules_v_pk_csr (p_oks_pm_schedules_v_rec.id);
133: FETCH oks_pm_schedules_v_pk_csr INTO
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
129: BEGIN
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_pm_schedules_v_pk_csr (p_oks_pm_schedules_v_rec.id);
133: FETCH oks_pm_schedules_v_pk_csr INTO
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
130: x_no_data_found := TRUE;
131: -- Get current database values
132: OPEN oks_pm_schedules_v_pk_csr (p_oks_pm_schedules_v_rec.id);
133: FETCH oks_pm_schedules_v_pk_csr INTO
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
131: -- Get current database values
132: OPEN oks_pm_schedules_v_pk_csr (p_oks_pm_schedules_v_rec.id);
133: FETCH oks_pm_schedules_v_pk_csr INTO
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
132: OPEN oks_pm_schedules_v_pk_csr (p_oks_pm_schedules_v_rec.id);
133: FETCH oks_pm_schedules_v_pk_csr INTO
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
133: FETCH oks_pm_schedules_v_pk_csr INTO
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
134: l_oks_pm_schedules_v_rec.id,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
135: l_oks_pm_schedules_v_rec.rule_id,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
136: l_oks_pm_schedules_v_rec.pma_rule_id,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
137: l_oks_pm_schedules_v_rec.pmp_rule_id,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
138: l_oks_pm_schedules_v_rec.object_version_number,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
139: l_oks_pm_schedules_v_rec.dnz_chr_id,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
140: l_oks_pm_schedules_v_rec.cle_id,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
141: l_oks_pm_schedules_v_rec.sch_sequence,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
142: l_oks_pm_schedules_v_rec.schedule_date,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
143: l_oks_pm_schedules_v_rec.schedule_date_from,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
144: l_oks_pm_schedules_v_rec.schedule_date_to,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
145: l_oks_pm_schedules_v_rec.created_by,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
146: l_oks_pm_schedules_v_rec.creation_date,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
147: l_oks_pm_schedules_v_rec.last_updated_by,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
148: l_oks_pm_schedules_v_rec.last_update_date,
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
149: l_oks_pm_schedules_v_rec.last_update_login,
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
150: l_oks_pm_schedules_v_rec.activity_line_id,
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
158: CLOSE oks_pm_schedules_v_pk_csr;
151: l_oks_pm_schedules_v_rec.stream_line_id,
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
158: CLOSE oks_pm_schedules_v_pk_csr;
159: RETURN(l_oks_pm_schedules_v_rec);
152: l_oks_pm_schedules_v_rec.security_group_id,
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
158: CLOSE oks_pm_schedules_v_pk_csr;
159: RETURN(l_oks_pm_schedules_v_rec);
160: END get_rec;
153: l_oks_pm_schedules_v_rec.program_application_id,
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
158: CLOSE oks_pm_schedules_v_pk_csr;
159: RETURN(l_oks_pm_schedules_v_rec);
160: END get_rec;
161:
154: l_oks_pm_schedules_v_rec.program_id,
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
158: CLOSE oks_pm_schedules_v_pk_csr;
159: RETURN(l_oks_pm_schedules_v_rec);
160: END get_rec;
161:
162: ------------------------------------------------------------------
155: l_oks_pm_schedules_v_rec.program_update_date,
156: l_oks_pm_schedules_v_rec.request_id;
157: x_no_data_found := oks_pm_schedules_v_pk_csr%NOTFOUND;
158: CLOSE oks_pm_schedules_v_pk_csr;
159: RETURN(l_oks_pm_schedules_v_rec);
160: END get_rec;
161:
162: ------------------------------------------------------------------
163: -- This version of get_rec sets error messages if no data found --
162: ------------------------------------------------------------------
163: -- This version of get_rec sets error messages if no data found --
164: ------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN oks_pm_schedules_v_rec_type IS
169: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
164: ------------------------------------------------------------------
165: FUNCTION get_rec (
166: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN oks_pm_schedules_v_rec_type IS
169: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
165: FUNCTION get_rec (
166: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
167: x_return_status OUT NOCOPY VARCHAR2
168: ) RETURN oks_pm_schedules_v_rec_type IS
169: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
173: l_oks_pm_schedules_v_rec := get_rec(p_oks_pm_schedules_v_rec, l_row_notfound);
169: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
170: l_row_notfound BOOLEAN := TRUE;
171: BEGIN
172: x_return_status := OKC_API.G_RET_STS_SUCCESS;
173: l_oks_pm_schedules_v_rec := get_rec(p_oks_pm_schedules_v_rec, l_row_notfound);
174: IF (l_row_notfound) THEN
175: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
176: x_return_status := OKC_API.G_RET_STS_ERROR;
177: END IF;
174: IF (l_row_notfound) THEN
175: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
176: x_return_status := OKC_API.G_RET_STS_ERROR;
177: END IF;
178: RETURN(l_oks_pm_schedules_v_rec);
179: END get_rec;
180: -----------------------------------------------------------
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
180: -----------------------------------------------------------
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
183: FUNCTION get_rec (
184: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
185: ) RETURN oks_pm_schedules_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_oks_pm_schedules_v_rec, l_row_not_found));
181: -- So we don't have to pass an "l_row_notfound" variable --
182: -----------------------------------------------------------
183: FUNCTION get_rec (
184: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
185: ) RETURN oks_pm_schedules_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_oks_pm_schedules_v_rec, l_row_not_found));
189: END get_rec;
184: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
185: ) RETURN oks_pm_schedules_v_rec_type IS
186: l_row_not_found BOOLEAN := TRUE;
187: BEGIN
188: RETURN(get_rec(p_oks_pm_schedules_v_rec, l_row_not_found));
189: END get_rec;
190: ---------------------------------------------------------------------------
191: -- FUNCTION get_rec for: OKS_PM_SCHEDULES
192: ---------------------------------------------------------------------------
282: BEGIN
283: RETURN(get_rec(p_oks_pm_schedules_rec, l_row_not_found));
284: END get_rec;
285: ---------------------------------------------------------------------------
286: -- FUNCTION null_out_defaults for: OKS_PM_SCHEDULES_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
290: ) RETURN oks_pm_schedules_v_rec_type IS
285: ---------------------------------------------------------------------------
286: -- FUNCTION null_out_defaults for: OKS_PM_SCHEDULES_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
290: ) RETURN oks_pm_schedules_v_rec_type IS
291: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
292: BEGIN
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
286: -- FUNCTION null_out_defaults for: OKS_PM_SCHEDULES_V
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
290: ) RETURN oks_pm_schedules_v_rec_type IS
291: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
292: BEGIN
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_pm_schedules_v_rec.id := NULL;
287: ---------------------------------------------------------------------------
288: FUNCTION null_out_defaults (
289: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
290: ) RETURN oks_pm_schedules_v_rec_type IS
291: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
292: BEGIN
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_pm_schedules_v_rec.id := NULL;
295: END IF;
289: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
290: ) RETURN oks_pm_schedules_v_rec_type IS
291: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
292: BEGIN
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_pm_schedules_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_pm_schedules_v_rec.rule_id := NULL;
290: ) RETURN oks_pm_schedules_v_rec_type IS
291: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
292: BEGIN
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_pm_schedules_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_pm_schedules_v_rec.rule_id := NULL;
298: END IF;
292: BEGIN
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_pm_schedules_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_pm_schedules_v_rec.rule_id := NULL;
298: END IF;
299: IF (l_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_pm_schedules_v_rec.pma_rule_id := NULL;
293: IF (l_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
294: l_oks_pm_schedules_v_rec.id := NULL;
295: END IF;
296: IF (l_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_pm_schedules_v_rec.rule_id := NULL;
298: END IF;
299: IF (l_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_pm_schedules_v_rec.pma_rule_id := NULL;
301: END IF;
295: END IF;
296: IF (l_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_pm_schedules_v_rec.rule_id := NULL;
298: END IF;
299: IF (l_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_pm_schedules_v_rec.pma_rule_id := NULL;
301: END IF;
302: IF (l_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_pm_schedules_v_rec.pmp_rule_id := NULL;
296: IF (l_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM ) THEN
297: l_oks_pm_schedules_v_rec.rule_id := NULL;
298: END IF;
299: IF (l_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_pm_schedules_v_rec.pma_rule_id := NULL;
301: END IF;
302: IF (l_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_pm_schedules_v_rec.pmp_rule_id := NULL;
304: END IF;
298: END IF;
299: IF (l_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_pm_schedules_v_rec.pma_rule_id := NULL;
301: END IF;
302: IF (l_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_pm_schedules_v_rec.pmp_rule_id := NULL;
304: END IF;
305: IF (l_oks_pm_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
306: l_oks_pm_schedules_v_rec.object_version_number := NULL;
299: IF (l_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM ) THEN
300: l_oks_pm_schedules_v_rec.pma_rule_id := NULL;
301: END IF;
302: IF (l_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_pm_schedules_v_rec.pmp_rule_id := NULL;
304: END IF;
305: IF (l_oks_pm_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
306: l_oks_pm_schedules_v_rec.object_version_number := NULL;
307: END IF;
301: END IF;
302: IF (l_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_pm_schedules_v_rec.pmp_rule_id := NULL;
304: END IF;
305: IF (l_oks_pm_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
306: l_oks_pm_schedules_v_rec.object_version_number := NULL;
307: END IF;
308: IF (l_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_pm_schedules_v_rec.dnz_chr_id := NULL;
302: IF (l_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM ) THEN
303: l_oks_pm_schedules_v_rec.pmp_rule_id := NULL;
304: END IF;
305: IF (l_oks_pm_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
306: l_oks_pm_schedules_v_rec.object_version_number := NULL;
307: END IF;
308: IF (l_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_pm_schedules_v_rec.dnz_chr_id := NULL;
310: END IF;
304: END IF;
305: IF (l_oks_pm_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
306: l_oks_pm_schedules_v_rec.object_version_number := NULL;
307: END IF;
308: IF (l_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_pm_schedules_v_rec.dnz_chr_id := NULL;
310: END IF;
311: IF (l_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
312: l_oks_pm_schedules_v_rec.cle_id := NULL;
305: IF (l_oks_pm_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
306: l_oks_pm_schedules_v_rec.object_version_number := NULL;
307: END IF;
308: IF (l_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_pm_schedules_v_rec.dnz_chr_id := NULL;
310: END IF;
311: IF (l_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
312: l_oks_pm_schedules_v_rec.cle_id := NULL;
313: END IF;
307: END IF;
308: IF (l_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_pm_schedules_v_rec.dnz_chr_id := NULL;
310: END IF;
311: IF (l_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
312: l_oks_pm_schedules_v_rec.cle_id := NULL;
313: END IF;
314: IF (l_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM ) THEN
315: l_oks_pm_schedules_v_rec.sch_sequence := NULL;
308: IF (l_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
309: l_oks_pm_schedules_v_rec.dnz_chr_id := NULL;
310: END IF;
311: IF (l_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
312: l_oks_pm_schedules_v_rec.cle_id := NULL;
313: END IF;
314: IF (l_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM ) THEN
315: l_oks_pm_schedules_v_rec.sch_sequence := NULL;
316: END IF;
310: END IF;
311: IF (l_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
312: l_oks_pm_schedules_v_rec.cle_id := NULL;
313: END IF;
314: IF (l_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM ) THEN
315: l_oks_pm_schedules_v_rec.sch_sequence := NULL;
316: END IF;
317: IF (l_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE ) THEN
318: l_oks_pm_schedules_v_rec.schedule_date := NULL;
311: IF (l_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
312: l_oks_pm_schedules_v_rec.cle_id := NULL;
313: END IF;
314: IF (l_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM ) THEN
315: l_oks_pm_schedules_v_rec.sch_sequence := NULL;
316: END IF;
317: IF (l_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE ) THEN
318: l_oks_pm_schedules_v_rec.schedule_date := NULL;
319: END IF;
313: END IF;
314: IF (l_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM ) THEN
315: l_oks_pm_schedules_v_rec.sch_sequence := NULL;
316: END IF;
317: IF (l_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE ) THEN
318: l_oks_pm_schedules_v_rec.schedule_date := NULL;
319: END IF;
320: IF (l_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE ) THEN
321: l_oks_pm_schedules_v_rec.schedule_date_from := NULL;
314: IF (l_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM ) THEN
315: l_oks_pm_schedules_v_rec.sch_sequence := NULL;
316: END IF;
317: IF (l_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE ) THEN
318: l_oks_pm_schedules_v_rec.schedule_date := NULL;
319: END IF;
320: IF (l_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE ) THEN
321: l_oks_pm_schedules_v_rec.schedule_date_from := NULL;
322: END IF;
316: END IF;
317: IF (l_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE ) THEN
318: l_oks_pm_schedules_v_rec.schedule_date := NULL;
319: END IF;
320: IF (l_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE ) THEN
321: l_oks_pm_schedules_v_rec.schedule_date_from := NULL;
322: END IF;
323: IF (l_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE ) THEN
324: l_oks_pm_schedules_v_rec.schedule_date_to := NULL;
317: IF (l_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE ) THEN
318: l_oks_pm_schedules_v_rec.schedule_date := NULL;
319: END IF;
320: IF (l_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE ) THEN
321: l_oks_pm_schedules_v_rec.schedule_date_from := NULL;
322: END IF;
323: IF (l_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE ) THEN
324: l_oks_pm_schedules_v_rec.schedule_date_to := NULL;
325: END IF;
319: END IF;
320: IF (l_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE ) THEN
321: l_oks_pm_schedules_v_rec.schedule_date_from := NULL;
322: END IF;
323: IF (l_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE ) THEN
324: l_oks_pm_schedules_v_rec.schedule_date_to := NULL;
325: END IF;
326: IF (l_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
327: l_oks_pm_schedules_v_rec.created_by := NULL;
320: IF (l_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE ) THEN
321: l_oks_pm_schedules_v_rec.schedule_date_from := NULL;
322: END IF;
323: IF (l_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE ) THEN
324: l_oks_pm_schedules_v_rec.schedule_date_to := NULL;
325: END IF;
326: IF (l_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
327: l_oks_pm_schedules_v_rec.created_by := NULL;
328: END IF;
322: END IF;
323: IF (l_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE ) THEN
324: l_oks_pm_schedules_v_rec.schedule_date_to := NULL;
325: END IF;
326: IF (l_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
327: l_oks_pm_schedules_v_rec.created_by := NULL;
328: END IF;
329: IF (l_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
330: l_oks_pm_schedules_v_rec.creation_date := NULL;
323: IF (l_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE ) THEN
324: l_oks_pm_schedules_v_rec.schedule_date_to := NULL;
325: END IF;
326: IF (l_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
327: l_oks_pm_schedules_v_rec.created_by := NULL;
328: END IF;
329: IF (l_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
330: l_oks_pm_schedules_v_rec.creation_date := NULL;
331: END IF;
325: END IF;
326: IF (l_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
327: l_oks_pm_schedules_v_rec.created_by := NULL;
328: END IF;
329: IF (l_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
330: l_oks_pm_schedules_v_rec.creation_date := NULL;
331: END IF;
332: IF (l_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
333: l_oks_pm_schedules_v_rec.last_updated_by := NULL;
326: IF (l_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
327: l_oks_pm_schedules_v_rec.created_by := NULL;
328: END IF;
329: IF (l_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
330: l_oks_pm_schedules_v_rec.creation_date := NULL;
331: END IF;
332: IF (l_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
333: l_oks_pm_schedules_v_rec.last_updated_by := NULL;
334: END IF;
328: END IF;
329: IF (l_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
330: l_oks_pm_schedules_v_rec.creation_date := NULL;
331: END IF;
332: IF (l_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
333: l_oks_pm_schedules_v_rec.last_updated_by := NULL;
334: END IF;
335: IF (l_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
336: l_oks_pm_schedules_v_rec.last_update_date := NULL;
329: IF (l_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
330: l_oks_pm_schedules_v_rec.creation_date := NULL;
331: END IF;
332: IF (l_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
333: l_oks_pm_schedules_v_rec.last_updated_by := NULL;
334: END IF;
335: IF (l_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
336: l_oks_pm_schedules_v_rec.last_update_date := NULL;
337: END IF;
331: END IF;
332: IF (l_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
333: l_oks_pm_schedules_v_rec.last_updated_by := NULL;
334: END IF;
335: IF (l_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
336: l_oks_pm_schedules_v_rec.last_update_date := NULL;
337: END IF;
338: IF (l_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
339: l_oks_pm_schedules_v_rec.last_update_login := NULL;
332: IF (l_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
333: l_oks_pm_schedules_v_rec.last_updated_by := NULL;
334: END IF;
335: IF (l_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
336: l_oks_pm_schedules_v_rec.last_update_date := NULL;
337: END IF;
338: IF (l_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
339: l_oks_pm_schedules_v_rec.last_update_login := NULL;
340: END IF;
334: END IF;
335: IF (l_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
336: l_oks_pm_schedules_v_rec.last_update_date := NULL;
337: END IF;
338: IF (l_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
339: l_oks_pm_schedules_v_rec.last_update_login := NULL;
340: END IF;
341: IF (l_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_pm_schedules_v_rec.activity_line_id := NULL;
335: IF (l_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
336: l_oks_pm_schedules_v_rec.last_update_date := NULL;
337: END IF;
338: IF (l_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
339: l_oks_pm_schedules_v_rec.last_update_login := NULL;
340: END IF;
341: IF (l_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_pm_schedules_v_rec.activity_line_id := NULL;
343: END IF;
337: END IF;
338: IF (l_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
339: l_oks_pm_schedules_v_rec.last_update_login := NULL;
340: END IF;
341: IF (l_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_pm_schedules_v_rec.activity_line_id := NULL;
343: END IF;
344: IF (l_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM ) THEN
345: l_oks_pm_schedules_v_rec.stream_line_id := NULL;
338: IF (l_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
339: l_oks_pm_schedules_v_rec.last_update_login := NULL;
340: END IF;
341: IF (l_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_pm_schedules_v_rec.activity_line_id := NULL;
343: END IF;
344: IF (l_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM ) THEN
345: l_oks_pm_schedules_v_rec.stream_line_id := NULL;
346: END IF;
340: END IF;
341: IF (l_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_pm_schedules_v_rec.activity_line_id := NULL;
343: END IF;
344: IF (l_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM ) THEN
345: l_oks_pm_schedules_v_rec.stream_line_id := NULL;
346: END IF;
347: IF (l_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
348: l_oks_pm_schedules_v_rec.security_group_id := NULL;
341: IF (l_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM ) THEN
342: l_oks_pm_schedules_v_rec.activity_line_id := NULL;
343: END IF;
344: IF (l_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM ) THEN
345: l_oks_pm_schedules_v_rec.stream_line_id := NULL;
346: END IF;
347: IF (l_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
348: l_oks_pm_schedules_v_rec.security_group_id := NULL;
349: END IF;
343: END IF;
344: IF (l_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM ) THEN
345: l_oks_pm_schedules_v_rec.stream_line_id := NULL;
346: END IF;
347: IF (l_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
348: l_oks_pm_schedules_v_rec.security_group_id := NULL;
349: END IF;
350: IF (l_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
351: l_oks_pm_schedules_v_rec.program_application_id := NULL;
344: IF (l_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM ) THEN
345: l_oks_pm_schedules_v_rec.stream_line_id := NULL;
346: END IF;
347: IF (l_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
348: l_oks_pm_schedules_v_rec.security_group_id := NULL;
349: END IF;
350: IF (l_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
351: l_oks_pm_schedules_v_rec.program_application_id := NULL;
352: END IF;
346: END IF;
347: IF (l_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
348: l_oks_pm_schedules_v_rec.security_group_id := NULL;
349: END IF;
350: IF (l_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
351: l_oks_pm_schedules_v_rec.program_application_id := NULL;
352: END IF;
353: IF (l_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
354: l_oks_pm_schedules_v_rec.program_id := NULL;
347: IF (l_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
348: l_oks_pm_schedules_v_rec.security_group_id := NULL;
349: END IF;
350: IF (l_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
351: l_oks_pm_schedules_v_rec.program_application_id := NULL;
352: END IF;
353: IF (l_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
354: l_oks_pm_schedules_v_rec.program_id := NULL;
355: END IF;
349: END IF;
350: IF (l_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
351: l_oks_pm_schedules_v_rec.program_application_id := NULL;
352: END IF;
353: IF (l_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
354: l_oks_pm_schedules_v_rec.program_id := NULL;
355: END IF;
356: IF (l_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
357: l_oks_pm_schedules_v_rec.program_update_date := NULL;
350: IF (l_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
351: l_oks_pm_schedules_v_rec.program_application_id := NULL;
352: END IF;
353: IF (l_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
354: l_oks_pm_schedules_v_rec.program_id := NULL;
355: END IF;
356: IF (l_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
357: l_oks_pm_schedules_v_rec.program_update_date := NULL;
358: END IF;
352: END IF;
353: IF (l_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
354: l_oks_pm_schedules_v_rec.program_id := NULL;
355: END IF;
356: IF (l_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
357: l_oks_pm_schedules_v_rec.program_update_date := NULL;
358: END IF;
359: IF (l_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
360: l_oks_pm_schedules_v_rec.request_id := NULL;
353: IF (l_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
354: l_oks_pm_schedules_v_rec.program_id := NULL;
355: END IF;
356: IF (l_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
357: l_oks_pm_schedules_v_rec.program_update_date := NULL;
358: END IF;
359: IF (l_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
360: l_oks_pm_schedules_v_rec.request_id := NULL;
361: END IF;
355: END IF;
356: IF (l_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
357: l_oks_pm_schedules_v_rec.program_update_date := NULL;
358: END IF;
359: IF (l_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
360: l_oks_pm_schedules_v_rec.request_id := NULL;
361: END IF;
362: RETURN(l_oks_pm_schedules_v_rec);
363: END null_out_defaults;
356: IF (l_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
357: l_oks_pm_schedules_v_rec.program_update_date := NULL;
358: END IF;
359: IF (l_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
360: l_oks_pm_schedules_v_rec.request_id := NULL;
361: END IF;
362: RETURN(l_oks_pm_schedules_v_rec);
363: END null_out_defaults;
364: ---------------------------------
358: END IF;
359: IF (l_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
360: l_oks_pm_schedules_v_rec.request_id := NULL;
361: END IF;
362: RETURN(l_oks_pm_schedules_v_rec);
363: END null_out_defaults;
364: ---------------------------------
365: -- Validate_Attributes for: ID --
366: ---------------------------------
391: ---------------------------------------------------------------------------
392: -- FUNCTION Validate_Attributes
393: ---------------------------------------------------------------------------
394: ------------------------------------------------
395: -- Validate_Attributes for:OKS_PM_SCHEDULES_V --
396: ------------------------------------------------
397: FUNCTION Validate_Attributes (
398: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
399: ) RETURN VARCHAR2 IS
394: ------------------------------------------------
395: -- Validate_Attributes for:OKS_PM_SCHEDULES_V --
396: ------------------------------------------------
397: FUNCTION Validate_Attributes (
398: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
399: ) RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
401: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
402: BEGIN
405: -----------------------------
406: -- ***
407: -- id
408: -- ***
409: validate_id(x_return_status, p_oks_pm_schedules_v_rec.id);
410: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
411: l_return_status := x_return_status;
412: RAISE G_EXCEPTION_HALT_VALIDATION;
413: END IF;
429: ---------------------------------------------------------------------------
430: -- PROCEDURE Validate_Record
431: ---------------------------------------------------------------------------
432: --------------------------------------------
433: -- Validate Record for:OKS_PM_SCHEDULES_V --
434: --------------------------------------------
435: FUNCTION Validate_Record (
436: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
437: p_db_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
432: --------------------------------------------
433: -- Validate Record for:OKS_PM_SCHEDULES_V --
434: --------------------------------------------
435: FUNCTION Validate_Record (
436: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
437: p_db_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
438: ) RETURN VARCHAR2 IS
439: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
440: BEGIN
433: -- Validate Record for:OKS_PM_SCHEDULES_V --
434: --------------------------------------------
435: FUNCTION Validate_Record (
436: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
437: p_db_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
438: ) RETURN VARCHAR2 IS
439: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
440: BEGIN
441: RETURN (l_return_status);
440: BEGIN
441: RETURN (l_return_status);
442: END Validate_Record;
443: FUNCTION Validate_Record (
444: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
445: ) RETURN VARCHAR2 IS
446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
447: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := get_rec(p_oks_pm_schedules_v_rec);
448: BEGIN
443: FUNCTION Validate_Record (
444: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
445: ) RETURN VARCHAR2 IS
446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
447: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := get_rec(p_oks_pm_schedules_v_rec);
448: BEGIN
449: l_return_status := Validate_Record(p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_rec,
450: p_db_oks_pm_schedules_v_rec => l_db_oks_pm_schedules_v_rec);
451: RETURN (l_return_status);
445: ) RETURN VARCHAR2 IS
446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
447: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := get_rec(p_oks_pm_schedules_v_rec);
448: BEGIN
449: l_return_status := Validate_Record(p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_rec,
450: p_db_oks_pm_schedules_v_rec => l_db_oks_pm_schedules_v_rec);
451: RETURN (l_return_status);
452: END Validate_Record;
453:
446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
447: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := get_rec(p_oks_pm_schedules_v_rec);
448: BEGIN
449: l_return_status := Validate_Record(p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_rec,
450: p_db_oks_pm_schedules_v_rec => l_db_oks_pm_schedules_v_rec);
451: RETURN (l_return_status);
452: END Validate_Record;
453:
454: ---------------------------------------------------------------------------
454: ---------------------------------------------------------------------------
455: -- PROCEDURE Migrate
456: ---------------------------------------------------------------------------
457: PROCEDURE migrate (
458: p_from IN oks_pm_schedules_v_rec_type,
459: p_to IN OUT NOCOPY oks_pm_schedules_rec_type
460: ) IS
461: BEGIN
462: p_to.id := p_from.id;
483: p_to.request_id := p_from.request_id;
484: END migrate;
485: PROCEDURE migrate (
486: p_from IN oks_pm_schedules_rec_type,
487: p_to IN OUT NOCOPY oks_pm_schedules_v_rec_type
488: ) IS
489: BEGIN
490: p_to.id := p_from.id;
491: p_to.rule_id := p_from.rule_id;
513: ---------------------------------------------------------------------------
514: -- PROCEDURE validate_row
515: ---------------------------------------------------------------------------
516: -----------------------------------------
517: -- validate_row for:OKS_PM_SCHEDULES_V --
518: -----------------------------------------
519: PROCEDURE validate_row(
520: p_api_version IN NUMBER,
521: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
521: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,
524: x_msg_data OUT NOCOPY VARCHAR2,
525: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type) IS
526:
527: l_api_version CONSTANT NUMBER := 1;
528: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
526:
527: l_api_version CONSTANT NUMBER := 1;
528: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
529: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
530: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
531: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
532: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
533: BEGIN
534: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
543: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
544: RAISE OKC_API.G_EXCEPTION_ERROR;
545: END IF;
546: --- Validate all non-missing attributes (Item Level Validation)
547: l_return_status := Validate_Attributes(l_oks_pm_schedules_v_rec);
548: --- If any errors happen abort API
549: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
550: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
551: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
550: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
551: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
552: RAISE OKC_API.G_EXCEPTION_ERROR;
553: END IF;
554: l_return_status := Validate_Record(l_oks_pm_schedules_v_rec);
555: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
556: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
557: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
558: RAISE OKC_API.G_EXCEPTION_ERROR;
590: '_PVT'
591: );
592: END validate_row;
593: ----------------------------------------------------
594: -- PL/SQL TBL validate_row for:OKS_PM_SCHEDULES_V --
595: ----------------------------------------------------
596: PROCEDURE validate_row(
597: p_api_version IN NUMBER,
598: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
598: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
599: x_return_status OUT NOCOPY VARCHAR2,
600: x_msg_count OUT NOCOPY NUMBER,
601: x_msg_data OUT NOCOPY VARCHAR2,
602: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
603: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
604:
605: l_api_version CONSTANT NUMBER := 1;
606: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
607: i NUMBER := 0;
608: BEGIN
609: OKC_API.init_msg_list(p_init_msg_list);
610: -- Make sure PL/SQL table has records in it before passing
611: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
612: i := p_oks_pm_schedules_v_tbl.FIRST;
613: LOOP
614: DECLARE
615: l_error_rec OKC_API.ERROR_REC_TYPE;
608: BEGIN
609: OKC_API.init_msg_list(p_init_msg_list);
610: -- Make sure PL/SQL table has records in it before passing
611: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
612: i := p_oks_pm_schedules_v_tbl.FIRST;
613: LOOP
614: DECLARE
615: l_error_rec OKC_API.ERROR_REC_TYPE;
616: BEGIN
622: p_init_msg_list => OKC_API.G_FALSE,
623: x_return_status => l_error_rec.error_type,
624: x_msg_count => l_error_rec.msg_count,
625: x_msg_data => l_error_rec.msg_data,
626: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i));
627: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
628: l_error_rec.sqlcode := SQLCODE;
629: load_error_tbl(l_error_rec, px_error_tbl);
630: ELSE
644: l_error_rec.error_type := 'OTHERS';
645: l_error_rec.sqlcode := SQLCODE;
646: load_error_tbl(l_error_rec, px_error_tbl);
647: END;
648: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
649: i := p_oks_pm_schedules_v_tbl.NEXT(i);
650: END LOOP;
651: END IF;
652: -- Loop through the error_tbl to find the error with the highest severity
645: l_error_rec.sqlcode := SQLCODE;
646: load_error_tbl(l_error_rec, px_error_tbl);
647: END;
648: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
649: i := p_oks_pm_schedules_v_tbl.NEXT(i);
650: END LOOP;
651: END IF;
652: -- Loop through the error_tbl to find the error with the highest severity
653: -- and return it.
686: );
687: END validate_row;
688:
689: ----------------------------------------------------
690: -- PL/SQL TBL validate_row for:OKS_PM_SCHEDULES_V --
691: ----------------------------------------------------
692: PROCEDURE validate_row(
693: p_api_version IN NUMBER,
694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
694: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
695: x_return_status OUT NOCOPY VARCHAR2,
696: x_msg_count OUT NOCOPY NUMBER,
697: x_msg_data OUT NOCOPY VARCHAR2,
698: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type) IS
699:
700: l_api_version CONSTANT NUMBER := 1;
701: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
702: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
703: l_error_tbl OKC_API.ERROR_TBL_TYPE;
704: BEGIN
705: OKC_API.init_msg_list(p_init_msg_list);
706: -- Make sure PL/SQL table has records in it before passing
707: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
708: validate_row (
709: p_api_version => p_api_version,
710: p_init_msg_list => OKC_API.G_FALSE,
711: x_return_status => x_return_status,
710: p_init_msg_list => OKC_API.G_FALSE,
711: x_return_status => x_return_status,
712: x_msg_count => x_msg_count,
713: x_msg_data => x_msg_data,
714: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
715: px_error_tbl => l_error_tbl);
716: END IF;
717: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
718: EXCEPTION
881: '_PVT'
882: );
883: END insert_row;
884: ----------------------------------------
885: -- insert_row for :OKS_PM_SCHEDULES_V --
886: ----------------------------------------
887: PROCEDURE insert_row(
888: p_api_version IN NUMBER,
889: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
889: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
890: x_return_status OUT NOCOPY VARCHAR2,
891: x_msg_count OUT NOCOPY NUMBER,
892: x_msg_data OUT NOCOPY VARCHAR2,
893: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
894: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type) IS
895:
896: l_api_version CONSTANT NUMBER := 1;
897: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
890: x_return_status OUT NOCOPY VARCHAR2,
891: x_msg_count OUT NOCOPY NUMBER,
892: x_msg_data OUT NOCOPY VARCHAR2,
893: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
894: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type) IS
895:
896: l_api_version CONSTANT NUMBER := 1;
897: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
898: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
895:
896: l_api_version CONSTANT NUMBER := 1;
897: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
898: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
899: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
900: l_def_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
901: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
902: lx_oks_pm_schedules_rec oks_pm_schedules_rec_type;
903: -------------------------------
896: l_api_version CONSTANT NUMBER := 1;
897: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
898: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
899: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
900: l_def_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
901: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
902: lx_oks_pm_schedules_rec oks_pm_schedules_rec_type;
903: -------------------------------
904: -- FUNCTION fill_who_columns --
903: -------------------------------
904: -- FUNCTION fill_who_columns --
905: -------------------------------
906: FUNCTION fill_who_columns (
907: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
908: ) RETURN oks_pm_schedules_v_rec_type IS
909: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
904: -- FUNCTION fill_who_columns --
905: -------------------------------
906: FUNCTION fill_who_columns (
907: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
908: ) RETURN oks_pm_schedules_v_rec_type IS
909: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
905: -------------------------------
906: FUNCTION fill_who_columns (
907: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
908: ) RETURN oks_pm_schedules_v_rec_type IS
909: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
907: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
908: ) RETURN oks_pm_schedules_v_rec_type IS
909: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
914: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
908: ) RETURN oks_pm_schedules_v_rec_type IS
909: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
914: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
916: RETURN(l_oks_pm_schedules_v_rec);
909: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
914: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
916: RETURN(l_oks_pm_schedules_v_rec);
917: END fill_who_columns;
910: BEGIN
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
914: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
916: RETURN(l_oks_pm_schedules_v_rec);
917: END fill_who_columns;
918: -------------------------------------------
911: l_oks_pm_schedules_v_rec.CREATION_DATE := SYSDATE;
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
914: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
916: RETURN(l_oks_pm_schedules_v_rec);
917: END fill_who_columns;
918: -------------------------------------------
919: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
912: l_oks_pm_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
913: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := l_oks_pm_schedules_v_rec.CREATION_DATE;
914: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
916: RETURN(l_oks_pm_schedules_v_rec);
917: END fill_who_columns;
918: -------------------------------------------
919: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
920: -------------------------------------------
915: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
916: RETURN(l_oks_pm_schedules_v_rec);
917: END fill_who_columns;
918: -------------------------------------------
919: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
920: -------------------------------------------
921: FUNCTION Set_Attributes (
922: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
923: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
918: -------------------------------------------
919: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
920: -------------------------------------------
921: FUNCTION Set_Attributes (
922: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
923: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
924: ) RETURN VARCHAR2 IS
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: BEGIN
919: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
920: -------------------------------------------
921: FUNCTION Set_Attributes (
922: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
923: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
924: ) RETURN VARCHAR2 IS
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: BEGIN
927: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
923: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
924: ) RETURN VARCHAR2 IS
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: BEGIN
927: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
928: x_oks_pm_schedules_v_rec.OBJECT_VERSION_NUMBER := 1;
929: RETURN(l_return_status);
930: END Set_Attributes;
931: BEGIN
924: ) RETURN VARCHAR2 IS
925: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
926: BEGIN
927: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
928: x_oks_pm_schedules_v_rec.OBJECT_VERSION_NUMBER := 1;
929: RETURN(l_return_status);
930: END Set_Attributes;
931: BEGIN
932: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
941: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
942: RAISE OKC_API.G_EXCEPTION_ERROR;
943: END IF;
944: l_oks_pm_schedules_v_rec := null_out_defaults(p_oks_pm_schedules_v_rec);
945: -- Set primary key value
946: l_oks_pm_schedules_v_rec.ID := get_seq_id;
947: -- Setting item attributes
948: l_return_Status := Set_Attributes(
942: RAISE OKC_API.G_EXCEPTION_ERROR;
943: END IF;
944: l_oks_pm_schedules_v_rec := null_out_defaults(p_oks_pm_schedules_v_rec);
945: -- Set primary key value
946: l_oks_pm_schedules_v_rec.ID := get_seq_id;
947: -- Setting item attributes
948: l_return_Status := Set_Attributes(
949: l_oks_pm_schedules_v_rec,
950: l_def_oks_pm_schedules_v_rec);
945: -- Set primary key value
946: l_oks_pm_schedules_v_rec.ID := get_seq_id;
947: -- Setting item attributes
948: l_return_Status := Set_Attributes(
949: l_oks_pm_schedules_v_rec,
950: l_def_oks_pm_schedules_v_rec);
951: --- If any errors happen abort API
952: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
946: l_oks_pm_schedules_v_rec.ID := get_seq_id;
947: -- Setting item attributes
948: l_return_Status := Set_Attributes(
949: l_oks_pm_schedules_v_rec,
950: l_def_oks_pm_schedules_v_rec);
951: --- If any errors happen abort API
952: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
954: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
954: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
955: RAISE OKC_API.G_EXCEPTION_ERROR;
956: END IF;
957: l_def_oks_pm_schedules_v_rec := fill_who_columns(l_def_oks_pm_schedules_v_rec);
958: --- Validate all non-missing attributes (Item Level Validation)
959: l_return_status := Validate_Attributes(l_def_oks_pm_schedules_v_rec);
960: --- If any errors happen abort API
961: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
955: RAISE OKC_API.G_EXCEPTION_ERROR;
956: END IF;
957: l_def_oks_pm_schedules_v_rec := fill_who_columns(l_def_oks_pm_schedules_v_rec);
958: --- Validate all non-missing attributes (Item Level Validation)
959: l_return_status := Validate_Attributes(l_def_oks_pm_schedules_v_rec);
960: --- If any errors happen abort API
961: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
963: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
963: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
964: RAISE OKC_API.G_EXCEPTION_ERROR;
965: END IF;
966: l_return_status := Validate_Record(l_def_oks_pm_schedules_v_rec);
967: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
969: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
970: RAISE OKC_API.G_EXCEPTION_ERROR;
971: END IF;
972: -----------------------------------------
973: -- Move VIEW record to "Child" records --
974: -----------------------------------------
975: migrate(l_def_oks_pm_schedules_v_rec, l_oks_pm_schedules_rec);
976: -----------------------------------------------
977: -- Call the INSERT_ROW for each child record --
978: -----------------------------------------------
979: insert_row(
988: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
989: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
990: RAISE OKC_API.G_EXCEPTION_ERROR;
991: END IF;
992: migrate(lx_oks_pm_schedules_rec, l_def_oks_pm_schedules_v_rec);
993: -- Set values
994: x_oks_pm_schedules_v_rec := l_def_oks_pm_schedules_v_rec;
995: x_return_status := l_return_status;
996: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
990: RAISE OKC_API.G_EXCEPTION_ERROR;
991: END IF;
992: migrate(lx_oks_pm_schedules_rec, l_def_oks_pm_schedules_v_rec);
993: -- Set values
994: x_oks_pm_schedules_v_rec := l_def_oks_pm_schedules_v_rec;
995: x_return_status := l_return_status;
996: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
997: EXCEPTION
998: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1026: '_PVT'
1027: );
1028: END insert_row;
1029: ------------------------------------------------------
1030: -- PL/SQL TBL insert_row for:OKS_PM_SCHEDULES_V_TBL --
1031: ------------------------------------------------------
1032: PROCEDURE insert_row(
1033: p_api_version IN NUMBER,
1034: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1034: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1035: x_return_status OUT NOCOPY VARCHAR2,
1036: x_msg_count OUT NOCOPY NUMBER,
1037: x_msg_data OUT NOCOPY VARCHAR2,
1038: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
1039: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type,
1040: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1041:
1042: l_api_version CONSTANT NUMBER := 1;
1035: x_return_status OUT NOCOPY VARCHAR2,
1036: x_msg_count OUT NOCOPY NUMBER,
1037: x_msg_data OUT NOCOPY VARCHAR2,
1038: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
1039: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type,
1040: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1041:
1042: l_api_version CONSTANT NUMBER := 1;
1043: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1044: i NUMBER := 0;
1045: BEGIN
1046: OKC_API.init_msg_list(p_init_msg_list);
1047: -- Make sure PL/SQL table has records in it before passing
1048: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
1049: i := p_oks_pm_schedules_v_tbl.FIRST;
1050: LOOP
1051: DECLARE
1052: l_error_rec OKC_API.ERROR_REC_TYPE;
1045: BEGIN
1046: OKC_API.init_msg_list(p_init_msg_list);
1047: -- Make sure PL/SQL table has records in it before passing
1048: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
1049: i := p_oks_pm_schedules_v_tbl.FIRST;
1050: LOOP
1051: DECLARE
1052: l_error_rec OKC_API.ERROR_REC_TYPE;
1053: BEGIN
1059: p_init_msg_list => OKC_API.G_FALSE,
1060: x_return_status => l_error_rec.error_type,
1061: x_msg_count => l_error_rec.msg_count,
1062: x_msg_data => l_error_rec.msg_data,
1063: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i),
1064: x_oks_pm_schedules_v_rec => x_oks_pm_schedules_v_tbl(i));
1065: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1066: l_error_rec.sqlcode := SQLCODE;
1067: load_error_tbl(l_error_rec, px_error_tbl);
1060: x_return_status => l_error_rec.error_type,
1061: x_msg_count => l_error_rec.msg_count,
1062: x_msg_data => l_error_rec.msg_data,
1063: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i),
1064: x_oks_pm_schedules_v_rec => x_oks_pm_schedules_v_tbl(i));
1065: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1066: l_error_rec.sqlcode := SQLCODE;
1067: load_error_tbl(l_error_rec, px_error_tbl);
1068: ELSE
1082: l_error_rec.error_type := 'OTHERS';
1083: l_error_rec.sqlcode := SQLCODE;
1084: load_error_tbl(l_error_rec, px_error_tbl);
1085: END;
1086: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
1087: i := p_oks_pm_schedules_v_tbl.NEXT(i);
1088: END LOOP;
1089: END IF;
1090: -- Loop through the error_tbl to find the error with the highest severity
1083: l_error_rec.sqlcode := SQLCODE;
1084: load_error_tbl(l_error_rec, px_error_tbl);
1085: END;
1086: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
1087: i := p_oks_pm_schedules_v_tbl.NEXT(i);
1088: END LOOP;
1089: END IF;
1090: -- Loop through the error_tbl to find the error with the highest severity
1091: -- and return it.
1124: );
1125: END insert_row;
1126:
1127: ------------------------------------------------------
1128: -- PL/SQL TBL insert_row for:OKS_PM_SCHEDULES_V_TBL --
1129: ------------------------------------------------------
1130: PROCEDURE insert_row(
1131: p_api_version IN NUMBER,
1132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1133: x_return_status OUT NOCOPY VARCHAR2,
1134: x_msg_count OUT NOCOPY NUMBER,
1135: x_msg_data OUT NOCOPY VARCHAR2,
1136: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
1137: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type) IS
1138:
1139: l_api_version CONSTANT NUMBER := 1;
1140: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1133: x_return_status OUT NOCOPY VARCHAR2,
1134: x_msg_count OUT NOCOPY NUMBER,
1135: x_msg_data OUT NOCOPY VARCHAR2,
1136: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
1137: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type) IS
1138:
1139: l_api_version CONSTANT NUMBER := 1;
1140: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1141: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1142: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1143: BEGIN
1144: OKC_API.init_msg_list(p_init_msg_list);
1145: -- Make sure PL/SQL table has records in it before passing
1146: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
1147: insert_row (
1148: p_api_version => p_api_version,
1149: p_init_msg_list => OKC_API.G_FALSE,
1150: x_return_status => x_return_status,
1149: p_init_msg_list => OKC_API.G_FALSE,
1150: x_return_status => x_return_status,
1151: x_msg_count => x_msg_count,
1152: x_msg_data => x_msg_data,
1153: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
1154: x_oks_pm_schedules_v_tbl => x_oks_pm_schedules_v_tbl,
1155: px_error_tbl => l_error_tbl);
1156: END IF;
1157: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1150: x_return_status => x_return_status,
1151: x_msg_count => x_msg_count,
1152: x_msg_data => x_msg_data,
1153: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
1154: x_oks_pm_schedules_v_tbl => x_oks_pm_schedules_v_tbl,
1155: px_error_tbl => l_error_tbl);
1156: END IF;
1157: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1158: EXCEPTION
1298: '_PVT'
1299: );
1300: END lock_row;
1301: --------------------------------------
1302: -- lock_row for: OKS_PM_SCHEDULES_V --
1303: --------------------------------------
1304: PROCEDURE lock_row(
1305: p_api_version IN NUMBER,
1306: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1306: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1307: x_return_status OUT NOCOPY VARCHAR2,
1308: x_msg_count OUT NOCOPY NUMBER,
1309: x_msg_data OUT NOCOPY VARCHAR2,
1310: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type) IS
1311:
1312: l_api_version CONSTANT NUMBER := 1;
1313: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1314: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1328: END IF;
1329: -----------------------------------------
1330: -- Move VIEW record to "Child" records --
1331: -----------------------------------------
1332: migrate(p_oks_pm_schedules_v_rec, l_oks_pm_schedules_rec);
1333: ---------------------------------------------
1334: -- Call the LOCK_ROW for each child record --
1335: ---------------------------------------------
1336: lock_row(
1379: '_PVT'
1380: );
1381: END lock_row;
1382: ----------------------------------------------------
1383: -- PL/SQL TBL lock_row for:OKS_PM_SCHEDULES_V_TBL --
1384: ----------------------------------------------------
1385: PROCEDURE lock_row(
1386: p_api_version IN NUMBER,
1387: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1387: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1388: x_return_status OUT NOCOPY VARCHAR2,
1389: x_msg_count OUT NOCOPY NUMBER,
1390: x_msg_data OUT NOCOPY VARCHAR2,
1391: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
1392: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1393:
1394: l_api_version CONSTANT NUMBER := 1;
1395: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1396: i NUMBER := 0;
1397: BEGIN
1398: OKC_API.init_msg_list(p_init_msg_list);
1399: -- Make sure PL/SQL table has recrods in it before passing
1400: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
1401: i := p_oks_pm_schedules_v_tbl.FIRST;
1402: LOOP
1403: DECLARE
1404: l_error_rec OKC_API.ERROR_REC_TYPE;
1397: BEGIN
1398: OKC_API.init_msg_list(p_init_msg_list);
1399: -- Make sure PL/SQL table has recrods in it before passing
1400: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
1401: i := p_oks_pm_schedules_v_tbl.FIRST;
1402: LOOP
1403: DECLARE
1404: l_error_rec OKC_API.ERROR_REC_TYPE;
1405: BEGIN
1411: p_init_msg_list => OKC_API.G_FALSE,
1412: x_return_status => l_error_rec.error_type,
1413: x_msg_count => l_error_rec.msg_count,
1414: x_msg_data => l_error_rec.msg_data,
1415: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i));
1416: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1417: l_error_rec.sqlcode := SQLCODE;
1418: load_error_tbl(l_error_rec, px_error_tbl);
1419: ELSE
1433: l_error_rec.error_type := 'OTHERS';
1434: l_error_rec.sqlcode := SQLCODE;
1435: load_error_tbl(l_error_rec, px_error_tbl);
1436: END;
1437: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
1438: i := p_oks_pm_schedules_v_tbl.NEXT(i);
1439: END LOOP;
1440: END IF;
1441: -- Loop through the error_tbl to find the error with the highest severity
1434: l_error_rec.sqlcode := SQLCODE;
1435: load_error_tbl(l_error_rec, px_error_tbl);
1436: END;
1437: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
1438: i := p_oks_pm_schedules_v_tbl.NEXT(i);
1439: END LOOP;
1440: END IF;
1441: -- Loop through the error_tbl to find the error with the highest severity
1442: -- and return it.
1474: '_PVT'
1475: );
1476: END lock_row;
1477: ----------------------------------------------------
1478: -- PL/SQL TBL lock_row for:OKS_PM_SCHEDULES_V_TBL --
1479: ----------------------------------------------------
1480: PROCEDURE lock_row(
1481: p_api_version IN NUMBER,
1482: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1482: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1483: x_return_status OUT NOCOPY VARCHAR2,
1484: x_msg_count OUT NOCOPY NUMBER,
1485: x_msg_data OUT NOCOPY VARCHAR2,
1486: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type) IS
1487:
1488: l_api_version CONSTANT NUMBER := 1;
1489: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1491: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1492: BEGIN
1493: OKC_API.init_msg_list(p_init_msg_list);
1494: -- Make sure PL/SQL table has recrods in it before passing
1495: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
1496: lock_row(
1497: p_api_version => p_api_version,
1498: p_init_msg_list => OKC_API.G_FALSE,
1499: x_return_status => x_return_status,
1498: p_init_msg_list => OKC_API.G_FALSE,
1499: x_return_status => x_return_status,
1500: x_msg_count => x_msg_count,
1501: x_msg_data => x_msg_data,
1502: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
1503: px_error_tbl => l_error_tbl);
1504: END IF;
1505: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1506: EXCEPTION
1759: '_PVT'
1760: );
1761: END update_row;
1762: ---------------------------------------
1763: -- update_row for:OKS_PM_SCHEDULES_V --
1764: ---------------------------------------
1765: PROCEDURE update_row(
1766: p_api_version IN NUMBER,
1767: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1767: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1768: x_return_status OUT NOCOPY VARCHAR2,
1769: x_msg_count OUT NOCOPY NUMBER,
1770: x_msg_data OUT NOCOPY VARCHAR2,
1771: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1772: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type) IS
1773:
1774: l_api_version CONSTANT NUMBER := 1;
1775: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1768: x_return_status OUT NOCOPY VARCHAR2,
1769: x_msg_count OUT NOCOPY NUMBER,
1770: x_msg_data OUT NOCOPY VARCHAR2,
1771: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1772: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type) IS
1773:
1774: l_api_version CONSTANT NUMBER := 1;
1775: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1773:
1774: l_api_version CONSTANT NUMBER := 1;
1775: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1777: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1778: l_def_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
1779: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
1780: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
1781: lx_oks_pm_schedules_rec oks_pm_schedules_rec_type;
1774: l_api_version CONSTANT NUMBER := 1;
1775: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1777: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1778: l_def_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
1779: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
1780: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
1781: lx_oks_pm_schedules_rec oks_pm_schedules_rec_type;
1782: -------------------------------
1775: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1776: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1777: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1778: l_def_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
1779: l_db_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type;
1780: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
1781: lx_oks_pm_schedules_rec oks_pm_schedules_rec_type;
1782: -------------------------------
1783: -- FUNCTION fill_who_columns --
1782: -------------------------------
1783: -- FUNCTION fill_who_columns --
1784: -------------------------------
1785: FUNCTION fill_who_columns (
1786: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
1787: ) RETURN oks_pm_schedules_v_rec_type IS
1788: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1783: -- FUNCTION fill_who_columns --
1784: -------------------------------
1785: FUNCTION fill_who_columns (
1786: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
1787: ) RETURN oks_pm_schedules_v_rec_type IS
1788: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1791: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1784: -------------------------------
1785: FUNCTION fill_who_columns (
1786: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
1787: ) RETURN oks_pm_schedules_v_rec_type IS
1788: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1791: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1792: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1786: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type
1787: ) RETURN oks_pm_schedules_v_rec_type IS
1788: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1791: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1792: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1793: RETURN(l_oks_pm_schedules_v_rec);
1794: END fill_who_columns;
1787: ) RETURN oks_pm_schedules_v_rec_type IS
1788: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1791: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1792: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1793: RETURN(l_oks_pm_schedules_v_rec);
1794: END fill_who_columns;
1795: ----------------------------------
1788: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1791: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1792: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1793: RETURN(l_oks_pm_schedules_v_rec);
1794: END fill_who_columns;
1795: ----------------------------------
1796: -- FUNCTION populate_new_record --
1789: BEGIN
1790: l_oks_pm_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1791: l_oks_pm_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1792: l_oks_pm_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1793: RETURN(l_oks_pm_schedules_v_rec);
1794: END fill_who_columns;
1795: ----------------------------------
1796: -- FUNCTION populate_new_record --
1797: ----------------------------------
1795: ----------------------------------
1796: -- FUNCTION populate_new_record --
1797: ----------------------------------
1798: FUNCTION populate_new_record (
1799: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1800: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
1801: ) RETURN VARCHAR2 IS
1802: l_row_notfound BOOLEAN := TRUE;
1803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1796: -- FUNCTION populate_new_record --
1797: ----------------------------------
1798: FUNCTION populate_new_record (
1799: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1800: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
1801: ) RETURN VARCHAR2 IS
1802: l_row_notfound BOOLEAN := TRUE;
1803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1804: BEGIN
1801: ) RETURN VARCHAR2 IS
1802: l_row_notfound BOOLEAN := TRUE;
1803: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1804: BEGIN
1805: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
1806: -- Get current database values
1807: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1808: -- so it may be verified through LOCK_ROW.
1809: l_db_oks_pm_schedules_v_rec := get_rec(p_oks_pm_schedules_v_rec, l_return_status);
1805: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
1806: -- Get current database values
1807: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1808: -- so it may be verified through LOCK_ROW.
1809: l_db_oks_pm_schedules_v_rec := get_rec(p_oks_pm_schedules_v_rec, l_return_status);
1810: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1811: IF (x_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1812: THEN
1813: x_oks_pm_schedules_v_rec.id := l_db_oks_pm_schedules_v_rec.id;
1807: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1808: -- so it may be verified through LOCK_ROW.
1809: l_db_oks_pm_schedules_v_rec := get_rec(p_oks_pm_schedules_v_rec, l_return_status);
1810: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1811: IF (x_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1812: THEN
1813: x_oks_pm_schedules_v_rec.id := l_db_oks_pm_schedules_v_rec.id;
1814: END IF;
1815: IF (x_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM)
1809: l_db_oks_pm_schedules_v_rec := get_rec(p_oks_pm_schedules_v_rec, l_return_status);
1810: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1811: IF (x_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1812: THEN
1813: x_oks_pm_schedules_v_rec.id := l_db_oks_pm_schedules_v_rec.id;
1814: END IF;
1815: IF (x_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM)
1816: THEN
1817: x_oks_pm_schedules_v_rec.rule_id := l_db_oks_pm_schedules_v_rec.rule_id;
1811: IF (x_oks_pm_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1812: THEN
1813: x_oks_pm_schedules_v_rec.id := l_db_oks_pm_schedules_v_rec.id;
1814: END IF;
1815: IF (x_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM)
1816: THEN
1817: x_oks_pm_schedules_v_rec.rule_id := l_db_oks_pm_schedules_v_rec.rule_id;
1818: END IF;
1819: IF (x_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM)
1813: x_oks_pm_schedules_v_rec.id := l_db_oks_pm_schedules_v_rec.id;
1814: END IF;
1815: IF (x_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM)
1816: THEN
1817: x_oks_pm_schedules_v_rec.rule_id := l_db_oks_pm_schedules_v_rec.rule_id;
1818: END IF;
1819: IF (x_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM)
1820: THEN
1821: x_oks_pm_schedules_v_rec.pma_rule_id := l_db_oks_pm_schedules_v_rec.pma_rule_id;
1815: IF (x_oks_pm_schedules_v_rec.rule_id = OKC_API.G_MISS_NUM)
1816: THEN
1817: x_oks_pm_schedules_v_rec.rule_id := l_db_oks_pm_schedules_v_rec.rule_id;
1818: END IF;
1819: IF (x_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM)
1820: THEN
1821: x_oks_pm_schedules_v_rec.pma_rule_id := l_db_oks_pm_schedules_v_rec.pma_rule_id;
1822: END IF;
1823: IF (x_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM)
1817: x_oks_pm_schedules_v_rec.rule_id := l_db_oks_pm_schedules_v_rec.rule_id;
1818: END IF;
1819: IF (x_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM)
1820: THEN
1821: x_oks_pm_schedules_v_rec.pma_rule_id := l_db_oks_pm_schedules_v_rec.pma_rule_id;
1822: END IF;
1823: IF (x_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM)
1824: THEN
1825: x_oks_pm_schedules_v_rec.pmp_rule_id := l_db_oks_pm_schedules_v_rec.pmp_rule_id;
1819: IF (x_oks_pm_schedules_v_rec.pma_rule_id = OKC_API.G_MISS_NUM)
1820: THEN
1821: x_oks_pm_schedules_v_rec.pma_rule_id := l_db_oks_pm_schedules_v_rec.pma_rule_id;
1822: END IF;
1823: IF (x_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM)
1824: THEN
1825: x_oks_pm_schedules_v_rec.pmp_rule_id := l_db_oks_pm_schedules_v_rec.pmp_rule_id;
1826: END IF;
1827: IF (x_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1821: x_oks_pm_schedules_v_rec.pma_rule_id := l_db_oks_pm_schedules_v_rec.pma_rule_id;
1822: END IF;
1823: IF (x_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM)
1824: THEN
1825: x_oks_pm_schedules_v_rec.pmp_rule_id := l_db_oks_pm_schedules_v_rec.pmp_rule_id;
1826: END IF;
1827: IF (x_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1828: THEN
1829: x_oks_pm_schedules_v_rec.dnz_chr_id := l_db_oks_pm_schedules_v_rec.dnz_chr_id;
1823: IF (x_oks_pm_schedules_v_rec.pmp_rule_id = OKC_API.G_MISS_NUM)
1824: THEN
1825: x_oks_pm_schedules_v_rec.pmp_rule_id := l_db_oks_pm_schedules_v_rec.pmp_rule_id;
1826: END IF;
1827: IF (x_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1828: THEN
1829: x_oks_pm_schedules_v_rec.dnz_chr_id := l_db_oks_pm_schedules_v_rec.dnz_chr_id;
1830: END IF;
1831: IF (x_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1825: x_oks_pm_schedules_v_rec.pmp_rule_id := l_db_oks_pm_schedules_v_rec.pmp_rule_id;
1826: END IF;
1827: IF (x_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1828: THEN
1829: x_oks_pm_schedules_v_rec.dnz_chr_id := l_db_oks_pm_schedules_v_rec.dnz_chr_id;
1830: END IF;
1831: IF (x_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1832: THEN
1833: x_oks_pm_schedules_v_rec.cle_id := l_db_oks_pm_schedules_v_rec.cle_id;
1827: IF (x_oks_pm_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1828: THEN
1829: x_oks_pm_schedules_v_rec.dnz_chr_id := l_db_oks_pm_schedules_v_rec.dnz_chr_id;
1830: END IF;
1831: IF (x_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1832: THEN
1833: x_oks_pm_schedules_v_rec.cle_id := l_db_oks_pm_schedules_v_rec.cle_id;
1834: END IF;
1835: IF (x_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM)
1829: x_oks_pm_schedules_v_rec.dnz_chr_id := l_db_oks_pm_schedules_v_rec.dnz_chr_id;
1830: END IF;
1831: IF (x_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1832: THEN
1833: x_oks_pm_schedules_v_rec.cle_id := l_db_oks_pm_schedules_v_rec.cle_id;
1834: END IF;
1835: IF (x_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM)
1836: THEN
1837: x_oks_pm_schedules_v_rec.sch_sequence := l_db_oks_pm_schedules_v_rec.sch_sequence;
1831: IF (x_oks_pm_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1832: THEN
1833: x_oks_pm_schedules_v_rec.cle_id := l_db_oks_pm_schedules_v_rec.cle_id;
1834: END IF;
1835: IF (x_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM)
1836: THEN
1837: x_oks_pm_schedules_v_rec.sch_sequence := l_db_oks_pm_schedules_v_rec.sch_sequence;
1838: END IF;
1839: IF (x_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE)
1833: x_oks_pm_schedules_v_rec.cle_id := l_db_oks_pm_schedules_v_rec.cle_id;
1834: END IF;
1835: IF (x_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM)
1836: THEN
1837: x_oks_pm_schedules_v_rec.sch_sequence := l_db_oks_pm_schedules_v_rec.sch_sequence;
1838: END IF;
1839: IF (x_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE)
1840: THEN
1841: x_oks_pm_schedules_v_rec.schedule_date := l_db_oks_pm_schedules_v_rec.schedule_date;
1835: IF (x_oks_pm_schedules_v_rec.sch_sequence = OKC_API.G_MISS_NUM)
1836: THEN
1837: x_oks_pm_schedules_v_rec.sch_sequence := l_db_oks_pm_schedules_v_rec.sch_sequence;
1838: END IF;
1839: IF (x_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE)
1840: THEN
1841: x_oks_pm_schedules_v_rec.schedule_date := l_db_oks_pm_schedules_v_rec.schedule_date;
1842: END IF;
1843: IF (x_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE)
1837: x_oks_pm_schedules_v_rec.sch_sequence := l_db_oks_pm_schedules_v_rec.sch_sequence;
1838: END IF;
1839: IF (x_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE)
1840: THEN
1841: x_oks_pm_schedules_v_rec.schedule_date := l_db_oks_pm_schedules_v_rec.schedule_date;
1842: END IF;
1843: IF (x_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE)
1844: THEN
1845: x_oks_pm_schedules_v_rec.schedule_date_from := l_db_oks_pm_schedules_v_rec.schedule_date_from;
1839: IF (x_oks_pm_schedules_v_rec.schedule_date = OKC_API.G_MISS_DATE)
1840: THEN
1841: x_oks_pm_schedules_v_rec.schedule_date := l_db_oks_pm_schedules_v_rec.schedule_date;
1842: END IF;
1843: IF (x_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE)
1844: THEN
1845: x_oks_pm_schedules_v_rec.schedule_date_from := l_db_oks_pm_schedules_v_rec.schedule_date_from;
1846: END IF;
1847: IF (x_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE)
1841: x_oks_pm_schedules_v_rec.schedule_date := l_db_oks_pm_schedules_v_rec.schedule_date;
1842: END IF;
1843: IF (x_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE)
1844: THEN
1845: x_oks_pm_schedules_v_rec.schedule_date_from := l_db_oks_pm_schedules_v_rec.schedule_date_from;
1846: END IF;
1847: IF (x_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE)
1848: THEN
1849: x_oks_pm_schedules_v_rec.schedule_date_to := l_db_oks_pm_schedules_v_rec.schedule_date_to;
1843: IF (x_oks_pm_schedules_v_rec.schedule_date_from = OKC_API.G_MISS_DATE)
1844: THEN
1845: x_oks_pm_schedules_v_rec.schedule_date_from := l_db_oks_pm_schedules_v_rec.schedule_date_from;
1846: END IF;
1847: IF (x_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE)
1848: THEN
1849: x_oks_pm_schedules_v_rec.schedule_date_to := l_db_oks_pm_schedules_v_rec.schedule_date_to;
1850: END IF;
1851: IF (x_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
1845: x_oks_pm_schedules_v_rec.schedule_date_from := l_db_oks_pm_schedules_v_rec.schedule_date_from;
1846: END IF;
1847: IF (x_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE)
1848: THEN
1849: x_oks_pm_schedules_v_rec.schedule_date_to := l_db_oks_pm_schedules_v_rec.schedule_date_to;
1850: END IF;
1851: IF (x_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
1852: THEN
1853: x_oks_pm_schedules_v_rec.created_by := l_db_oks_pm_schedules_v_rec.created_by;
1847: IF (x_oks_pm_schedules_v_rec.schedule_date_to = OKC_API.G_MISS_DATE)
1848: THEN
1849: x_oks_pm_schedules_v_rec.schedule_date_to := l_db_oks_pm_schedules_v_rec.schedule_date_to;
1850: END IF;
1851: IF (x_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
1852: THEN
1853: x_oks_pm_schedules_v_rec.created_by := l_db_oks_pm_schedules_v_rec.created_by;
1854: END IF;
1855: IF (x_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
1849: x_oks_pm_schedules_v_rec.schedule_date_to := l_db_oks_pm_schedules_v_rec.schedule_date_to;
1850: END IF;
1851: IF (x_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
1852: THEN
1853: x_oks_pm_schedules_v_rec.created_by := l_db_oks_pm_schedules_v_rec.created_by;
1854: END IF;
1855: IF (x_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
1856: THEN
1857: x_oks_pm_schedules_v_rec.creation_date := l_db_oks_pm_schedules_v_rec.creation_date;
1851: IF (x_oks_pm_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
1852: THEN
1853: x_oks_pm_schedules_v_rec.created_by := l_db_oks_pm_schedules_v_rec.created_by;
1854: END IF;
1855: IF (x_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
1856: THEN
1857: x_oks_pm_schedules_v_rec.creation_date := l_db_oks_pm_schedules_v_rec.creation_date;
1858: END IF;
1859: IF (x_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1853: x_oks_pm_schedules_v_rec.created_by := l_db_oks_pm_schedules_v_rec.created_by;
1854: END IF;
1855: IF (x_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
1856: THEN
1857: x_oks_pm_schedules_v_rec.creation_date := l_db_oks_pm_schedules_v_rec.creation_date;
1858: END IF;
1859: IF (x_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1860: THEN
1861: x_oks_pm_schedules_v_rec.last_updated_by := l_db_oks_pm_schedules_v_rec.last_updated_by;
1855: IF (x_oks_pm_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
1856: THEN
1857: x_oks_pm_schedules_v_rec.creation_date := l_db_oks_pm_schedules_v_rec.creation_date;
1858: END IF;
1859: IF (x_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1860: THEN
1861: x_oks_pm_schedules_v_rec.last_updated_by := l_db_oks_pm_schedules_v_rec.last_updated_by;
1862: END IF;
1863: IF (x_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1857: x_oks_pm_schedules_v_rec.creation_date := l_db_oks_pm_schedules_v_rec.creation_date;
1858: END IF;
1859: IF (x_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1860: THEN
1861: x_oks_pm_schedules_v_rec.last_updated_by := l_db_oks_pm_schedules_v_rec.last_updated_by;
1862: END IF;
1863: IF (x_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1864: THEN
1865: x_oks_pm_schedules_v_rec.last_update_date := l_db_oks_pm_schedules_v_rec.last_update_date;
1859: IF (x_oks_pm_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
1860: THEN
1861: x_oks_pm_schedules_v_rec.last_updated_by := l_db_oks_pm_schedules_v_rec.last_updated_by;
1862: END IF;
1863: IF (x_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1864: THEN
1865: x_oks_pm_schedules_v_rec.last_update_date := l_db_oks_pm_schedules_v_rec.last_update_date;
1866: END IF;
1867: IF (x_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1861: x_oks_pm_schedules_v_rec.last_updated_by := l_db_oks_pm_schedules_v_rec.last_updated_by;
1862: END IF;
1863: IF (x_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1864: THEN
1865: x_oks_pm_schedules_v_rec.last_update_date := l_db_oks_pm_schedules_v_rec.last_update_date;
1866: END IF;
1867: IF (x_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1868: THEN
1869: x_oks_pm_schedules_v_rec.last_update_login := l_db_oks_pm_schedules_v_rec.last_update_login;
1863: IF (x_oks_pm_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
1864: THEN
1865: x_oks_pm_schedules_v_rec.last_update_date := l_db_oks_pm_schedules_v_rec.last_update_date;
1866: END IF;
1867: IF (x_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1868: THEN
1869: x_oks_pm_schedules_v_rec.last_update_login := l_db_oks_pm_schedules_v_rec.last_update_login;
1870: END IF;
1871: IF (x_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM)
1865: x_oks_pm_schedules_v_rec.last_update_date := l_db_oks_pm_schedules_v_rec.last_update_date;
1866: END IF;
1867: IF (x_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1868: THEN
1869: x_oks_pm_schedules_v_rec.last_update_login := l_db_oks_pm_schedules_v_rec.last_update_login;
1870: END IF;
1871: IF (x_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM)
1872: THEN
1873: x_oks_pm_schedules_v_rec.activity_line_id := l_db_oks_pm_schedules_v_rec.activity_line_id;
1867: IF (x_oks_pm_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
1868: THEN
1869: x_oks_pm_schedules_v_rec.last_update_login := l_db_oks_pm_schedules_v_rec.last_update_login;
1870: END IF;
1871: IF (x_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM)
1872: THEN
1873: x_oks_pm_schedules_v_rec.activity_line_id := l_db_oks_pm_schedules_v_rec.activity_line_id;
1874: END IF;
1875: IF (x_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM)
1869: x_oks_pm_schedules_v_rec.last_update_login := l_db_oks_pm_schedules_v_rec.last_update_login;
1870: END IF;
1871: IF (x_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM)
1872: THEN
1873: x_oks_pm_schedules_v_rec.activity_line_id := l_db_oks_pm_schedules_v_rec.activity_line_id;
1874: END IF;
1875: IF (x_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM)
1876: THEN
1877: x_oks_pm_schedules_v_rec.stream_line_id := l_db_oks_pm_schedules_v_rec.stream_line_id;
1871: IF (x_oks_pm_schedules_v_rec.activity_line_id = OKC_API.G_MISS_NUM)
1872: THEN
1873: x_oks_pm_schedules_v_rec.activity_line_id := l_db_oks_pm_schedules_v_rec.activity_line_id;
1874: END IF;
1875: IF (x_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM)
1876: THEN
1877: x_oks_pm_schedules_v_rec.stream_line_id := l_db_oks_pm_schedules_v_rec.stream_line_id;
1878: END IF;
1879: IF (x_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1873: x_oks_pm_schedules_v_rec.activity_line_id := l_db_oks_pm_schedules_v_rec.activity_line_id;
1874: END IF;
1875: IF (x_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM)
1876: THEN
1877: x_oks_pm_schedules_v_rec.stream_line_id := l_db_oks_pm_schedules_v_rec.stream_line_id;
1878: END IF;
1879: IF (x_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1880: THEN
1881: x_oks_pm_schedules_v_rec.security_group_id := l_db_oks_pm_schedules_v_rec.security_group_id;
1875: IF (x_oks_pm_schedules_v_rec.stream_line_id = OKC_API.G_MISS_NUM)
1876: THEN
1877: x_oks_pm_schedules_v_rec.stream_line_id := l_db_oks_pm_schedules_v_rec.stream_line_id;
1878: END IF;
1879: IF (x_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1880: THEN
1881: x_oks_pm_schedules_v_rec.security_group_id := l_db_oks_pm_schedules_v_rec.security_group_id;
1882: END IF;
1883: IF (x_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1877: x_oks_pm_schedules_v_rec.stream_line_id := l_db_oks_pm_schedules_v_rec.stream_line_id;
1878: END IF;
1879: IF (x_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1880: THEN
1881: x_oks_pm_schedules_v_rec.security_group_id := l_db_oks_pm_schedules_v_rec.security_group_id;
1882: END IF;
1883: IF (x_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1884: THEN
1885: x_oks_pm_schedules_v_rec.program_application_id := l_db_oks_pm_schedules_v_rec.program_application_id;
1879: IF (x_oks_pm_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
1880: THEN
1881: x_oks_pm_schedules_v_rec.security_group_id := l_db_oks_pm_schedules_v_rec.security_group_id;
1882: END IF;
1883: IF (x_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1884: THEN
1885: x_oks_pm_schedules_v_rec.program_application_id := l_db_oks_pm_schedules_v_rec.program_application_id;
1886: END IF;
1887: IF (x_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
1881: x_oks_pm_schedules_v_rec.security_group_id := l_db_oks_pm_schedules_v_rec.security_group_id;
1882: END IF;
1883: IF (x_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1884: THEN
1885: x_oks_pm_schedules_v_rec.program_application_id := l_db_oks_pm_schedules_v_rec.program_application_id;
1886: END IF;
1887: IF (x_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
1888: THEN
1889: x_oks_pm_schedules_v_rec.program_id := l_db_oks_pm_schedules_v_rec.program_id;
1883: IF (x_oks_pm_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
1884: THEN
1885: x_oks_pm_schedules_v_rec.program_application_id := l_db_oks_pm_schedules_v_rec.program_application_id;
1886: END IF;
1887: IF (x_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
1888: THEN
1889: x_oks_pm_schedules_v_rec.program_id := l_db_oks_pm_schedules_v_rec.program_id;
1890: END IF;
1891: IF (x_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1885: x_oks_pm_schedules_v_rec.program_application_id := l_db_oks_pm_schedules_v_rec.program_application_id;
1886: END IF;
1887: IF (x_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
1888: THEN
1889: x_oks_pm_schedules_v_rec.program_id := l_db_oks_pm_schedules_v_rec.program_id;
1890: END IF;
1891: IF (x_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1892: THEN
1893: x_oks_pm_schedules_v_rec.program_update_date := l_db_oks_pm_schedules_v_rec.program_update_date;
1887: IF (x_oks_pm_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
1888: THEN
1889: x_oks_pm_schedules_v_rec.program_id := l_db_oks_pm_schedules_v_rec.program_id;
1890: END IF;
1891: IF (x_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1892: THEN
1893: x_oks_pm_schedules_v_rec.program_update_date := l_db_oks_pm_schedules_v_rec.program_update_date;
1894: END IF;
1895: IF (x_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
1889: x_oks_pm_schedules_v_rec.program_id := l_db_oks_pm_schedules_v_rec.program_id;
1890: END IF;
1891: IF (x_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1892: THEN
1893: x_oks_pm_schedules_v_rec.program_update_date := l_db_oks_pm_schedules_v_rec.program_update_date;
1894: END IF;
1895: IF (x_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
1896: THEN
1897: x_oks_pm_schedules_v_rec.request_id := l_db_oks_pm_schedules_v_rec.request_id;
1891: IF (x_oks_pm_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
1892: THEN
1893: x_oks_pm_schedules_v_rec.program_update_date := l_db_oks_pm_schedules_v_rec.program_update_date;
1894: END IF;
1895: IF (x_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
1896: THEN
1897: x_oks_pm_schedules_v_rec.request_id := l_db_oks_pm_schedules_v_rec.request_id;
1898: END IF;
1899: END IF;
1893: x_oks_pm_schedules_v_rec.program_update_date := l_db_oks_pm_schedules_v_rec.program_update_date;
1894: END IF;
1895: IF (x_oks_pm_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
1896: THEN
1897: x_oks_pm_schedules_v_rec.request_id := l_db_oks_pm_schedules_v_rec.request_id;
1898: END IF;
1899: END IF;
1900: RETURN(l_return_status);
1901: END populate_new_record;
1899: END IF;
1900: RETURN(l_return_status);
1901: END populate_new_record;
1902: -------------------------------------------
1903: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
1904: -------------------------------------------
1905: FUNCTION Set_Attributes (
1906: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1907: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
1902: -------------------------------------------
1903: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
1904: -------------------------------------------
1905: FUNCTION Set_Attributes (
1906: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1907: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
1908: ) RETURN VARCHAR2 IS
1909: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1910: BEGIN
1903: -- Set_Attributes for:OKS_PM_SCHEDULES_V --
1904: -------------------------------------------
1905: FUNCTION Set_Attributes (
1906: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type,
1907: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
1908: ) RETURN VARCHAR2 IS
1909: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1910: BEGIN
1911: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
1907: x_oks_pm_schedules_v_rec OUT NOCOPY oks_pm_schedules_v_rec_type
1908: ) RETURN VARCHAR2 IS
1909: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1910: BEGIN
1911: x_oks_pm_schedules_v_rec := p_oks_pm_schedules_v_rec;
1912: RETURN(l_return_status);
1913: END Set_Attributes;
1914: BEGIN
1915: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1925: RAISE OKC_API.G_EXCEPTION_ERROR;
1926: END IF;
1927: --- Setting item attributes
1928: l_return_status := Set_Attributes(
1929: p_oks_pm_schedules_v_rec,
1930: x_oks_pm_schedules_v_rec);
1931: --- If any errors happen abort API
1932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1926: END IF;
1927: --- Setting item attributes
1928: l_return_status := Set_Attributes(
1929: p_oks_pm_schedules_v_rec,
1930: x_oks_pm_schedules_v_rec);
1931: --- If any errors happen abort API
1932: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1933: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1935: RAISE OKC_API.G_EXCEPTION_ERROR;
1936: END IF;
1937: l_return_status := populate_new_record(l_oks_pm_schedules_v_rec, l_def_oks_pm_schedules_v_rec);
1938: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1941: RAISE OKC_API.G_EXCEPTION_ERROR;
1939: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1940: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1941: RAISE OKC_API.G_EXCEPTION_ERROR;
1942: END IF;
1943: l_def_oks_pm_schedules_v_rec := fill_who_columns(l_def_oks_pm_schedules_v_rec);
1944: --- Validate all non-missing attributes (Item Level Validation)
1945: l_return_status := Validate_Attributes(l_def_oks_pm_schedules_v_rec);
1946: --- If any errors happen abort API
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1941: RAISE OKC_API.G_EXCEPTION_ERROR;
1942: END IF;
1943: l_def_oks_pm_schedules_v_rec := fill_who_columns(l_def_oks_pm_schedules_v_rec);
1944: --- Validate all non-missing attributes (Item Level Validation)
1945: l_return_status := Validate_Attributes(l_def_oks_pm_schedules_v_rec);
1946: --- If any errors happen abort API
1947: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1949: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1948: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1949: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1950: RAISE OKC_API.G_EXCEPTION_ERROR;
1951: END IF;
1952: l_return_status := Validate_Record(l_def_oks_pm_schedules_v_rec, l_db_oks_pm_schedules_v_rec);
1953: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1955: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1956: RAISE OKC_API.G_EXCEPTION_ERROR;
1962: p_init_msg_list => p_init_msg_list,
1963: x_return_status => l_return_status,
1964: x_msg_count => x_msg_count,
1965: x_msg_data => x_msg_data,
1966: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_rec);
1967: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1969: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1970: RAISE OKC_API.G_EXCEPTION_ERROR;
1972:
1973: -----------------------------------------
1974: -- Move VIEW record to "Child" records --
1975: -----------------------------------------
1976: migrate(l_def_oks_pm_schedules_v_rec, l_oks_pm_schedules_rec);
1977: -----------------------------------------------
1978: -- Call the UPDATE_ROW for each child record --
1979: -----------------------------------------------
1980: update_row(
1989: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1990: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1991: RAISE OKC_API.G_EXCEPTION_ERROR;
1992: END IF;
1993: migrate(lx_oks_pm_schedules_rec, l_def_oks_pm_schedules_v_rec);
1994: x_oks_pm_schedules_v_rec := l_def_oks_pm_schedules_v_rec;
1995: x_return_status := l_return_status;
1996: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION
1990: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1991: RAISE OKC_API.G_EXCEPTION_ERROR;
1992: END IF;
1993: migrate(lx_oks_pm_schedules_rec, l_def_oks_pm_schedules_v_rec);
1994: x_oks_pm_schedules_v_rec := l_def_oks_pm_schedules_v_rec;
1995: x_return_status := l_return_status;
1996: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1997: EXCEPTION
1998: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2026: '_PVT'
2027: );
2028: END update_row;
2029: ------------------------------------------------------
2030: -- PL/SQL TBL update_row for:oks_pm_schedules_v_tbl --
2031: ------------------------------------------------------
2032: PROCEDURE update_row(
2033: p_api_version IN NUMBER,
2034: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2034: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2035: x_return_status OUT NOCOPY VARCHAR2,
2036: x_msg_count OUT NOCOPY NUMBER,
2037: x_msg_data OUT NOCOPY VARCHAR2,
2038: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
2039: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type,
2040: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2041:
2042: l_api_version CONSTANT NUMBER := 1;
2035: x_return_status OUT NOCOPY VARCHAR2,
2036: x_msg_count OUT NOCOPY NUMBER,
2037: x_msg_data OUT NOCOPY VARCHAR2,
2038: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
2039: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type,
2040: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2041:
2042: l_api_version CONSTANT NUMBER := 1;
2043: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2044: i NUMBER := 0;
2045: BEGIN
2046: OKC_API.init_msg_list(p_init_msg_list);
2047: -- Make sure PL/SQL table has records in it before passing
2048: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
2049: i := p_oks_pm_schedules_v_tbl.FIRST;
2050: LOOP
2051: DECLARE
2052: l_error_rec OKC_API.ERROR_REC_TYPE;
2045: BEGIN
2046: OKC_API.init_msg_list(p_init_msg_list);
2047: -- Make sure PL/SQL table has records in it before passing
2048: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
2049: i := p_oks_pm_schedules_v_tbl.FIRST;
2050: LOOP
2051: DECLARE
2052: l_error_rec OKC_API.ERROR_REC_TYPE;
2053: BEGIN
2059: p_init_msg_list => OKC_API.G_FALSE,
2060: x_return_status => l_error_rec.error_type,
2061: x_msg_count => l_error_rec.msg_count,
2062: x_msg_data => l_error_rec.msg_data,
2063: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i),
2064: x_oks_pm_schedules_v_rec => x_oks_pm_schedules_v_tbl(i));
2065: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2066: l_error_rec.sqlcode := SQLCODE;
2067: load_error_tbl(l_error_rec, px_error_tbl);
2060: x_return_status => l_error_rec.error_type,
2061: x_msg_count => l_error_rec.msg_count,
2062: x_msg_data => l_error_rec.msg_data,
2063: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i),
2064: x_oks_pm_schedules_v_rec => x_oks_pm_schedules_v_tbl(i));
2065: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2066: l_error_rec.sqlcode := SQLCODE;
2067: load_error_tbl(l_error_rec, px_error_tbl);
2068: ELSE
2082: l_error_rec.error_type := 'OTHERS';
2083: l_error_rec.sqlcode := SQLCODE;
2084: load_error_tbl(l_error_rec, px_error_tbl);
2085: END;
2086: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
2087: i := p_oks_pm_schedules_v_tbl.NEXT(i);
2088: END LOOP;
2089: END IF;
2090: -- Loop through the error_tbl to find the error with the highest severity
2083: l_error_rec.sqlcode := SQLCODE;
2084: load_error_tbl(l_error_rec, px_error_tbl);
2085: END;
2086: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
2087: i := p_oks_pm_schedules_v_tbl.NEXT(i);
2088: END LOOP;
2089: END IF;
2090: -- Loop through the error_tbl to find the error with the highest severity
2091: -- and return it.
2124: );
2125: END update_row;
2126:
2127: ------------------------------------------------------
2128: -- PL/SQL TBL update_row for:OKS_PM_SCHEDULES_V_TBL --
2129: ------------------------------------------------------
2130: PROCEDURE update_row(
2131: p_api_version IN NUMBER,
2132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2132: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2133: x_return_status OUT NOCOPY VARCHAR2,
2134: x_msg_count OUT NOCOPY NUMBER,
2135: x_msg_data OUT NOCOPY VARCHAR2,
2136: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
2137: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type) IS
2138:
2139: l_api_version CONSTANT NUMBER := 1;
2140: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2133: x_return_status OUT NOCOPY VARCHAR2,
2134: x_msg_count OUT NOCOPY NUMBER,
2135: x_msg_data OUT NOCOPY VARCHAR2,
2136: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
2137: x_oks_pm_schedules_v_tbl OUT NOCOPY oks_pm_schedules_v_tbl_type) IS
2138:
2139: l_api_version CONSTANT NUMBER := 1;
2140: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2141: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2142: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2143: BEGIN
2144: OKC_API.init_msg_list(p_init_msg_list);
2145: -- Make sure PL/SQL table has records in it before passing
2146: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
2147: update_row (
2148: p_api_version => p_api_version,
2149: p_init_msg_list => OKC_API.G_FALSE,
2150: x_return_status => x_return_status,
2149: p_init_msg_list => OKC_API.G_FALSE,
2150: x_return_status => x_return_status,
2151: x_msg_count => x_msg_count,
2152: x_msg_data => x_msg_data,
2153: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
2154: x_oks_pm_schedules_v_tbl => x_oks_pm_schedules_v_tbl,
2155: px_error_tbl => l_error_tbl);
2156: END IF;
2157: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2150: x_return_status => x_return_status,
2151: x_msg_count => x_msg_count,
2152: x_msg_data => x_msg_data,
2153: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
2154: x_oks_pm_schedules_v_tbl => x_oks_pm_schedules_v_tbl,
2155: px_error_tbl => l_error_tbl);
2156: END IF;
2157: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2158: EXCEPTION
2254: '_PVT'
2255: );
2256: END delete_row;
2257: ---------------------------------------
2258: -- delete_row for:OKS_PM_SCHEDULES_V --
2259: ---------------------------------------
2260: PROCEDURE delete_row(
2261: p_api_version IN NUMBER,
2262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2262: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2263: x_return_status OUT NOCOPY VARCHAR2,
2264: x_msg_count OUT NOCOPY NUMBER,
2265: x_msg_data OUT NOCOPY VARCHAR2,
2266: p_oks_pm_schedules_v_rec IN oks_pm_schedules_v_rec_type) IS
2267:
2268: l_api_version CONSTANT NUMBER := 1;
2269: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2270: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2267:
2268: l_api_version CONSTANT NUMBER := 1;
2269: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2270: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2271: l_oks_pm_schedules_v_rec oks_pm_schedules_v_rec_type := p_oks_pm_schedules_v_rec;
2272: l_oks_pm_schedules_rec oks_pm_schedules_rec_type;
2273: BEGIN
2274: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2275: G_PKG_NAME,
2285: END IF;
2286: -----------------------------------------
2287: -- Move VIEW record to "Child" records --
2288: -----------------------------------------
2289: migrate(l_oks_pm_schedules_v_rec, l_oks_pm_schedules_rec);
2290: -----------------------------------------------
2291: -- Call the DELETE_ROW for each child record --
2292: -----------------------------------------------
2293: delete_row(
2336: '_PVT'
2337: );
2338: END delete_row;
2339: --------------------------------------------------
2340: -- PL/SQL TBL delete_row for:OKS_PM_SCHEDULES_V --
2341: --------------------------------------------------
2342: PROCEDURE delete_row(
2343: p_api_version IN NUMBER,
2344: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2344: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2345: x_return_status OUT NOCOPY VARCHAR2,
2346: x_msg_count OUT NOCOPY NUMBER,
2347: x_msg_data OUT NOCOPY VARCHAR2,
2348: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type,
2349: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2350:
2351: l_api_version CONSTANT NUMBER := 1;
2352: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2353: i NUMBER := 0;
2354: BEGIN
2355: OKC_API.init_msg_list(p_init_msg_list);
2356: -- Make sure PL/SQL table has records in it before passing
2357: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
2358: i := p_oks_pm_schedules_v_tbl.FIRST;
2359: LOOP
2360: DECLARE
2361: l_error_rec OKC_API.ERROR_REC_TYPE;
2354: BEGIN
2355: OKC_API.init_msg_list(p_init_msg_list);
2356: -- Make sure PL/SQL table has records in it before passing
2357: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
2358: i := p_oks_pm_schedules_v_tbl.FIRST;
2359: LOOP
2360: DECLARE
2361: l_error_rec OKC_API.ERROR_REC_TYPE;
2362: BEGIN
2368: p_init_msg_list => OKC_API.G_FALSE,
2369: x_return_status => l_error_rec.error_type,
2370: x_msg_count => l_error_rec.msg_count,
2371: x_msg_data => l_error_rec.msg_data,
2372: p_oks_pm_schedules_v_rec => p_oks_pm_schedules_v_tbl(i));
2373: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2374: l_error_rec.sqlcode := SQLCODE;
2375: load_error_tbl(l_error_rec, px_error_tbl);
2376: ELSE
2390: l_error_rec.error_type := 'OTHERS';
2391: l_error_rec.sqlcode := SQLCODE;
2392: load_error_tbl(l_error_rec, px_error_tbl);
2393: END;
2394: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
2395: i := p_oks_pm_schedules_v_tbl.NEXT(i);
2396: END LOOP;
2397: END IF;
2398: -- Loop through the error_tbl to find the error with the highest severity
2391: l_error_rec.sqlcode := SQLCODE;
2392: load_error_tbl(l_error_rec, px_error_tbl);
2393: END;
2394: EXIT WHEN (i = p_oks_pm_schedules_v_tbl.LAST);
2395: i := p_oks_pm_schedules_v_tbl.NEXT(i);
2396: END LOOP;
2397: END IF;
2398: -- Loop through the error_tbl to find the error with the highest severity
2399: -- and return it.
2432: );
2433: END delete_row;
2434:
2435: --------------------------------------------------
2436: -- PL/SQL TBL delete_row for:OKS_PM_SCHEDULES_V --
2437: --------------------------------------------------
2438: PROCEDURE delete_row(
2439: p_api_version IN NUMBER,
2440: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2440: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2441: x_return_status OUT NOCOPY VARCHAR2,
2442: x_msg_count OUT NOCOPY NUMBER,
2443: x_msg_data OUT NOCOPY VARCHAR2,
2444: p_oks_pm_schedules_v_tbl IN oks_pm_schedules_v_tbl_type) IS
2445:
2446: l_api_version CONSTANT NUMBER := 1;
2447: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2448: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2449: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2450: BEGIN
2451: OKC_API.init_msg_list(p_init_msg_list);
2452: -- Make sure PL/SQL table has records in it before passing
2453: IF (p_oks_pm_schedules_v_tbl.COUNT > 0) THEN
2454: delete_row (
2455: p_api_version => p_api_version,
2456: p_init_msg_list => OKC_API.G_FALSE,
2457: x_return_status => x_return_status,
2456: p_init_msg_list => OKC_API.G_FALSE,
2457: x_return_status => x_return_status,
2458: x_msg_count => x_msg_count,
2459: x_msg_data => x_msg_data,
2460: p_oks_pm_schedules_v_tbl => p_oks_pm_schedules_v_tbl,
2461: px_error_tbl => l_error_tbl);
2462: END IF;
2463: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2464: EXCEPTION