APPS.HZ_FINANCIAL_REPORTS_PKG dependencies on FND_API

Line 83: FND_API.G_MISS_NUM, HZ_FINANCIAL_REPORTS_S.NEXTVAL,

79: actual_content_source
80: )
81: VALUES (
82: DECODE(x_financial_report_id,
83: FND_API.G_MISS_NUM, HZ_FINANCIAL_REPORTS_S.NEXTVAL,
84: NULL, HZ_FINANCIAL_REPORTS_S.NEXTVAL,
85: x_financial_report_id),
86: DECODE(x_date_report_issued,
87: FND_API.G_MISS_DATE, TO_DATE(NULL),

Line 87: FND_API.G_MISS_DATE, TO_DATE(NULL),

83: FND_API.G_MISS_NUM, HZ_FINANCIAL_REPORTS_S.NEXTVAL,
84: NULL, HZ_FINANCIAL_REPORTS_S.NEXTVAL,
85: x_financial_report_id),
86: DECODE(x_date_report_issued,
87: FND_API.G_MISS_DATE, TO_DATE(NULL),
88: x_date_report_issued),
89: DECODE(x_party_id,
90: FND_API.G_MISS_NUM, NULL,
91: x_party_id),

Line 90: FND_API.G_MISS_NUM, NULL,

86: DECODE(x_date_report_issued,
87: FND_API.G_MISS_DATE, TO_DATE(NULL),
88: x_date_report_issued),
89: DECODE(x_party_id,
90: FND_API.G_MISS_NUM, NULL,
91: x_party_id),
92: DECODE(x_document_reference,
93: FND_API.G_MISS_CHAR, NULL,
94: x_document_reference),

Line 93: FND_API.G_MISS_CHAR, NULL,

89: DECODE(x_party_id,
90: FND_API.G_MISS_NUM, NULL,
91: x_party_id),
92: DECODE(x_document_reference,
93: FND_API.G_MISS_CHAR, NULL,
94: x_document_reference),
95: DECODE(x_issued_period,
96: FND_API.G_MISS_CHAR, NULL,
97: x_issued_period),

Line 96: FND_API.G_MISS_CHAR, NULL,

92: DECODE(x_document_reference,
93: FND_API.G_MISS_CHAR, NULL,
94: x_document_reference),
95: DECODE(x_issued_period,
96: FND_API.G_MISS_CHAR, NULL,
97: x_issued_period),
98: DECODE(x_requiring_authority,
99: FND_API.G_MISS_CHAR, NULL,
100: x_requiring_authority),

Line 99: FND_API.G_MISS_CHAR, NULL,

95: DECODE(x_issued_period,
96: FND_API.G_MISS_CHAR, NULL,
97: x_issued_period),
98: DECODE(x_requiring_authority,
99: FND_API.G_MISS_CHAR, NULL,
100: x_requiring_authority),
101: DECODE(x_type_of_financial_report,
102: FND_API.G_MISS_CHAR, NULL,
103: x_type_of_financial_report),

Line 102: FND_API.G_MISS_CHAR, NULL,

98: DECODE(x_requiring_authority,
99: FND_API.G_MISS_CHAR, NULL,
100: x_requiring_authority),
101: DECODE(x_type_of_financial_report,
102: FND_API.G_MISS_CHAR, NULL,
103: x_type_of_financial_report),
104: DECODE(x_report_start_date,
105: FND_API.G_MISS_DATE, TO_DATE(NULL),
106: x_report_start_date),

Line 105: FND_API.G_MISS_DATE, TO_DATE(NULL),

101: DECODE(x_type_of_financial_report,
102: FND_API.G_MISS_CHAR, NULL,
103: x_type_of_financial_report),
104: DECODE(x_report_start_date,
105: FND_API.G_MISS_DATE, TO_DATE(NULL),
106: x_report_start_date),
107: DECODE(x_report_end_date,
108: FND_API.G_MISS_DATE, TO_DATE(NULL),
109: x_report_end_date),

Line 108: FND_API.G_MISS_DATE, TO_DATE(NULL),

104: DECODE(x_report_start_date,
105: FND_API.G_MISS_DATE, TO_DATE(NULL),
106: x_report_start_date),
107: DECODE(x_report_end_date,
108: FND_API.G_MISS_DATE, TO_DATE(NULL),
109: x_report_end_date),
110: DECODE(x_audit_ind,
111: FND_API.G_MISS_CHAR, NULL,
112: x_audit_ind),

Line 111: FND_API.G_MISS_CHAR, NULL,

107: DECODE(x_report_end_date,
108: FND_API.G_MISS_DATE, TO_DATE(NULL),
109: x_report_end_date),
110: DECODE(x_audit_ind,
111: FND_API.G_MISS_CHAR, NULL,
112: x_audit_ind),
113: DECODE(x_consolidated_ind,
114: FND_API.G_MISS_CHAR, NULL,
115: x_consolidated_ind),

Line 114: FND_API.G_MISS_CHAR, NULL,

110: DECODE(x_audit_ind,
111: FND_API.G_MISS_CHAR, NULL,
112: x_audit_ind),
113: DECODE(x_consolidated_ind,
114: FND_API.G_MISS_CHAR, NULL,
115: x_consolidated_ind),
116: DECODE(x_estimated_ind,
117: FND_API.G_MISS_CHAR, NULL,
118: x_estimated_ind),

Line 117: FND_API.G_MISS_CHAR, NULL,

113: DECODE(x_consolidated_ind,
114: FND_API.G_MISS_CHAR, NULL,
115: x_consolidated_ind),
116: DECODE(x_estimated_ind,
117: FND_API.G_MISS_CHAR, NULL,
118: x_estimated_ind),
119: DECODE(x_fiscal_ind,
120: FND_API.G_MISS_CHAR, NULL,
121: x_fiscal_ind),

Line 120: FND_API.G_MISS_CHAR, NULL,

116: DECODE(x_estimated_ind,
117: FND_API.G_MISS_CHAR, NULL,
118: x_estimated_ind),
119: DECODE(x_fiscal_ind,
120: FND_API.G_MISS_CHAR, NULL,
121: x_fiscal_ind),
122: DECODE(x_final_ind,
123: FND_API.G_MISS_CHAR, NULL,
124: x_final_ind),

Line 123: FND_API.G_MISS_CHAR, NULL,

119: DECODE(x_fiscal_ind,
120: FND_API.G_MISS_CHAR, NULL,
121: x_fiscal_ind),
122: DECODE(x_final_ind,
123: FND_API.G_MISS_CHAR, NULL,
124: x_final_ind),
125: DECODE(x_forecast_ind,
126: FND_API.G_MISS_CHAR, NULL,
127: x_forecast_ind),

Line 126: FND_API.G_MISS_CHAR, NULL,

122: DECODE(x_final_ind,
123: FND_API.G_MISS_CHAR, NULL,
124: x_final_ind),
125: DECODE(x_forecast_ind,
126: FND_API.G_MISS_CHAR, NULL,
127: x_forecast_ind),
128: DECODE(x_opening_ind,
129: FND_API.G_MISS_CHAR, NULL,
130: x_opening_ind),

Line 129: FND_API.G_MISS_CHAR, NULL,

125: DECODE(x_forecast_ind,
126: FND_API.G_MISS_CHAR, NULL,
127: x_forecast_ind),
128: DECODE(x_opening_ind,
129: FND_API.G_MISS_CHAR, NULL,
130: x_opening_ind),
131: DECODE(x_proforma_ind,
132: FND_API.G_MISS_CHAR, NULL,
133: x_proforma_ind),

Line 132: FND_API.G_MISS_CHAR, NULL,

128: DECODE(x_opening_ind,
129: FND_API.G_MISS_CHAR, NULL,
130: x_opening_ind),
131: DECODE(x_proforma_ind,
132: FND_API.G_MISS_CHAR, NULL,
133: x_proforma_ind),
134: DECODE(x_qualified_ind,
135: FND_API.G_MISS_CHAR, NULL,
136: x_qualified_ind),

Line 135: FND_API.G_MISS_CHAR, NULL,

131: DECODE(x_proforma_ind,
132: FND_API.G_MISS_CHAR, NULL,
133: x_proforma_ind),
134: DECODE(x_qualified_ind,
135: FND_API.G_MISS_CHAR, NULL,
136: x_qualified_ind),
137: DECODE(x_restated_ind,
138: FND_API.G_MISS_CHAR, NULL,
139: x_restated_ind),

Line 138: FND_API.G_MISS_CHAR, NULL,

134: DECODE(x_qualified_ind,
135: FND_API.G_MISS_CHAR, NULL,
136: x_qualified_ind),
137: DECODE(x_restated_ind,
138: FND_API.G_MISS_CHAR, NULL,
139: x_restated_ind),
140: DECODE(x_signed_by_principals_ind,
141: FND_API.G_MISS_CHAR, NULL,
142: x_signed_by_principals_ind),

Line 141: FND_API.G_MISS_CHAR, NULL,

137: DECODE(x_restated_ind,
138: FND_API.G_MISS_CHAR, NULL,
139: x_restated_ind),
140: DECODE(x_signed_by_principals_ind,
141: FND_API.G_MISS_CHAR, NULL,
142: x_signed_by_principals_ind),
143: DECODE(x_trial_balance_ind,
144: FND_API.G_MISS_CHAR, NULL,
145: x_trial_balance_ind),

Line 144: FND_API.G_MISS_CHAR, NULL,

140: DECODE(x_signed_by_principals_ind,
141: FND_API.G_MISS_CHAR, NULL,
142: x_signed_by_principals_ind),
143: DECODE(x_trial_balance_ind,
144: FND_API.G_MISS_CHAR, NULL,
145: x_trial_balance_ind),
146: DECODE(x_unbalanced_ind,
147: FND_API.G_MISS_CHAR, NULL,
148: x_unbalanced_ind),

Line 147: FND_API.G_MISS_CHAR, NULL,

143: DECODE(x_trial_balance_ind,
144: FND_API.G_MISS_CHAR, NULL,
145: x_trial_balance_ind),
146: DECODE(x_unbalanced_ind,
147: FND_API.G_MISS_CHAR, NULL,
148: x_unbalanced_ind),
149: DECODE(x_content_source_type,
150: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
151: NULL, G_MISS_CONTENT_SOURCE_TYPE,

Line 150: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

146: DECODE(x_unbalanced_ind,
147: FND_API.G_MISS_CHAR, NULL,
148: x_unbalanced_ind),
149: DECODE(x_content_source_type,
150: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
151: NULL, G_MISS_CONTENT_SOURCE_TYPE,
152: x_content_source_type),
153: hz_utility_v2pub.created_by,
154: hz_utility_v2pub.creation_date,

Line 163: FND_API.G_MISS_CHAR, 'A',

159: hz_utility_v2pub.program_application_id,
160: hz_utility_v2pub.program_id,
161: hz_utility_v2pub.program_update_date,
162: DECODE(x_status,
163: FND_API.G_MISS_CHAR, 'A',
164: NULL, 'A',
165: x_status),
166: DECODE(x_object_version_number,
167: FND_API.G_MISS_NUM, NULL,

Line 167: FND_API.G_MISS_NUM, NULL,

163: FND_API.G_MISS_CHAR, 'A',
164: NULL, 'A',
165: x_status),
166: DECODE(x_object_version_number,
167: FND_API.G_MISS_NUM, NULL,
168: x_object_version_number),
169: DECODE(x_created_by_module,
170: FND_API.G_MISS_CHAR, NULL,
171: x_created_by_module),

Line 170: FND_API.G_MISS_CHAR, NULL,

166: DECODE(x_object_version_number,
167: FND_API.G_MISS_NUM, NULL,
168: x_object_version_number),
169: DECODE(x_created_by_module,
170: FND_API.G_MISS_CHAR, NULL,
171: x_created_by_module),
172: hz_utility_v2pub.application_id,
173: DECODE(x_actual_content_source,
174: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

Line 174: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,

170: FND_API.G_MISS_CHAR, NULL,
171: x_created_by_module),
172: hz_utility_v2pub.application_id,
173: DECODE(x_actual_content_source,
174: FND_API.G_MISS_CHAR, G_MISS_CONTENT_SOURCE_TYPE,
175: NULL, G_MISS_CONTENT_SOURCE_TYPE,
176: x_actual_content_source)
177: ) RETURNING
178: rowid,

Line 255: FND_API.G_MISS_NUM, NULL,

251: SET
252: financial_report_id =
253: DECODE(x_financial_report_id,
254: NULL, financial_report_id,
255: FND_API.G_MISS_NUM, NULL,
256: x_financial_report_id),
257: date_report_issued =
258: DECODE(x_date_report_issued,
259: NULL, date_report_issued,

Line 260: FND_API.G_MISS_DATE, NULL,

256: x_financial_report_id),
257: date_report_issued =
258: DECODE(x_date_report_issued,
259: NULL, date_report_issued,
260: FND_API.G_MISS_DATE, NULL,
261: x_date_report_issued),
262: party_id =
263: DECODE(x_party_id,
264: NULL, party_id,

Line 265: FND_API.G_MISS_NUM, NULL,

261: x_date_report_issued),
262: party_id =
263: DECODE(x_party_id,
264: NULL, party_id,
265: FND_API.G_MISS_NUM, NULL,
266: x_party_id),
267: document_reference =
268: DECODE(x_document_reference,
269: NULL, document_reference,

Line 270: FND_API.G_MISS_CHAR, NULL,

266: x_party_id),
267: document_reference =
268: DECODE(x_document_reference,
269: NULL, document_reference,
270: FND_API.G_MISS_CHAR, NULL,
271: x_document_reference),
272: issued_period =
273: DECODE(x_issued_period,
274: NULL, issued_period,

Line 275: FND_API.G_MISS_CHAR, NULL,

271: x_document_reference),
272: issued_period =
273: DECODE(x_issued_period,
274: NULL, issued_period,
275: FND_API.G_MISS_CHAR, NULL,
276: x_issued_period),
277: requiring_authority =
278: DECODE(x_requiring_authority,
279: NULL, requiring_authority,

Line 280: FND_API.G_MISS_CHAR, NULL,

276: x_issued_period),
277: requiring_authority =
278: DECODE(x_requiring_authority,
279: NULL, requiring_authority,
280: FND_API.G_MISS_CHAR, NULL,
281: x_requiring_authority),
282: type_of_financial_report =
283: DECODE(x_type_of_financial_report,
284: NULL, type_of_financial_report,

Line 285: FND_API.G_MISS_CHAR, NULL,

281: x_requiring_authority),
282: type_of_financial_report =
283: DECODE(x_type_of_financial_report,
284: NULL, type_of_financial_report,
285: FND_API.G_MISS_CHAR, NULL,
286: x_type_of_financial_report),
287: report_start_date =
288: DECODE(x_report_start_date,
289: NULL, report_start_date,

Line 290: FND_API.G_MISS_DATE, NULL,

286: x_type_of_financial_report),
287: report_start_date =
288: DECODE(x_report_start_date,
289: NULL, report_start_date,
290: FND_API.G_MISS_DATE, NULL,
291: x_report_start_date),
292: report_end_date =
293: DECODE(x_report_end_date,
294: NULL, report_end_date,

Line 295: FND_API.G_MISS_DATE, NULL,

291: x_report_start_date),
292: report_end_date =
293: DECODE(x_report_end_date,
294: NULL, report_end_date,
295: FND_API.G_MISS_DATE, NULL,
296: x_report_end_date),
297: audit_ind =
298: DECODE(x_audit_ind,
299: NULL, audit_ind,

Line 300: FND_API.G_MISS_CHAR, NULL,

296: x_report_end_date),
297: audit_ind =
298: DECODE(x_audit_ind,
299: NULL, audit_ind,
300: FND_API.G_MISS_CHAR, NULL,
301: x_audit_ind),
302: consolidated_ind =
303: DECODE(x_consolidated_ind,
304: NULL, consolidated_ind,

Line 305: FND_API.G_MISS_CHAR, NULL,

301: x_audit_ind),
302: consolidated_ind =
303: DECODE(x_consolidated_ind,
304: NULL, consolidated_ind,
305: FND_API.G_MISS_CHAR, NULL,
306: x_consolidated_ind),
307: estimated_ind =
308: DECODE(x_estimated_ind,
309: NULL, estimated_ind,

Line 310: FND_API.G_MISS_CHAR, NULL,

306: x_consolidated_ind),
307: estimated_ind =
308: DECODE(x_estimated_ind,
309: NULL, estimated_ind,
310: FND_API.G_MISS_CHAR, NULL,
311: x_estimated_ind),
312: fiscal_ind =
313: DECODE(x_fiscal_ind,
314: NULL, fiscal_ind,

Line 315: FND_API.G_MISS_CHAR, NULL,

311: x_estimated_ind),
312: fiscal_ind =
313: DECODE(x_fiscal_ind,
314: NULL, fiscal_ind,
315: FND_API.G_MISS_CHAR, NULL,
316: x_fiscal_ind),
317: final_ind =
318: DECODE(x_final_ind,
319: NULL, final_ind,

Line 320: FND_API.G_MISS_CHAR, NULL,

316: x_fiscal_ind),
317: final_ind =
318: DECODE(x_final_ind,
319: NULL, final_ind,
320: FND_API.G_MISS_CHAR, NULL,
321: x_final_ind),
322: forecast_ind =
323: DECODE(x_forecast_ind,
324: NULL, forecast_ind,

Line 325: FND_API.G_MISS_CHAR, NULL,

321: x_final_ind),
322: forecast_ind =
323: DECODE(x_forecast_ind,
324: NULL, forecast_ind,
325: FND_API.G_MISS_CHAR, NULL,
326: x_forecast_ind),
327: opening_ind =
328: DECODE(x_opening_ind,
329: NULL, opening_ind,

Line 330: FND_API.G_MISS_CHAR, NULL,

326: x_forecast_ind),
327: opening_ind =
328: DECODE(x_opening_ind,
329: NULL, opening_ind,
330: FND_API.G_MISS_CHAR, NULL,
331: x_opening_ind),
332: proforma_ind =
333: DECODE(x_proforma_ind,
334: NULL, proforma_ind,

Line 335: FND_API.G_MISS_CHAR, NULL,

331: x_opening_ind),
332: proforma_ind =
333: DECODE(x_proforma_ind,
334: NULL, proforma_ind,
335: FND_API.G_MISS_CHAR, NULL,
336: x_proforma_ind),
337: qualified_ind =
338: DECODE(x_qualified_ind,
339: NULL, qualified_ind,

Line 340: FND_API.G_MISS_CHAR, NULL,

336: x_proforma_ind),
337: qualified_ind =
338: DECODE(x_qualified_ind,
339: NULL, qualified_ind,
340: FND_API.G_MISS_CHAR, NULL,
341: x_qualified_ind),
342: restated_ind =
343: DECODE(x_restated_ind,
344: NULL, restated_ind,

Line 345: FND_API.G_MISS_CHAR, NULL,

341: x_qualified_ind),
342: restated_ind =
343: DECODE(x_restated_ind,
344: NULL, restated_ind,
345: FND_API.G_MISS_CHAR, NULL,
346: x_restated_ind),
347: signed_by_principals_ind =
348: DECODE(x_signed_by_principals_ind,
349: NULL, signed_by_principals_ind,

Line 350: FND_API.G_MISS_CHAR, NULL,

346: x_restated_ind),
347: signed_by_principals_ind =
348: DECODE(x_signed_by_principals_ind,
349: NULL, signed_by_principals_ind,
350: FND_API.G_MISS_CHAR, NULL,
351: x_signed_by_principals_ind),
352: trial_balance_ind =
353: DECODE(x_trial_balance_ind,
354: NULL, trial_balance_ind,

Line 355: FND_API.G_MISS_CHAR, NULL,

351: x_signed_by_principals_ind),
352: trial_balance_ind =
353: DECODE(x_trial_balance_ind,
354: NULL, trial_balance_ind,
355: FND_API.G_MISS_CHAR, NULL,
356: x_trial_balance_ind),
357: unbalanced_ind =
358: DECODE(x_unbalanced_ind,
359: NULL, unbalanced_ind,

Line 360: FND_API.G_MISS_CHAR, NULL,

356: x_trial_balance_ind),
357: unbalanced_ind =
358: DECODE(x_unbalanced_ind,
359: NULL, unbalanced_ind,
360: FND_API.G_MISS_CHAR, NULL,
361: x_unbalanced_ind),
362: content_source_type =
363: DECODE(x_content_source_type,
364: NULL, content_source_type,

Line 365: FND_API.G_MISS_CHAR, NULL,

361: x_unbalanced_ind),
362: content_source_type =
363: DECODE(x_content_source_type,
364: NULL, content_source_type,
365: FND_API.G_MISS_CHAR, NULL,
366: x_content_source_type),
367: created_by = created_by,
368: creation_date = creation_date,
369: last_update_login = hz_utility_v2pub.last_update_login,

Line 379: FND_API.G_MISS_CHAR, NULL,

375: program_update_date = hz_utility_v2pub.program_update_date,
376: status =
377: DECODE(x_status,
378: NULL, status,
379: FND_API.G_MISS_CHAR, NULL,
380: x_status),
381: object_version_number =
382: DECODE(x_object_version_number,
383: NULL, object_version_number,

Line 384: FND_API.G_MISS_NUM, NULL,

380: x_status),
381: object_version_number =
382: DECODE(x_object_version_number,
383: NULL, object_version_number,
384: FND_API.G_MISS_NUM, NULL,
385: x_object_version_number),
386: created_by_module =
387: DECODE(x_created_by_module,
388: NULL, created_by_module,

Line 389: FND_API.G_MISS_CHAR, NULL,

385: x_object_version_number),
386: created_by_module =
387: DECODE(x_created_by_module,
388: NULL, created_by_module,
389: FND_API.G_MISS_CHAR, NULL,
390: x_created_by_module),
391: application_id = hz_utility_v2pub.application_id/*,
392:
393: ** SSM SST Integration and Extension

Line 399: FND_API.G_MISS_CHAR, NULL,

395:
396: actual_content_source =
397: DECODE(x_actual_content_source,
398: NULL, actual_content_source,
399: FND_API.G_MISS_CHAR, NULL,
400: x_actual_content_source) */
401: WHERE rowid = x_rowid;
402:
403: IF ( SQL%NOTFOUND ) THEN

Line 619: NVL(financial_report_id, FND_API.G_MISS_NUM),

615: ) IS
616: BEGIN
617:
618: SELECT
619: NVL(financial_report_id, FND_API.G_MISS_NUM),
620: NVL(date_report_issued, FND_API.G_MISS_DATE),
621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),

