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_T_TXN_DETAILS_PVT dependencies on CSI_T_TRANSACTION_LINES

Line 61: 'select 1 l_value from csi_t_transaction_lines where '||l_lines_where_clause;

57: x_return_status => l_return_status);
58:
59: IF l_lines_restrict = 'Y' THEN
60: l_select_stmt :=
61: 'select 1 l_value from csi_t_transaction_lines where '||l_lines_where_clause;
62:
63: IF l_debug_level > 10 THEN
64: csi_t_gen_utility_pvt.add(' Select Stmt:'||l_select_stmt);
65: END IF;

Line 226: SELECT csi_t_transaction_lines_s2.nextval

222: -- Main API code starts here
223: -- Added for CZ Integration (Begin)
224: IF px_txn_line_rec.source_transaction_type_id = 401 THEN
225: IF px_txn_line_rec.source_transaction_table <> 'WSH_DELIVERY_DETAILS' THEN --Added for bug5194812
226: SELECT csi_t_transaction_lines_s2.nextval
227: INTO px_txn_line_rec.source_transaction_id
228: FROM dual;
229: px_txn_line_rec.source_transaction_table := 'CONFIGURATOR' ; --????
230: END IF;--Added for bug5194812

Line 256: FROM csi_t_transaction_lines

252: -- duplicate check(will have to move to the validation routines)
253: IF nvl(px_txn_line_rec.transaction_line_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
254: BEGIN
255: SELECT 'Y' INTO l_skip_tl_create
256: FROM csi_t_transaction_lines
257: WHERE transaction_line_id = px_txn_line_rec.transaction_line_id;
258: EXCEPTION
259: WHEN no_data_found THEN
260: l_skip_tl_create := 'N';

Line 365: -- call table handler to populate the csi_t_transaction_lines table

361: END IF;
362:
363:
364: IF l_skip_tl_create <> 'Y' THEN
365: -- call table handler to populate the csi_t_transaction_lines table
366:
367: csi_t_gen_utility_pvt.dump_api_info(
368: p_api_name => 'insert_row',
369: p_pkg_name => 'csi_t_transaction_lines_pkg');

Line 369: p_pkg_name => 'csi_t_transaction_lines_pkg');

365: -- call table handler to populate the csi_t_transaction_lines table
366:
367: csi_t_gen_utility_pvt.dump_api_info(
368: p_api_name => 'insert_row',
369: p_pkg_name => 'csi_t_transaction_lines_pkg');
370:
371: BEGIN
372:
373: -- Added for CZ Integration (End)

Line 374: csi_t_transaction_lines_pkg.insert_row(

370:
371: BEGIN
372:
373: -- Added for CZ Integration (End)
374: csi_t_transaction_lines_pkg.insert_row(
375: px_transaction_line_id => l_txn_line_id,
376: p_source_transaction_type_id => px_txn_line_rec.source_transaction_type_id,
377: p_source_transaction_table => px_txn_line_rec.source_transaction_table,
378: p_source_txn_header_id => px_txn_line_rec.source_txn_header_id,

Line 2074: csi_t_transaction_lines_pkg.delete_row(

2070: END IF;
2071:
2072: -- call table handler to delete transaction lines
2073: IF nvl(p_txn_line_detail_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
2074: csi_t_transaction_lines_pkg.delete_row(
2075: p_transaction_line_id => p_transaction_line_id);
2076: END IF;
2077:
2078: -- Standard check of p_commit.

Line 2892: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;

2888:
2889: l_ln_id_ind binary_integer;
2890:
2891: l_line_dtl_ids_tbl csi_t_datastructures_grp.txn_line_detail_ids_tbl;
2892: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
2893:
2894: l_create boolean := FALSE;
2895:
2896: BEGIN

Line 3074: FROM csi_t_transaction_lines

3070: IF l_return_status = fnd_api.g_ret_sts_success THEN
3071:
3072: SELECT transaction_line_id
3073: INTO l_txn_line_id
3074: FROM csi_t_transaction_lines
3075: WHERE source_transaction_table = px_crt_txn_line_rec.source_transaction_table
3076: AND source_transaction_id = px_crt_txn_line_rec.source_transaction_id;
3077:
3078: ELSE

Line 3086: p_pkg_name => 'csi_t_transaction_lines_pkg');

3082: ELSE
3083:
3084: csi_t_gen_utility_pvt.dump_api_info(
3085: p_api_name => 'insert_row',
3086: p_pkg_name => 'csi_t_transaction_lines_pkg');
3087:
3088: csi_t_transaction_lines_pkg.insert_row(
3089: px_transaction_line_id => l_txn_line_id,
3090: p_source_transaction_type_id => px_crt_txn_line_rec.source_transaction_type_id,

Line 3088: csi_t_transaction_lines_pkg.insert_row(

3084: csi_t_gen_utility_pvt.dump_api_info(
3085: p_api_name => 'insert_row',
3086: p_pkg_name => 'csi_t_transaction_lines_pkg');
3087:
3088: csi_t_transaction_lines_pkg.insert_row(
3089: px_transaction_line_id => l_txn_line_id,
3090: p_source_transaction_type_id => px_crt_txn_line_rec.source_transaction_type_id,
3091: p_source_transaction_table => px_crt_txn_line_rec.source_transaction_table,
3092: p_source_txn_header_id => px_crt_txn_line_rec.source_txn_header_id,

Line 3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;

3222: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3223: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3224: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
3225:
3226: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3227: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
3228: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3229:
3230: BEGIN

Line 3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;

3458: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
3459: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
3460: l_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
3461: l_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
3462: l_txn_line_id csi_t_transaction_lines.transaction_line_id%type;
3463: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
3464:
3465: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3466: l_msg_count number;