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),
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),
88: x_date_report_issued),
191: l_dummy VARCHAR2(1);
192: BEGIN
193: l_count := 1;
194: WHILE l_count > 0 LOOP
195: SELECT HZ_FINANCIAL_REPORTS_S.NEXTVAL
196: INTO x_financial_report_id FROM dual;
197: BEGIN
198: SELECT 'Y' INTO l_dummy
199: FROM HZ_FINANCIAL_REPORTS