1 PACKAGE csi_t_txn_parties_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivtpas.pls 115.6 2002/11/12 00:32:14 rmamidip noship $ */
3
4 PROCEDURE create_txn_party_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_party_dtl_index IN NUMBER,
10 p_txn_party_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_rec,
11 px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
12 x_return_status OUT NOCOPY VARCHAR2,
13 x_msg_count OUT NOCOPY NUMBER,
14 x_msg_data OUT NOCOPY VARCHAR2);
15
16
17 PROCEDURE create_txn_pty_acct_dtls(
18 p_api_version IN NUMBER,
19 p_commit IN VARCHAR2 := fnd_api.g_false,
20 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
21 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
22 p_txn_pty_acct_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_rec,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 x_msg_data OUT NOCOPY VARCHAR2);
26
27
28 PROCEDURE update_txn_party_dtls(
29 p_api_version IN NUMBER,
30 p_commit IN VARCHAR2 := fnd_api.g_false,
31 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
32 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
33 p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
34 px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2);
38
39 /*
40 */
41 PROCEDURE update_txn_pty_acct_dtls
42 (
43 p_api_version IN NUMBER
44 ,p_commit IN VARCHAR2 := fnd_api.g_false
45 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
46 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
47 ,p_txn_pty_acct_detail_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53
54 PROCEDURE delete_txn_party_dtls
55 (
56 p_api_version IN NUMBER
57 ,p_commit IN VARCHAR2 := fnd_api.g_false
58 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
59 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
60 ,p_txn_party_ids_tbl IN csi_t_datastructures_grp.txn_party_ids_tbl
61 ,x_txn_pty_acct_ids_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_ids_tbl
62 ,x_return_status OUT NOCOPY VARCHAR2
63 ,x_msg_count OUT NOCOPY NUMBER
64 ,x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE delete_txn_pty_acct_dtls
68 (
69 p_api_version IN NUMBER
70 ,p_commit IN VARCHAR2 := fnd_api.g_false
71 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
72 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
73 ,p_txn_pty_acct_ids_tbl IN csi_t_datastructures_grp.txn_pty_acct_ids_tbl
74 ,x_return_status OUT NOCOPY VARCHAR2
75 ,x_msg_count OUT NOCOPY NUMBER
76 ,x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE get_pty_acct_dtls(
80 p_party_dtl_id in number,
81 x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
82 x_return_status OUT NOCOPY varchar2);
83
84 PROCEDURE get_party_dtls(
85 p_line_dtl_id in number,
86 x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
87 x_return_status OUT NOCOPY varchar2);
88
89 PROCEDURE get_all_party_dtls(
90 p_line_detail_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
91 x_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
92 x_return_status OUT NOCOPY varchar2);
93
94 PROCEDURE get_all_pty_acct_dtls(
95 p_party_detail_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,
96 x_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
97 x_return_status OUT NOCOPY varchar2);
98
99 END csi_t_txn_parties_pvt;