1 PACKAGE csi_t_txn_details_pvt AS
2 /* $Header: csivttxs.pls 120.2 2005/09/27 23:13:09 sumathur noship $ */
3
4
5 FUNCTION check_txn_details_exist(
6 p_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec)
7 RETURN BOOLEAN;
8
9
10 PROCEDURE create_transaction_dtls(
11 p_api_version IN NUMBER,
12 p_commit IN VARCHAR2 := fnd_api.g_false,
13 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
14 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
15 p_split_source_flag IN VARCHAR2 := fnd_api.g_false,
16 px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
17 px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
18 px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl ,
19 px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
20 px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
21 px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
22 px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
23 px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
24 x_return_status OUT NOCOPY VARCHAR2,
25 x_msg_count OUT NOCOPY NUMBER ,
26 x_msg_data OUT NOCOPY VARCHAR2);
27
28 PROCEDURE update_transaction_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_line_rec IN csi_t_datastructures_grp.txn_line_rec
34 ,px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
35 ,px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
36 ,px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
37 ,px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
38 ,px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
39 ,px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2);
43
44 /*
45 */
46 PROCEDURE delete_transaction_dtls
47 (
48 p_api_version IN NUMBER
49 ,p_commit IN VARCHAR2 := fnd_api.g_false
50 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
51 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
52 ,p_transaction_line_id IN NUMBER
53 ,p_txn_line_detail_id IN NUMBER -- added for Mass update R12
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 );
58
59 PROCEDURE get_transaction_details(
60 p_api_version IN NUMBER
61 ,p_commit IN VARCHAR2 := fnd_api.g_false
62 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
63 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
64 ,p_txn_line_query_rec IN csi_t_datastructures_grp.txn_line_query_rec
65 ,p_txn_line_detail_query_rec IN csi_t_datastructures_grp.txn_line_detail_query_rec
66 ,x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl
67 ,p_get_parties_flag IN VARCHAR2 := fnd_api.g_false
68 ,x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl
69 ,p_get_pty_accts_flag IN VARCHAR2 := fnd_api.g_false
70 ,x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl
71 ,p_get_ii_rltns_flag IN VARCHAR2 := fnd_api.g_false
72 ,x_txn_ii_rltns_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl
73 ,p_get_org_assgns_flag IN VARCHAR2 := fnd_api.g_false
74 ,x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl
75 ,p_get_ext_attrib_vals_flag IN VARCHAR2 := fnd_api.g_false
76 ,x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.
77 txn_ext_attrib_vals_tbl
78 ,p_get_csi_attribs_flag IN VARCHAR2 := fnd_api.g_false
79 ,x_csi_ext_attribs_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attribs_tbl
80 ,p_get_csi_iea_values_flag IN VARCHAR2 := fnd_api.g_false
81 ,x_csi_iea_values_tbl OUT NOCOPY csi_t_datastructures_grp.csi_ext_attrib_vals_tbl
82 ,p_get_txn_systems_flag IN VARCHAR2 := fnd_api.g_false
83 ,x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl
84 ,x_return_status OUT NOCOPY VARCHAR2
85 ,x_msg_count OUT NOCOPY NUMBER
86 ,x_msg_data OUT NOCOPY VARCHAR2);
87
88 PROCEDURE split_transaction_dtls(
89 p_api_version IN NUMBER,
90 p_commit IN VARCHAR2 := fnd_api.g_false,
91 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
92 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
93 p_upd_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
94 p_upd_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
95 px_crt_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
96 px_crt_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2);
100
101 PROCEDURE copy_transaction_dtls(
102 p_api_version IN NUMBER,
103 p_commit IN VARCHAR2 := fnd_api.g_false,
104 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
105 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
106 p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
107 px_new_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
108 p_copy_parties_flag IN varchar2 := fnd_api.g_true,
109 p_copy_pty_accts_flag IN varchar2 := fnd_api.g_true,
110 p_copy_ii_rltns_flag IN varchar2 := fnd_api.g_true,
111 p_copy_org_assgn_flag IN varchar2 := fnd_api.g_true,
112 p_copy_ext_attribs_flag IN varchar2 := fnd_api.g_true,
113 p_copy_txn_systems_flag IN varchar2 := fnd_api.g_true,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2);
117
118 PROCEDURE split_transaction_details(
119 p_api_version IN NUMBER,
120 p_commit IN VARCHAR2 := fnd_api.g_false,
121 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
122 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
123 p_src_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
124 px_split_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
125 px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
126 x_pty_dtl_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
127 x_pty_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
128 x_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
129 x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
130 x_txn_systems_tbl OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2 ) ;
134
135 END csi_t_txn_details_pvt;