APPS.ZX_ACCOUNT_TAX_RATES_PKG dependencies on ZX_ACCOUNT_RATES

Line 17: -- recinfo A row from zx_account_rates

13: -- the given ledger id and organization.
14: -- History
15: --
16: -- Arguments
17: -- recinfo A row from zx_account_rates
18: -- Example
19: -- gl_tax_options_pkg.select_row(recinfo);
20: -- Notes
21: --

Line 22: PROCEDURE select_row( recinfo IN OUT NOCOPY zx_account_rates%ROWTYPE ) IS

18: -- Example
19: -- gl_tax_options_pkg.select_row(recinfo);
20: -- Notes
21: --
22: PROCEDURE select_row( recinfo IN OUT NOCOPY zx_account_rates%ROWTYPE ) IS
23: BEGIN
24: SELECT *
25: INTO recinfo
26: FROM zx_account_rates

Line 26: FROM zx_account_rates

22: PROCEDURE select_row( recinfo IN OUT NOCOPY zx_account_rates%ROWTYPE ) IS
23: BEGIN
24: SELECT *
25: INTO recinfo
26: FROM zx_account_rates
27: WHERE ledger_id = recinfo.ledger_id
28: AND content_owner_id = recinfo.content_owner_id;
29: EXCEPTION
30: WHEN app_exceptions.application_exception THEN

Line 35: 'zx_account_rates.select_row');

31: RAISE;
32: WHEN OTHERS THEN
33: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
34: fnd_message.set_token('PROCEDURE',
35: 'zx_account_rates.select_row');
36: RAISE;
37: END select_row;
38:
39:

Line 50: recinfo zx_account_rates%ROWTYPE;

46: x_content_owner_id NUMBER,
47: x_tax_precision IN OUT NOCOPY NUMBER,
48: x_tax_mau IN OUT NOCOPY NUMBER) IS
49:
50: recinfo zx_account_rates%ROWTYPE;
51:
52: BEGIN
53: recinfo.ledger_id := x_ledger_id;
54: recinfo.content_owner_id := x_content_owner_id;

Line 65: 'zx_account_rates.select_columns');

61: RAISE;
62: WHEN OTHERS THEN
63: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
64: fnd_message.set_token('PROCEDURE',
65: 'zx_account_rates.select_columns');
66: RAISE;
67: END select_columns;
68:
69:

Line 77: FROM zx_account_rates

73: x_total NUMBER;
74: BEGIN
75: SELECT count(*)
76: INTO x_total
77: FROM zx_account_rates
78: WHERE ledger_id = x_ledger_id
79: AND content_owner_id = x_content_owner_id
80: AND ( x_rowid is null OR rowid <> x_rowid );
81:

Line 155: CURSOR C IS SELECT ROWID FROM ZX_ACCOUNT_RATES

151: X_ATTRIBUTE13 VARCHAR2,
152: X_ATTRIBUTE14 VARCHAR2,
153: X_ATTRIBUTE15 VARCHAR2,
154: X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2) IS
155: CURSOR C IS SELECT ROWID FROM ZX_ACCOUNT_RATES
156: WHERE LEDGER_ID = X_LEDGER_ID
157: AND CONTENT_OWNER_ID = X_CONTENT_OWNER_ID
158: AND (tax_class = X_TAX_CLASS OR
159: (tax_class IS NULL AND X_TAX_CLASS IS NULL) );

Line 162: INSERT INTO ZX_ACCOUNT_RATES

158: AND (tax_class = X_TAX_CLASS OR
159: (tax_class IS NULL AND X_TAX_CLASS IS NULL) );
160: dummy VARCHAR2(30);
161: BEGIN
162: INSERT INTO ZX_ACCOUNT_RATES
163: (ledger_id,
164: content_owner_id,
165: account_segment_value,
166: tax_precision,

Line 303: UPDATE ZX_ACCOUNT_RATES

299:
300: /******
301: BEGIN
302:
303: UPDATE ZX_ACCOUNT_RATES
304: SET tax_currency_code = X_TAX_CURRENCY_CODE,
305: tax_precision = X_TAX_PRECISION,
306: tax_mau = X_TAX_MAU,
307: calculation_level_code = X_CALCULATION_LEVEL_CODE,

Line 324: UPDATE ZX_ACCOUNT_RATES

320: ***/
321:
322: BEGIN
323:
324: UPDATE ZX_ACCOUNT_RATES
325: SET content_owner_id = X_CONTENT_OWNER_ID,
326: allow_rate_override_flag = X_ALLOW_RATE_OVERRIDE_FLAG,
327: -- tax_class = X_TAX_CLASS,
328: tax_regime_code = X_TAX_REGIME_CODE,

Line 378: UPDATE ZX_ACCOUNT_RATES

374:
375: ELSIF X_RECORD_LEVEL = 'ACCOUNT' then
376:
377:
378: UPDATE ZX_ACCOUNT_RATES
379: SET ledger_id = X_LEDGER_ID,
380: content_owner_id = X_CONTENT_OWNER_ID,
381: account_segment_value = X_ACCOUNT_SEGMENT_VALUE,
382: tax_precision = X_TAX_PRECISION,

Line 475: FROM ZX_ACCOUNT_RATES

471: X_ATTRIBUTE15 VARCHAR2,
472: X_ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2) IS
473: CURSOR C1 IS
474: SELECT *
475: FROM ZX_ACCOUNT_RATES
476: WHERE ledger_id = X_LEDGER_ID
477: AND content_owner_id = X_CONTENT_OWNER_ID
478: AND account_segment_value is null
479: AND (tax_class = X_TAX_CLASS OR

Line 485: FROM ZX_ACCOUNT_RATES

481: FOR UPDATE OF tax_currency_code NOWAIT;
482:
483: CURSOR C2 IS
484: SELECT *
485: FROM ZX_ACCOUNT_RATES
486: WHERE ledger_id = X_LEDGER_ID
487: AND content_owner_id = X_CONTENT_OWNER_ID
488: AND account_segment_value = X_ACCOUNT_SEGMENT_VALUE
489: AND (tax_class = X_TAX_CLASS OR