APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_T_TRANSACTION_LINES

Line 88: FROM csi_t_transaction_lines

84: config_session_hdr_id,
85: config_session_item_id,
86: config_session_rev_num,
87: config_valid_status
88: FROM csi_t_transaction_lines
89: where transaction_line_id = p_txn_line_id;
90:
91: l_txn_line_rec txn_line_cur%rowtype;
92: BEGIN

Line 345: l_processing_status csi_t_transaction_lines.processing_status%TYPE;

341: p_transaction_line_id IN NUMBER,
342: x_return_status OUT NOCOPY VARCHAR2)
343: IS
344:
345: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
346: l_processed_found BOOLEAN := FALSE;
347:
348: CURSOR proc_cur IS
349: SELECT 'X'

Line 360: FROM csi_t_transaction_lines

356: BEGIN
357:
358: SELECT processing_status
359: INTO l_processing_status
360: FROM csi_t_transaction_lines
361: WHERE transaction_line_id = p_transaction_line_id;
362:
363: FOR proc_rec in proc_cur
364: LOOP

Line 1357: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;

1353: x_return_status OUT NOCOPY varchar2)
1354: IS
1355:
1356: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;
1357: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;
1358: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
1359:
1360: BEGIN
1361:

Line 1358: l_processing_status csi_t_transaction_lines.processing_status%TYPE;

1354: IS
1355:
1356: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;
1357: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;
1358: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
1359:
1360: BEGIN
1361:
1362: IF p_level in ('PARTY', 'II_RLTNS', 'EXT_ATTRIB', 'ORG_ASSGN') THEN

Line 1382: FROM csi_t_transaction_lines

1378: WHERE txn_line_detail_id = l_txn_line_dtl_id;
1379:
1380: SELECT nvl(processing_status, '#NONE#')
1381: INTO l_processing_status
1382: FROM csi_t_transaction_lines
1383: WHERE transaction_line_id = l_transaction_line_id;
1384:
1385: x_processing_status := l_processing_status;
1386: x_return_status := fnd_api.g_ret_sts_success;

Line 1808: FROM csi_t_transaction_lines

1804: x_return_status := fnd_api.g_ret_sts_error;
1805:
1806: SELECT source_transaction_type_id
1807: INTO l_txn_type_id
1808: FROM csi_t_transaction_lines
1809: WHERE transaction_line_id = p_transaction_line_id;
1810:
1811: FOR sub_type_rec in sub_type_cur(l_txn_type_id)
1812: LOOP

Line 1832: FROM csi_t_transaction_lines

1828: BEGIN
1829:
1830: SELECT 'x'
1831: INTO l_td_found
1832: FROM csi_t_transaction_lines
1833: WHERE source_transaction_table = p_txn_line_rec.source_transaction_table
1834: AND source_transaction_id = p_txn_line_rec.source_transaction_id;
1835:
1836: x_return_status := fnd_api.g_ret_sts_error;

Line 2287: l_txn_line_rec csi_t_transaction_lines%rowtype;

2283: l_txn_type_id1 NUMBER;
2284: l_txn_hdr_id2 NUMBER;
2285: l_txn_type_id2 NUMBER;
2286: l_query varchar2(200);
2287: l_txn_line_rec csi_t_transaction_lines%rowtype;
2288:
2289: BEGIN
2290:
2291: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);

Line 2294: 'from csi_t_transaction_lines where transaction_line_id = :line_id';

2290:
2291: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2292: x_return_status := fnd_api.g_ret_sts_success ;
2293: l_query := 'Select source_txn_header_id, source_transaction_type_id '||
2294: 'from csi_t_transaction_lines where transaction_line_id = :line_id';
2295: EXECUTE IMMEDIATE l_query
2296: INTO l_txn_hdr_id1 , l_txn_type_id1
2297: USING p_txn_line_id1;
2298:

Line 2467: FROM csi_t_transaction_lines a

2463: IS
2464: CURSOR cz_txn_line_cur
2465: IS
2466: SELECT a.transaction_line_id
2467: FROM csi_t_transaction_lines a
2468: WHERE a.config_session_hdr_id = p_config_session_hdr_id
2469: AND a.config_session_rev_num = p_config_session_rev_num
2470: AND a.config_session_item_id = p_config_session_item_id
2471: AND a.source_transaction_table = 'CONFIGURATOR'; --fix for bug 5632296