Line 620: NVL(date_report_issued, FND_API.G_MISS_DATE),

616: BEGIN
617:
618: SELECT
619: NVL(financial_report_id, FND_API.G_MISS_NUM),
620: NVL(date_report_issued, FND_API.G_MISS_DATE),
621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),

Line 621: NVL(party_id, FND_API.G_MISS_NUM),

617:
618: SELECT
619: NVL(financial_report_id, FND_API.G_MISS_NUM),
620: NVL(date_report_issued, FND_API.G_MISS_DATE),
621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),

Line 622: NVL(document_reference, FND_API.G_MISS_CHAR),

618: SELECT
619: NVL(financial_report_id, FND_API.G_MISS_NUM),
620: NVL(date_report_issued, FND_API.G_MISS_DATE),
621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),

Line 623: NVL(issued_period, FND_API.G_MISS_CHAR),

619: NVL(financial_report_id, FND_API.G_MISS_NUM),
620: NVL(date_report_issued, FND_API.G_MISS_DATE),
621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),

Line 624: NVL(requiring_authority, FND_API.G_MISS_CHAR),

620: NVL(date_report_issued, FND_API.G_MISS_DATE),
621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),

Line 625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),

621: NVL(party_id, FND_API.G_MISS_NUM),
622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),

Line 626: NVL(report_start_date, FND_API.G_MISS_DATE),

