DBA Data[Home] [Help]

APPS.HZ_FINANCIAL_REPORTS_PKG dependencies on HZ_FINANCIAL_REPORTS_S

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 84: NULL, HZ_FINANCIAL_REPORTS_S.NEXTVAL,

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

Line 195: SELECT HZ_FINANCIAL_REPORTS_S.NEXTVAL

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