1 PACKAGE csi_transactions_pvt AUTHID CURRENT_USER AS
2 /* $Header: csivtrxs.pls 115.14 2003/09/04 23:58:35 sguthiva ship $ */
3 -- start OF comments
4 -- package name : csi_transactions_pvt
5 -- purpose :
6 -- history :
7 -- note :
8 -- end OF comments
9
10 -- default NUMBER OF records fetch per call
11 g_default_num_rec_fetch NUMBER := 30;
12 g_trans_date DATE :=sysdate;
13
14
15 TYPE util_order_by_rec_type IS RECORD (
16 col_choice NUMBER := fnd_api.g_miss_num,
17 col_name VARCHAR2(30) := fnd_api.g_miss_char);
18
19 g_miss_util_order_by_rec util_order_by_rec_type;
20
21 TYPE util_order_by_tbl_type IS TABLE OF util_order_by_rec_type
22 INDEX BY BINARY_INTEGER;
23
24
25 PROCEDURE get_transactions(
26 p_api_version_number IN NUMBER,
27 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
28 p_commit IN VARCHAR2 := fnd_api.g_false,
29 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
30 p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
31 p_rec_requested IN NUMBER := g_default_num_rec_fetch,
32 p_start_rec_prt IN NUMBER := 1,
33 p_return_tot_count IN VARCHAR2 := fnd_api.g_false,
34 p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_transaction_tbl OUT NOCOPY csi_datastructures_pub.transaction_header_tbl,
39 x_returned_rec_count OUT NOCOPY NUMBER,
40 x_next_rec_ptr OUT NOCOPY NUMBER,
41 x_tot_rec_count OUT NOCOPY NUMBER);
42
43
44
45 /* ---------------------------------------------------------------------------------- */
46 /* --- this PROCEDURE IS used to accept AND validate parameters --- */
47 /* --- before inserting INTO csi_transactions table. --- */
48 /* ---------------------------------------------------------------------------------- */
49
50 PROCEDURE create_transaction(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
53 p_commit IN VARCHAR2 := fnd_api.g_false,
54 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
55 p_success_if_exists_flag IN VARCHAR2 := 'N',
56 p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec ,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2);
60
61
62 /* ---------------------------------------------------------------------------------- */
63 /* --- this PROCEDURE IS used to accept AND validate parameters --- */
64 /* --- before updating INTO csi_transactions table. --- */
65 /* ---------------------------------------------------------------------------------- */
66
67 PROCEDURE update_transactions(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
70 p_commit IN VARCHAR2 := fnd_api.g_false,
71 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
72 p_transaction_rec IN csi_datastructures_pub.transaction_rec,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2);
76
77 /* ---------------------------------------------------------------------------------- */
78 /* --- this PROCEDURE IS used to insert INTO csi_txn_errors table. --- */
79 /* ---------------------------------------------------------------------------------- */
80
81
82 PROCEDURE create_txn_error(
83 p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
85 p_commit IN VARCHAR2 := fnd_api.g_false,
86 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
87 p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_transaction_error_id OUT NOCOPY NUMBER);
92
93 END csi_transactions_pvt;