DBA Data[Home] [Help]

APPS.HZ_FINANCIAL_NUMBERS_PKG dependencies on FND_API

Line 54: FND_API.G_MISS_NUM, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,

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,

Line 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),

Line 61: FND_API.G_MISS_NUM, NULL,

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),

Line 64: FND_API.G_MISS_CHAR, NULL,

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),

Line 67: FND_API.G_MISS_NUM, NULL,

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),

Line 70: FND_API.G_MISS_CHAR, NULL,

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),

Line 73: FND_API.G_MISS_CHAR, NULL,

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,

Line 85: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

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',

Line 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,

Line 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),

Line 96: FND_API.G_MISS_CHAR, NULL,

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,

Line 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,

Line 163: FND_API.G_MISS_NUM, NULL,

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,

Line 168: 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,
168: FND_API.G_MISS_NUM, NULL,
169: x_financial_report_id),
170: financial_number =
171: DECODE(x_financial_number,
172: NULL, financial_number,

Line 173: FND_API.G_MISS_NUM, NULL,

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,

Line 178: FND_API.G_MISS_CHAR, NULL,

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,

Line 183: FND_API.G_MISS_NUM, NULL,

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,

Line 188: FND_API.G_MISS_CHAR, NULL,

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,

Line 193: 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,
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,

Line 207: FND_API.G_MISS_CHAR, NULL,

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,

Line 212: FND_API.G_MISS_CHAR, NULL,

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,

Line 217: FND_API.G_MISS_NUM, NULL,

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,

Line 222: FND_API.G_MISS_CHAR, NULL,

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

Line 232: FND_API.G_MISS_CHAR, NULL,

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

Line 376: NVL(financial_number_id, FND_API.G_MISS_NUM),

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),

Line 377: NVL(financial_report_id, 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),

Line 378: NVL(financial_number, FND_API.G_MISS_NUM),

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),

Line 379: NVL(financial_number_name, 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),

Line 380: NVL(financial_units_applied, FND_API.G_MISS_NUM),

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),

Line 381: NVL(financial_number_currency, 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)

Line 382: NVL(projected_actual_flag, 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

Line 383: NVL(content_source_type, FND_API.G_MISS_CHAR),

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,

Line 384: NVL(status, 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,
388: x_financial_report_id,

Line 385: NVL(actual_content_source, FND_API.G_MISS_CHAR)

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,

Line 406: RAISE FND_API.G_EXC_ERROR;

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 (