DBA Data[Home] [Help]

APPS.GL_TAX_CODES_PKG dependencies on GL_TAX_CODES_V

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

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

Line 26: FROM gl_tax_codes_v

22: PROCEDURE select_row(recinfo IN OUT NOCOPY gl_tax_codes_v%ROWTYPE) IS
23: BEGIN
24: SELECT *
25: INTO recinfo
26: FROM gl_tax_codes_v
27: WHERE tax_code_id = recinfo.tax_code_id
28: AND tax_type_code in
29: (decode(recinfo.tax_type_code,'I', 'I', 'O', 'O'), 'T');
30: END SELECT_ROW;

Line 42: recinfo gl_tax_codes_v%ROWTYPE;

38: x_tax_code_id NUMBER,
39: x_tax_type_code VARCHAR2,
40: x_tax_code IN OUT NOCOPY VARCHAR2) IS
41:
42: recinfo gl_tax_codes_v%ROWTYPE;
43:
44: BEGIN
45: recinfo.tax_code_id := x_tax_code_id;
46: recinfo.tax_type_code := x_tax_type_code;