1 package csi_t_txn_line_dtls_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivttds.pls 120.0 2005/05/24 18:35:28 appldev noship $*/
3
4 g_pkg_name varchar2(30) := 'csi_t_txn_line_dtls_pvt';
5
6 PROCEDURE create_txn_line_dtls(
7 p_api_version IN NUMBER,
8 p_commit IN VARCHAR2 := fnd_api.g_false,
9 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
10 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
11 p_txn_line_dtl_index IN NUMBER,
12 p_txn_line_dtl_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
13 px_txn_party_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
14 px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
15 px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
16 px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
17 px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2);
21
22 PROCEDURE update_txn_line_dtls (
23 p_api_version IN NUMBER
24 ,p_commit IN VARCHAR2 := fnd_api.g_false
25 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
26 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
27 ,p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec
28 ,p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl
29 ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
30 ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
31 ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
32 ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
33 ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
34 ,x_return_status OUT NOCOPY VARCHAR2
35 ,x_msg_count OUT NOCOPY NUMBER
36 ,x_msg_data OUT NOCOPY VARCHAR2);
37
38 PROCEDURE build_txn_lines_select(
39 p_txn_line_query_rec in csi_t_datastructures_grp.txn_line_query_rec,
40 x_lines_select_stmt OUT NOCOPY varchar2,
41 x_lines_restrict OUT NOCOPY varchar2,
42 x_return_status OUT NOCOPY varchar2);
43
44 PROCEDURE get_txn_line_dtls(
45 p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec,
46 p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec,
47 x_txn_line_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
48 x_return_status OUT NOCOPY varchar2);
49
50 PROCEDURE delete_txn_line_dtls(
51 p_api_version IN NUMBER
52 ,p_commit IN VARCHAR2 := fnd_api.g_false
53 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
54 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
55 ,p_txn_line_detail_ids_tbl IN csi_t_datastructures_grp.
56 txn_line_detail_ids_tbl
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2);
60
61 PROCEDURE update_txn_line(
62 p_txn_line_rec in csi_t_datastructures_grp.txn_line_rec,
63 x_return_status OUT NOCOPY varchar2);
64
65 END csi_t_txn_line_dtls_pvt;