622: NVL(document_reference, FND_API.G_MISS_CHAR),
623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),

Line 627: NVL(report_end_date, FND_API.G_MISS_DATE),

623: NVL(issued_period, FND_API.G_MISS_CHAR),
624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),

Line 628: NVL(audit_ind, FND_API.G_MISS_CHAR),

624: NVL(requiring_authority, FND_API.G_MISS_CHAR),
625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),

Line 629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),

625: NVL(type_of_financial_report, FND_API.G_MISS_CHAR),
626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),

Line 630: NVL(estimated_ind, FND_API.G_MISS_CHAR),

626: NVL(report_start_date, FND_API.G_MISS_DATE),
627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),

Line 631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),

627: NVL(report_end_date, FND_API.G_MISS_DATE),
628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),

Line 632: NVL(final_ind, FND_API.G_MISS_CHAR),

628: NVL(audit_ind, FND_API.G_MISS_CHAR),
629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),

Line 633: NVL(forecast_ind, FND_API.G_MISS_CHAR),

629: NVL(consolidated_ind, FND_API.G_MISS_CHAR),
630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),

Line 634: NVL(opening_ind, FND_API.G_MISS_CHAR),

630: NVL(estimated_ind, FND_API.G_MISS_CHAR),
631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),

Line 635: NVL(proforma_ind, FND_API.G_MISS_CHAR),

