APPS.POS_TAX_REPORT_BO_PKG dependencies on POS_TAX_REPORT_BO_TBL

Line 4: PROCEDURE get_pos_tax_report_bo_tbl

1: PACKAGE BODY pos_tax_report_bo_pkg AS
2: /* $Header: POSSPTXRB.pls 120.1 2010/11/25 12:19:30 puppulur noship $ */
3:
4: PROCEDURE get_pos_tax_report_bo_tbl
5: (
6: p_api_version IN NUMBER DEFAULT NULL,
7: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
8: p_party_id IN NUMBER,

Line 11: x_pos_tax_report_bo_tbl OUT NOCOPY pos_tax_report_bo_tbl,

7: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
8: p_party_id IN NUMBER,
9: p_orig_system IN VARCHAR2,
10: p_orig_system_reference IN VARCHAR2,
11: x_pos_tax_report_bo_tbl OUT NOCOPY pos_tax_report_bo_tbl,
12: x_return_status OUT NOCOPY VARCHAR2,
13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2
15: ) IS

Line 17: l_pos_tax_report_bo_tbl pos_tax_report_bo_tbl := pos_tax_report_bo_tbl();

13: x_msg_count OUT NOCOPY NUMBER,
14: x_msg_data OUT NOCOPY VARCHAR2
15: ) IS
16:
17: l_pos_tax_report_bo_tbl pos_tax_report_bo_tbl := pos_tax_report_bo_tbl();
18:
19: l_party_id NUMBER;
20: BEGIN
21: x_return_status := fnd_api.g_ret_sts_success;

Line 49: INTO l_pos_tax_report_bo_tbl

45: reporting_code_num_value,
46: reporting_type_id,
47: reporting_code_id,
48: object_version_number) BULK COLLECT
49: INTO l_pos_tax_report_bo_tbl
50: FROM zx_report_codes_assoc
51: WHERE entity_id = l_party_id;
52:
53: x_pos_tax_report_bo_tbl := l_pos_tax_report_bo_tbl;

Line 53: x_pos_tax_report_bo_tbl := l_pos_tax_report_bo_tbl;

49: INTO l_pos_tax_report_bo_tbl
50: FROM zx_report_codes_assoc
51: WHERE entity_id = l_party_id;
52:
53: x_pos_tax_report_bo_tbl := l_pos_tax_report_bo_tbl;
54: EXCEPTION
55: WHEN fnd_api.g_exc_error THEN
56:
57: x_return_status := fnd_api.g_ret_sts_error;

Line 72: END get_pos_tax_report_bo_tbl;

68:
69: x_msg_count := 1;
70: x_msg_data := SQLCODE || SQLERRM;
71:
72: END get_pos_tax_report_bo_tbl;
73:
74: PROCEDURE create_pos_tax_report_bo_row
75: (
76: p_api_version IN NUMBER DEFAULT NULL,

Line 82: p_pos_tax_report_bo IN pos_tax_report_bo_tbl,

78: p_party_id IN NUMBER,
79: p_orig_system IN VARCHAR2,
80: p_orig_system_reference IN VARCHAR2,
81: p_create_update_flag IN VARCHAR2,
82: p_pos_tax_report_bo IN pos_tax_report_bo_tbl,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2
86: ) IS