APPS.ZX_ACCT_TAX_CLS_DEFS_PKG dependencies on ZX_ACCT_TX_CLS_DEFS_ALL

Line 17: -- recinfo A row from zx_acct_tx_cls_defs_all

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

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

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

Line 26: FROM zx_acct_tx_cls_defs_all

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

Line 50: recinfo zx_acct_tx_cls_defs_all%ROWTYPE;

46: x_org_id NUMBER,
47: x_tax_class IN OUT NOCOPY VARCHAr2,
48: x_tax_classification_code IN OUT NOCOPY VARCHAr2) IS
49:
50: recinfo zx_acct_tx_cls_defs_all%ROWTYPE;
51:
52: BEGIN
53: recinfo.ledger_id := x_ledger_id;
54: recinfo.org_id := x_org_id;

Line 77: FROM zx_acct_tx_cls_defs_all

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

Line 145: CURSOR C IS SELECT ROWID FROM ZX_ACCT_TX_CLS_DEFS_ALL

141: X_ATTRIBUTE12 VARCHAR2,
142: X_ATTRIBUTE13 VARCHAR2,
143: X_ATTRIBUTE14 VARCHAR2,
144: X_ATTRIBUTE15 VARCHAR2) IS
145: CURSOR C IS SELECT ROWID FROM ZX_ACCT_TX_CLS_DEFS_ALL
146: WHERE LEDGER_ID = X_LEDGER_ID
147: AND ORG_ID = X_ORG_ID;
148: dummy VARCHAR2(30);
149: BEGIN

Line 150: INSERT INTO ZX_ACCT_TX_CLS_DEFS_ALL

146: WHERE LEDGER_ID = X_LEDGER_ID
147: AND ORG_ID = X_ORG_ID;
148: dummy VARCHAR2(30);
149: BEGIN
150: INSERT INTO ZX_ACCT_TX_CLS_DEFS_ALL
151: (ledger_id,
152: org_id,
153: account_segment_value,
154: tax_class,

Line 252: UPDATE ZX_ACCT_TX_CLS_DEFS_ALL

248: X_ATTRIBUTE15 VARCHAR2,
249: X_ACCOUNT_SEGMENT_VALUE_ORIG VARCHAR2,
250: X_TAX_CLASS_ORIG VARCHAR2) IS
251: BEGIN
252: UPDATE ZX_ACCT_TX_CLS_DEFS_ALL
253: SET ledger_id = X_LEDGER_ID,
254: org_id = X_ORG_ID,
255: account_segment_value = X_ACCOUNT_SEGMENT_VALUE,
256: tax_class = X_TAX_CLASS,

Line 324: FROM ZX_ACCT_TX_CLS_DEFS_ALL

320: X_ATTRIBUTE14 VARCHAR2,
321: X_ATTRIBUTE15 VARCHAR2) IS
322: CURSOR C IS
323: SELECT *
324: FROM ZX_ACCT_TX_CLS_DEFS_ALL
325: WHERE ledger_id = X_LEDGER_ID
326: AND org_id = X_ORG_ID
327: AND account_segment_value = X_ACCOUNT_SEGMENT_VALUE
328: AND tax_class = X_TAX_CLASS