eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_TRANSACTIONS_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 21: p_txnfind_rec IN csi_datastructures_pub.transaction_header_rec,

17: /* ---------------------------------------------------------------------------------- */
18:
19: -- this procudure defines the columns for the dynamic sql.
20: PROCEDURE define_columns(
21: p_txnfind_rec IN csi_datastructures_pub.transaction_header_rec,
22: p_cur_get_transactions IN NUMBER
23: )
24: IS
25: BEGIN

Line 71: x_txnfind_rec OUT NOCOPY csi_datastructures_pub.transaction_header_rec

67:
68: -- This procudure gets column values by the dynamic sql.
69: PROCEDURE get_column_values(
70: p_cur_get_transactions IN NUMBER,
71: x_txnfind_rec OUT NOCOPY csi_datastructures_pub.transaction_header_rec
72: )
73: IS
74: BEGIN
75: -- get all column values for csi_transactions table

Line 119: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,

115: END get_column_values;
116:
117:
118: PROCEDURE gen_transactions_order_cl(
119: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,
120: x_order_by_cl OUT NOCOPY VARCHAR2,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2

Line 147: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,

143: END gen_transactions_order_cl;
144:
145: -- This procedure bind the variables for the dynamic sql
146: PROCEDURE bind(
147: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,
148: p_cur_get_transactions IN NUMBER
149: )
150: IS
151: BEGIN

Line 242: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,

238: /* --- else from csi_transactions --- */
239: /* ---------------------------------------------------------------------------------- */
240:
241: PROCEDURE gen_select(
242: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,
243: x_select_cl OUT NOCOPY VARCHAR2
244: )
245: IS
246: l_table_name VARCHAR2(30);

Line 269: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,

265: END gen_select;
266:
267:
268: PROCEDURE gen_transactions_where(
269: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,
270: x_transactions_where OUT NOCOPY VARCHAR2
271: )
272: IS
273: -- cursors to check if wildcard values '%' and '_' have been passed

Line 605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,

601: p_api_version_number IN NUMBER,
602: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
603: p_commit IN VARCHAR2 := fnd_api.g_false,
604: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
606: p_rec_requested IN NUMBER := g_default_num_rec_fetch,
607: p_start_rec_prt IN NUMBER := 1,
608: p_return_tot_count IN VARCHAR2 := fnd_api.g_false,
609: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,

Line 609: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,

605: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec ,
606: p_rec_requested IN NUMBER := g_default_num_rec_fetch,
607: p_start_rec_prt IN NUMBER := 1,
608: p_return_tot_count IN VARCHAR2 := fnd_api.g_false,
609: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
613: x_transaction_tbl OUT NOCOPY csi_datastructures_pub.transaction_header_tbl,

Line 613: x_transaction_tbl OUT NOCOPY csi_datastructures_pub.transaction_header_tbl,

609: p_order_by_rec IN csi_datastructures_pub.transaction_sort_rec,
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,
613: x_transaction_tbl OUT NOCOPY csi_datastructures_pub.transaction_header_tbl,
614: x_returned_rec_count OUT NOCOPY NUMBER,
615: x_next_rec_ptr OUT NOCOPY NUMBER,
616: x_tot_rec_count OUT NOCOPY NUMBER
617: )

Line 637: l_transaction_rec csi_datastructures_pub.transaction_query_rec;

633: l_select_cl VARCHAR2(2000) := '';
634: l_order_by_cl VARCHAR2(2000);
635: l_transactions_where VARCHAR2(2000) := '';
636: -- local scratch record
637: l_transaction_rec csi_datastructures_pub.transaction_query_rec;
638: l_crit_transaction_rec csi_datastructures_pub.transaction_query_rec :=p_txnfind_rec;
639:
640: l_txn_rec csi_datastructures_pub.transaction_header_rec;
641: l_def_transaction_rec csi_datastructures_pub.transaction_header_rec;

Line 638: l_crit_transaction_rec csi_datastructures_pub.transaction_query_rec :=p_txnfind_rec;

634: l_order_by_cl VARCHAR2(2000);
635: l_transactions_where VARCHAR2(2000) := '';
636: -- local scratch record
637: l_transaction_rec csi_datastructures_pub.transaction_query_rec;
638: l_crit_transaction_rec csi_datastructures_pub.transaction_query_rec :=p_txnfind_rec;
639:
640: l_txn_rec csi_datastructures_pub.transaction_header_rec;
641: l_def_transaction_rec csi_datastructures_pub.transaction_header_rec;
642: l_debug_level NUMBER;

