APPS.HZ_FINANCIAL_REPORTS_PKG dependencies on HZ_FINANCIAL_REPORTS

Line 1: PACKAGE BODY HZ_FINANCIAL_REPORTS_PKG as

1: PACKAGE BODY HZ_FINANCIAL_REPORTS_PKG as
2: /* $Header: ARHOFRTB.pls 120.9 2005/10/30 04:20:52 appldev ship $ */
3:
4: G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5: PROCEDURE Insert_Row (

Line 42: INSERT INTO HZ_FINANCIAL_REPORTS (

38: BEGIN
39:
40: WHILE l_success = 'N' LOOP
41: BEGIN
42: INSERT INTO HZ_FINANCIAL_REPORTS (
43: financial_report_id,
44: date_report_issued,
45: party_id,
46: document_reference,

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 188: IF INSTR(SQLERRM, 'HZ_FINANCIAL_REPORTS_U1') <> 0 THEN

184: l_success := 'Y';
185:
186: EXCEPTION
187: WHEN DUP_VAL_ON_INDEX THEN
188: IF INSTR(SQLERRM, 'HZ_FINANCIAL_REPORTS_U1') <> 0 THEN
189: DECLARE
190: l_count NUMBER;
191: l_dummy VARCHAR2(1);
192: BEGIN

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

Line 199: FROM HZ_FINANCIAL_REPORTS

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
200: WHERE financial_report_id = x_financial_report_id;
201: l_count := 1;
202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN

Line 250: UPDATE HZ_FINANCIAL_REPORTS

246: x_actual_content_source IN VARCHAR2
247: ) IS
248: BEGIN
249:
250: UPDATE HZ_FINANCIAL_REPORTS
251: SET
252: financial_report_id =
253: DECODE(x_financial_report_id,
254: NULL, financial_report_id,

Line 451: SELECT * FROM hz_financial_reports

447: x_actual_content_source IN VARCHAR2
448: ) IS
449:
450: CURSOR c IS
451: SELECT * FROM hz_financial_reports
452: WHERE rowid = x_rowid
453: FOR UPDATE NOWAIT;
454: Recinfo c%ROWTYPE;
455:

Line 672: FROM HZ_FINANCIAL_REPORTS

668: x_content_source_type,
669: x_status,
670: x_actual_content_source,
671: x_created_by_module
672: FROM HZ_FINANCIAL_REPORTS
673: WHERE financial_report_id = x_financial_report_id;
674:
675: EXCEPTION
676: WHEN NO_DATA_FOUND THEN

Line 678: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_financial_reports_rec');

674:
675: EXCEPTION
676: WHEN NO_DATA_FOUND THEN
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:

Line 690: DELETE FROM HZ_FINANCIAL_REPORTS

686: x_financial_report_id IN NUMBER
687: ) IS
688: BEGIN
689:
690: DELETE FROM HZ_FINANCIAL_REPORTS
691: WHERE financial_report_id = x_financial_report_id;
692:
693: IF ( SQL%NOTFOUND ) THEN
694: RAISE NO_DATA_FOUND;

Line 699: END HZ_FINANCIAL_REPORTS_PKG;

695: END IF;
696:
697: END Delete_Row;
698:
699: END HZ_FINANCIAL_REPORTS_PKG;