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:
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
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,
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,
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,
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,
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 ,
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,
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,
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,
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,
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);
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,
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,
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,