APPS.HZ_FINANCIAL_NUMBERS_PKG dependencies on HZ_FINANCIAL_NUMBERS

Line 1: PACKAGE BODY HZ_FINANCIAL_NUMBERS_PKG as

1: PACKAGE BODY HZ_FINANCIAL_NUMBERS_PKG as
2: /* $Header: ARHOFNTB.pls 120.5 2005/05/25 23:51:58 achung ship $ */
3:
4: G_MISS_CONTENT_SOURCE_TYPE CONSTANT VARCHAR2(30) := 'USER_ENTERED';
5:

Line 28: INSERT INTO HZ_FINANCIAL_NUMBERS (

24: BEGIN
25:
26: WHILE l_success = 'N' LOOP
27: BEGIN
28: INSERT INTO HZ_FINANCIAL_NUMBERS (
29: financial_number_id,
30: financial_report_id,
31: financial_number,
32: financial_number_name,

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 55: NULL, HZ_FINANCIAL_NUMBERS_S.NEXTVAL,

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,
59: x_financial_report_id),

Line 114: IF INSTR(SQLERRM, 'HZ_FINANCIAL_NUMBERS_U1') <> 0 THEN

110: l_success := 'Y';
111:
112: EXCEPTION
113: WHEN DUP_VAL_ON_INDEX THEN
114: IF INSTR(SQLERRM, 'HZ_FINANCIAL_NUMBERS_U1') <> 0 THEN
115: DECLARE
116: l_count NUMBER;
117: l_dummy VARCHAR2(1);
118: BEGIN

Line 121: SELECT HZ_FINANCIAL_NUMBERS_S.NEXTVAL

117: l_dummy VARCHAR2(1);
118: BEGIN
119: l_count := 1;
120: WHILE l_count > 0 LOOP
121: SELECT HZ_FINANCIAL_NUMBERS_S.NEXTVAL
122: INTO x_financial_number_id FROM dual;
123: BEGIN
124: SELECT 'Y' INTO l_dummy
125: FROM HZ_FINANCIAL_NUMBERS

Line 125: FROM HZ_FINANCIAL_NUMBERS

121: SELECT HZ_FINANCIAL_NUMBERS_S.NEXTVAL
122: INTO x_financial_number_id FROM dual;
123: BEGIN
124: SELECT 'Y' INTO l_dummy
125: FROM HZ_FINANCIAL_NUMBERS
126: WHERE financial_number_id = x_financial_number_id;
127: l_count := 1;
128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN

Line 158: UPDATE HZ_FINANCIAL_NUMBERS

154: x_actual_content_source IN VARCHAR2
155: ) IS
156: BEGIN
157:
158: UPDATE HZ_FINANCIAL_NUMBERS
159: SET
160: financial_number_id =
161: DECODE(x_financial_number_id,
162: NULL, financial_number_id,

Line 269: SELECT * FROM hz_financial_numbers

265: x_actual_content_source IN VARCHAR2
266: ) IS
267:
268: CURSOR c IS
269: SELECT * FROM hz_financial_numbers
270: WHERE rowid = x_rowid
271: FOR UPDATE NOWAIT;
272: Recinfo c%ROWTYPE;
273:

Line 397: FROM HZ_FINANCIAL_NUMBERS

393: x_projected_actual_flag,
394: x_content_source_type,
395: x_status,
396: x_actual_content_source
397: FROM HZ_FINANCIAL_NUMBERS
398: WHERE financial_number_id = x_financial_number_id;
399:
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN

Line 415: DELETE FROM HZ_FINANCIAL_NUMBERS

411: x_financial_number_id IN NUMBER
412: ) IS
413: BEGIN
414:
415: DELETE FROM HZ_FINANCIAL_NUMBERS
416: WHERE financial_number_id = x_financial_number_id;
417:
418: IF ( SQL%NOTFOUND ) THEN
419: RAISE NO_DATA_FOUND;

Line 424: END HZ_FINANCIAL_NUMBERS_PKG;

420: END IF;
421:
422: END Delete_Row;
423:
424: END HZ_FINANCIAL_NUMBERS_PKG;