631: NVL(fiscal_ind, FND_API.G_MISS_CHAR),
632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),

Line 636: NVL(qualified_ind, FND_API.G_MISS_CHAR),

632: NVL(final_ind, FND_API.G_MISS_CHAR),
633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),

Line 637: NVL(restated_ind, FND_API.G_MISS_CHAR),

633: NVL(forecast_ind, FND_API.G_MISS_CHAR),
634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),

Line 638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),

634: NVL(opening_ind, FND_API.G_MISS_CHAR),
635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),

Line 639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),

635: NVL(proforma_ind, FND_API.G_MISS_CHAR),
636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),
643: NVL(actual_content_source, FND_API.G_MISS_CHAR),

Line 640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),

636: NVL(qualified_ind, FND_API.G_MISS_CHAR),
637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),
643: NVL(actual_content_source, FND_API.G_MISS_CHAR),
644: NVL(created_by_module, FND_API.G_MISS_CHAR)

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

637: NVL(restated_ind, FND_API.G_MISS_CHAR),
638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),
643: NVL(actual_content_source, FND_API.G_MISS_CHAR),
644: NVL(created_by_module, FND_API.G_MISS_CHAR)
645: INTO

Line 642: NVL(status, FND_API.G_MISS_CHAR),

638: NVL(signed_by_principals_ind, FND_API.G_MISS_CHAR),
639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),
643: NVL(actual_content_source, FND_API.G_MISS_CHAR),
644: NVL(created_by_module, FND_API.G_MISS_CHAR)
645: INTO
646: x_financial_report_id,

Line 643: NVL(actual_content_source, FND_API.G_MISS_CHAR),

639: NVL(trial_balance_ind, FND_API.G_MISS_CHAR),
640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),
643: NVL(actual_content_source, FND_API.G_MISS_CHAR),
644: NVL(created_by_module, FND_API.G_MISS_CHAR)
645: INTO
646: x_financial_report_id,
647: x_date_report_issued,

Line 644: NVL(created_by_module, FND_API.G_MISS_CHAR)

640: NVL(unbalanced_ind, FND_API.G_MISS_CHAR),
641: NVL(content_source_type, FND_API.G_MISS_CHAR),
642: NVL(status, FND_API.G_MISS_CHAR),
643: NVL(actual_content_source, FND_API.G_MISS_CHAR),
644: NVL(created_by_module, FND_API.G_MISS_CHAR)
645: INTO
646: x_financial_report_id,
647: x_date_report_issued,
648: x_party_id,

Line 681: RAISE FND_API.G_EXC_ERROR;

677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
678: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_financial_reports_rec');
679: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_financial_report_id));
680: FND_MSG_PUB.ADD;
681: RAISE FND_API.G_EXC_ERROR;
682:
683: END Select_Row;
684:
685: PROCEDURE Delete_Row (