50: actual_content_source
51: )
52: VALUES (
53: DECODE(x_financial_number_id,
54: FND_API.G_MISS_NUM, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,
55: NULL, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,
56: x_financial_number_id),
57: DECODE(x_financial_report_id,
58: FND_API.G_MISS_NUM, NULL,
54: FND_API.G_MISS_NUM, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,
55: NULL, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,
56: x_financial_number_id),
57: DECODE(x_financial_report_id,
58: FND_API.G_MISS_NUM, NULL,
59: x_financial_report_id),
60: DECODE(x_financial_number,
61: FND_API.G_MISS_NUM, NULL,
62: x_financial_number),
57: DECODE(x_financial_report_id,
58: FND_API.G_MISS_NUM, NULL,
59: x_financial_report_id),
60: DECODE(x_financial_number,
61: FND_API.G_MISS_NUM, NULL,
62: x_financial_number),
63: DECODE(x_financial_number_name,
64: FND_API.G_MISS_CHAR, NULL,
65: x_financial_number_name),
60: DECODE(x_financial_number,
61: FND_API.G_MISS_NUM, NULL,
62: x_financial_number),
63: DECODE(x_financial_number_name,
64: FND_API.G_MISS_CHAR, NULL,
65: x_financial_number_name),
66: DECODE(x_financial_units_applied,
67: FND_API.G_MISS_NUM, NULL,
68: x_financial_units_applied),
63: DECODE(x_financial_number_name,
64: FND_API.G_MISS_CHAR, NULL,
65: x_financial_number_name),
66: DECODE(x_financial_units_applied,
67: FND_API.G_MISS_NUM, NULL,
68: x_financial_units_applied),
69: DECODE(x_financial_number_currency,
70: FND_API.G_MISS_CHAR, NULL,
71: x_financial_number_currency),
66: DECODE(x_financial_units_applied,
67: FND_API.G_MISS_NUM, NULL,
68: x_financial_units_applied),
69: DECODE(x_financial_number_currency,
70: FND_API.G_MISS_CHAR, NULL,
71: x_financial_number_currency),
72: DECODE(x_projected_actual_flag,
73: FND_API.G_MISS_CHAR, NULL,
74: x_projected_actual_flag),
69: DECODE(x_financial_number_currency,
70: FND_API.G_MISS_CHAR, NULL,
71: x_financial_number_currency),
72: DECODE(x_projected_actual_flag,
73: FND_API.G_MISS_CHAR, NULL,
74: x_projected_actual_flag),
75: hz_utility_v2pub.created_by,
76: hz_utility_v2pub.creation_date,
77: hz_utility_v2pub.last_update_login,
81: hz_utility_v2pub.program_application_id,
82: hz_utility_v2pub.program_id,
83: hz_utility_v2pub.program_update_date,
84: DECODE(x_content_source_type,
85: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
86: NULL, G_MISS_CONTENT_SOURCE_TYPE,
87: x_content_source_type),
88: DECODE(x_status,
89: FND_API.G_MISS_CHAR, 'A',
85: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
86: NULL, G_MISS_CONTENT_SOURCE_TYPE,
87: x_content_source_type),
88: DECODE(x_status,
89: FND_API.G_MISS_CHAR, 'A',
90: NULL, 'A',
91: x_status),
92: DECODE(x_object_version_number,
93: FND_API.G_MISS_NUM, NULL,
89: FND_API.G_MISS_CHAR, 'A',
90: NULL, 'A',
91: x_status),
92: DECODE(x_object_version_number,
93: FND_API.G_MISS_NUM, NULL,
94: x_object_version_number),
95: DECODE(x_created_by_module,
96: FND_API.G_MISS_CHAR, NULL,
97: x_created_by_module),
92: DECODE(x_object_version_number,
93: FND_API.G_MISS_NUM, NULL,
94: x_object_version_number),
95: DECODE(x_created_by_module,
96: FND_API.G_MISS_CHAR, NULL,
97: x_created_by_module),
98: hz_utility_v2pub.application_id,
99: DECODE(x_actual_content_source,
100: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
96: FND_API.G_MISS_CHAR, NULL,
97: x_created_by_module),
98: hz_utility_v2pub.application_id,
99: DECODE(x_actual_content_source,
100: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
101: NULL, G_MISS_CONTENT_SOURCE_TYPE,
102: x_actual_content_source)
103: ) RETURNING
104: rowid,
159: SET
160: financial_number_id =
161: DECODE(x_financial_number_id,
162: NULL, financial_number_id,
163: FND_API.G_MISS_NUM, NULL,
164: x_financial_number_id),
165: financial_report_id =
166: DECODE(x_financial_report_id,
167: NULL, financial_report_id,
164: x_financial_number_id),
165: financial_report_id =
166: DECODE(x_financial_report_id,
167: NULL, financial_report_id,
168: FND_API.G_MISS_NUM, NULL,
169: x_financial_report_id),
170: financial_number =
171: DECODE(x_financial_number,
172: NULL, financial_number,
169: x_financial_report_id),
170: financial_number =
171: DECODE(x_financial_number,
172: NULL, financial_number,
173: FND_API.G_MISS_NUM, NULL,
174: x_financial_number),
175: financial_number_name =
176: DECODE(x_financial_number_name,
177: NULL, financial_number_name,
174: x_financial_number),
175: financial_number_name =
176: DECODE(x_financial_number_name,
177: NULL, financial_number_name,
178: FND_API.G_MISS_CHAR, NULL,
179: x_financial_number_name),
180: financial_units_applied =
181: DECODE(x_financial_units_applied,
182: NULL, financial_units_applied,
179: x_financial_number_name),
180: financial_units_applied =
181: DECODE(x_financial_units_applied,
182: NULL, financial_units_applied,
183: FND_API.G_MISS_NUM, NULL,
184: x_financial_units_applied),
185: financial_number_currency =
186: DECODE(x_financial_number_currency,
187: NULL, financial_number_currency,
184: x_financial_units_applied),
185: financial_number_currency =
186: DECODE(x_financial_number_currency,
187: NULL, financial_number_currency,
188: FND_API.G_MISS_CHAR, NULL,
189: x_financial_number_currency),
190: projected_actual_flag =
191: DECODE(x_projected_actual_flag,
192: NULL, projected_actual_flag,
189: x_financial_number_currency),
190: projected_actual_flag =
191: DECODE(x_projected_actual_flag,
192: NULL, projected_actual_flag,
193: FND_API.G_MISS_CHAR, NULL,
194: x_projected_actual_flag),
195: created_by = created_by,
196: creation_date = creation_date,
197: last_update_login = hz_utility_v2pub.last_update_login,
203: program_update_date = hz_utility_v2pub.program_update_date,
204: content_source_type =
205: DECODE(x_content_source_type,
206: NULL, content_source_type,
207: FND_API.G_MISS_CHAR, NULL,
208: x_content_source_type),
209: status =
210: DECODE(x_status,
211: NULL, status,
208: x_content_source_type),
209: status =
210: DECODE(x_status,
211: NULL, status,
212: FND_API.G_MISS_CHAR, NULL,
213: x_status),
214: object_version_number =
215: DECODE(x_object_version_number,
216: NULL, object_version_number,
213: x_status),
214: object_version_number =
215: DECODE(x_object_version_number,
216: NULL, object_version_number,
217: FND_API.G_MISS_NUM, NULL,
218: x_object_version_number),
219: created_by_module =
220: DECODE(x_created_by_module,
221: NULL, created_by_module,
218: x_object_version_number),
219: created_by_module =
220: DECODE(x_created_by_module,
221: NULL, created_by_module,
222: FND_API.G_MISS_CHAR, NULL,
223: x_created_by_module),
224: application_id = hz_utility_v2pub.application_id/*,
225:
226: ** SSM SST Integration and Extension
228:
229: actual_content_source =
230: DECODE(x_actual_content_source,
231: NULL, actual_content_source,
232: FND_API.G_MISS_CHAR, NULL,
233: x_actual_content_source) */
234: WHERE rowid = x_rowid;
235:
236: IF ( SQL%NOTFOUND ) THEN
372: ) IS
373: BEGIN
374:
375: SELECT
376: NVL(financial_number_id, FND_API.G_MISS_NUM),
377: NVL(financial_report_id, FND_API.G_MISS_NUM),
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
373: BEGIN
374:
375: SELECT
376: NVL(financial_number_id, FND_API.G_MISS_NUM),
377: NVL(financial_report_id, FND_API.G_MISS_NUM),
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
374:
375: SELECT
376: NVL(financial_number_id, FND_API.G_MISS_NUM),
377: NVL(financial_report_id, FND_API.G_MISS_NUM),
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
375: SELECT
376: NVL(financial_number_id, FND_API.G_MISS_NUM),
377: NVL(financial_report_id, FND_API.G_MISS_NUM),
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
376: NVL(financial_number_id, FND_API.G_MISS_NUM),
377: NVL(financial_report_id, FND_API.G_MISS_NUM),
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
384: NVL(status, FND_API.G_MISS_CHAR),
377: NVL(financial_report_id, FND_API.G_MISS_NUM),
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
384: NVL(status, FND_API.G_MISS_CHAR),
385: NVL(actual_content_source, FND_API.G_MISS_CHAR)
378: NVL(financial_number, FND_API.G_MISS_NUM),
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
384: NVL(status, FND_API.G_MISS_CHAR),
385: NVL(actual_content_source, FND_API.G_MISS_CHAR)
386: INTO
379: NVL(financial_number_name, FND_API.G_MISS_CHAR),
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
384: NVL(status, FND_API.G_MISS_CHAR),
385: NVL(actual_content_source, FND_API.G_MISS_CHAR)
386: INTO
387: x_financial_number_id,
380: NVL(financial_units_applied, FND_API.G_MISS_NUM),
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
384: NVL(status, FND_API.G_MISS_CHAR),
385: NVL(actual_content_source, FND_API.G_MISS_CHAR)
386: INTO
387: x_financial_number_id,
388: x_financial_report_id,
381: NVL(financial_number_currency, FND_API.G_MISS_CHAR),
382: NVL(projected_actual_flag, FND_API.G_MISS_CHAR),
383: NVL(content_source_type, FND_API.G_MISS_CHAR),
384: NVL(status, FND_API.G_MISS_CHAR),
385: NVL(actual_content_source, FND_API.G_MISS_CHAR)
386: INTO
387: x_financial_number_id,
388: x_financial_report_id,
389: x_financial_number,
402: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
403: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_financial_number_rec');
404: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_financial_number_id));
405: FND_MSG_PUB.ADD;
406: RAISE FND_API.G_EXC_ERROR;
407:
408: END Select_Row;
409:
410: PROCEDURE Delete_Row (