Line 640: l_txn_rec csi_datastructures_pub.transaction_header_rec;

636: -- local scratch record
637: l_transaction_rec csi_datastructures_pub.transaction_query_rec;
638: l_crit_transaction_rec csi_datastructures_pub.transaction_query_rec :=p_txnfind_rec;
639:
640: l_txn_rec csi_datastructures_pub.transaction_header_rec;
641: l_def_transaction_rec csi_datastructures_pub.transaction_header_rec;
642: l_debug_level NUMBER;
643:
644:

Line 641: l_def_transaction_rec csi_datastructures_pub.transaction_header_rec;

637: l_transaction_rec csi_datastructures_pub.transaction_query_rec;
638: l_crit_transaction_rec csi_datastructures_pub.transaction_query_rec :=p_txnfind_rec;
639:
640: l_txn_rec csi_datastructures_pub.transaction_header_rec;
641: l_def_transaction_rec csi_datastructures_pub.transaction_header_rec;
642: l_debug_level NUMBER;
643:
644:
645: BEGIN

Line 968: p_transaction_rec IN csi_datastructures_pub.transaction_rec,

964: PROCEDURE validate_transactions(
965: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
966: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
967: p_validation_mode IN VARCHAR2,
968: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
969: x_return_status OUT NOCOPY VARCHAR2,
970: x_msg_count OUT NOCOPY NUMBER,
971: x_msg_data OUT NOCOPY VARCHAR2
972: );

Line 986: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec ,

982: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
983: p_commit IN VARCHAR2 := fnd_api.g_false,
984: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
985: p_success_if_exists_flag IN VARCHAR2 := 'N',
986: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec ,
987: x_return_status OUT NOCOPY VARCHAR2,
988: x_msg_count OUT NOCOPY NUMBER,
989: x_msg_data OUT NOCOPY VARCHAR2
990: )

Line 1295: p_transaction_rec IN csi_datastructures_pub.transaction_rec,

1291: p_api_version IN NUMBER,
1292: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1293: p_commit IN VARCHAR2 := fnd_api.g_false,
1294: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1295: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
1296: x_return_status OUT NOCOPY VARCHAR2,
1297: x_msg_count OUT NOCOPY NUMBER,
1298: x_msg_data OUT NOCOPY VARCHAR2
1299: )

Line 1302: CURSOR lock_csr (p_transaction_rec IN csi_datastructures_pub.transaction_rec) IS

1298: x_msg_data OUT NOCOPY VARCHAR2
1299: )
1300:
1301: IS
1302: CURSOR lock_csr (p_transaction_rec IN csi_datastructures_pub.transaction_rec) IS
1303: SELECT object_version_number
1304: FROM csi_transactions
1305: WHERE transaction_id = p_transaction_rec.transaction_id
1306: FOR UPDATE OF object_version_number;

Line 1312: l_tar_transaction_rec csi_datastructures_pub.transaction_rec := p_transaction_rec;

1308:
1309: l_api_name CONSTANT VARCHAR2(30) := 'update_transactions';
1310: l_api_version CONSTANT NUMBER := 1.0;
1311: -- local variables
1312: l_tar_transaction_rec csi_datastructures_pub.transaction_rec := p_transaction_rec;
1313: l_row_notfound BOOLEAN := FALSE;
1314: l_object_version_number NUMBER;
1315: l_last_update_date DATE;
1316: l_rowid ROWID;

Line 1499: p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec,

1495: p_api_version IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1497: p_commit IN VARCHAR2 := fnd_api.g_false,
1498: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1499: p_txn_error_rec IN csi_datastructures_pub.transaction_error_rec,
1500: x_return_status OUT NOCOPY VARCHAR2,
1501: x_msg_count OUT NOCOPY NUMBER,
1502: x_msg_data OUT NOCOPY VARCHAR2,
1503: x_transaction_error_id OUT NOCOPY NUMBER

Line 2043: p_transaction_rec IN csi_datastructures_pub.transaction_rec,

2039: PROCEDURE validate_transactions(
2040: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2041: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2042: p_validation_mode IN VARCHAR2,
2043: p_transaction_rec IN csi_datastructures_pub.transaction_rec,
2044: x_return_status OUT NOCOPY VARCHAR2,
2045: x_msg_count OUT NOCOPY NUMBER,
2046: x_msg_data OUT NOCOPY VARCHAR2
2047: )