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 1330: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;

1326: x_return_status OUT NOCOPY varchar2)
1327: IS
1328:
1329: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;
1330: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;
1331: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
1332:
1333: BEGIN
1334:

Line 1331: l_processing_status csi_t_transaction_lines.processing_status%TYPE;

1327: IS
1328:
1329: l_txn_line_dtl_id csi_t_txn_line_details.txn_line_detail_id%TYPE;
1330: l_transaction_line_id csi_t_transaction_lines.transaction_line_id%TYPE;
1331: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
1332:
1333: BEGIN
1334:
1335: IF p_level in ('PARTY', 'II_RLTNS', 'EXT_ATTRIB', 'ORG_ASSGN') THEN

Line 1355: FROM csi_t_transaction_lines

1351: WHERE txn_line_detail_id = l_txn_line_dtl_id;
1352:
1353: SELECT nvl(processing_status, '#NONE#')
1354: INTO l_processing_status
1355: FROM csi_t_transaction_lines
1356: WHERE transaction_line_id = l_transaction_line_id;
1357:
1358: x_processing_status := l_processing_status;
1359: x_return_status := fnd_api.g_ret_sts_success;

Line 1781: FROM csi_t_transaction_lines

1777: x_return_status := fnd_api.g_ret_sts_error;
1778:
1779: SELECT source_transaction_type_id
1780: INTO l_txn_type_id
1781: FROM csi_t_transaction_lines
1782: WHERE transaction_line_id = p_transaction_line_id;
1783:
1784: FOR sub_type_rec in sub_type_cur(l_txn_type_id)
1785: LOOP

Line 1805: FROM csi_t_transaction_lines

1801: BEGIN
1802:
1803: SELECT 'x'
1804: INTO l_td_found
1805: FROM csi_t_transaction_lines
1806: WHERE source_transaction_table = p_txn_line_rec.source_transaction_table
1807: AND source_transaction_id = p_txn_line_rec.source_transaction_id;
1808:
1809: x_return_status := fnd_api.g_ret_sts_error;

Line 2260: l_txn_line_rec csi_t_transaction_lines%rowtype;

2256: l_txn_type_id1 NUMBER;
2257: l_txn_hdr_id2 NUMBER;
2258: l_txn_type_id2 NUMBER;
2259: l_query varchar2(200);
2260: l_txn_line_rec csi_t_transaction_lines%rowtype;
2261:
2262: BEGIN
2263:
2264: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);

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

2263:
2264: csi_t_gen_utility_pvt.add('Begin : '||l_routine_name);
2265: x_return_status := fnd_api.g_ret_sts_success ;
2266: l_query := 'Select source_txn_header_id, source_transaction_type_id '||
2267: 'from csi_t_transaction_lines where transaction_line_id = :line_id';
2268: EXECUTE IMMEDIATE l_query
2269: INTO l_txn_hdr_id1 , l_txn_type_id1
2270: USING p_txn_line_id1;
2271:

Line 2440: FROM csi_t_transaction_lines a

2436: IS
2437: CURSOR cz_txn_line_cur
2438: IS
2439: SELECT a.transaction_line_id
2440: FROM csi_t_transaction_lines a
2441: WHERE a.config_session_hdr_id = p_config_session_hdr_id
2442: AND a.config_session_rev_num = p_config_session_rev_num
2443: AND a.config_session_item_id = p_config_session_item_id
2444: AND a.source_transaction_table = 'CONFIGURATOR'; --fix for bug 5632296