DBA Data[Home] [Help]

APPS.HZ_FINANCIAL_NUMBERS_PKG dependencies on HZ_FINANCIAL_NUMBERS_S

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