[Home] [Help]
PACKAGE: APPS.CSI_T_TXN_ATTRIBS_PVT
Source
1 PACKAGE csi_t_txn_attribs_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivteas.pls 120.0 2005/05/25 02:38:54 appldev noship $ */
3
4 PROCEDURE create_txn_ext_attrib_dtls(
5 p_api_version IN NUMBER,
6 p_commit IN VARCHAR2 := fnd_api.g_false,
7 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
8 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
9 p_txn_ext_attrib_vals_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_rec,
10 x_return_status OUT NOCOPY VARCHAR2,
11 x_msg_count OUT NOCOPY NUMBER,
12 x_msg_data OUT NOCOPY VARCHAR2);
13
14 PROCEDURE update_txn_ext_attrib_dtls
15 (
16 p_api_version IN NUMBER
17 ,p_commit IN VARCHAR2 := fnd_api.g_false
18 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
19 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
20 ,p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
21 ,x_return_status OUT NOCOPY VARCHAR2
22 ,x_msg_count OUT NOCOPY NUMBER
23 ,x_msg_data OUT NOCOPY VARCHAR2
24 );
25
26 PROCEDURE delete_txn_ext_attrib_dtls(
27 p_api_version IN NUMBER
28 ,p_commit IN VARCHAR2 := fnd_api.g_false
29 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
30 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
31 ,p_txn_ext_attrib_ids_tbl IN csi_t_datastructures_grp.
32 txn_ext_attrib_ids_tbl
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2);
36
37 PROCEDURE get_csi_ext_attrib_vals(
38 p_instance_id in number,
39 x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
40 x_return_status OUT NOCOPY varchar2);
41
42 PROCEDURE get_csi_ext_attribs(
43 p_line_dtl_id in number,
44 p_instance_id in number,
45 x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
46 x_return_status OUT NOCOPY varchar2);
47
48 PROCEDURE get_ext_attrib_dtls(
49 p_line_dtl_id in number,
50 x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
51 x_return_status OUT NOCOPY varchar2);
52
53 PROCEDURE get_all_csi_ext_attrib_vals(
54 p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
55 x_csi_ea_vals_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl,
56 x_return_status OUT NOCOPY varchar2);
57
58 PROCEDURE get_all_csi_ext_attribs(
59 p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
60 x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl,
61 x_return_status OUT NOCOPY varchar2);
62
63 PROCEDURE get_all_ext_attrib_dtls(
64 p_txn_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
65 x_ext_attrib_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
66 x_return_status OUT NOCOPY varchar2);
67
68 -- Added for CZ Integration (Begin)
69 PROCEDURE get_ext_attrib_id(
70 p_attrib_code IN VARCHAR2 ,
71 p_attrib_level IN VARCHAR2 ,
72 p_txn_line_detail_id IN NUMBER ,
73 x_attribute_id OUT NOCOPY NUMBER ,
74 x_source_table OUT NOCOPY VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_error_msg OUT NOCOPY VARCHAR2);
77
78 -- Added for CZ Integration (End)
79 END csi_t_txn_attribs_pvt;