APPS.CSI_UTL_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 2235: UPDATE csi_t_txn_line_details a

2231: IS
2232: l_literal1 VARCHAR2(30) := 'PROCESSED';
2233: BEGIN
2234:
2235: UPDATE csi_t_txn_line_details a
2236: SET error_code = p_api_name,
2237: error_explanation = substr(p_error_message,1,240),
2238: processing_status = 'ERROR'
2239: WHERE a.processing_status <> l_literal1

Line 2860: FROM csi_t_txn_line_details ctld,

2856: ctld.quantity,
2857: ctld.transaction_line_id,
2858: ctld.transaction_system_id,
2859: ctld.csi_system_id
2860: FROM csi_t_txn_line_details ctld,
2861: csi_t_transaction_lines ctl
2862: WHERE ctl.source_transaction_id = p_src_txn_id
2863: AND ctl.source_transaction_table = p_src_txn_table
2864: AND ctld.transaction_line_id = ctl.transaction_line_id

Line 2921: UPDATE csi_t_txn_line_details

2917: debug(' ii_rltns_tbl.count :'||o_ii_rltns_tbl.count);
2918:
2919: IF o_line_dtl_tbl.COUNT > 0 THEN
2920:
2921: UPDATE csi_t_txn_line_details
2922: SET quantity = 1
2923: WHERE txn_line_detail_id = o_line_dtl_tbl(1).txn_line_detail_id;
2924:
2925:

Line 3722: update csi_t_txn_line_details

3718: l_line_dtl_rec.processing_status := 'IN_PROCESS';
3719:
3720: debug('Splitting the txn_line_dtls INTO qty of one');
3721:
3722: update csi_t_txn_line_details
3723: set quantity = 1
3724: WHERE txn_line_detail_id = split_txn_dtl_id;
3725:
3726: x_txn_line_dtls_lst(x_txn_line_dtls_lst.count+1).txn_line_detail_id := split_txn_dtl_id;

Line 5353: FROM csi_t_txn_line_details a,

5349: a.quantity,
5350: a.transaction_line_id,
5351: a.transaction_system_id,
5352: a.csi_system_id
5353: FROM csi_t_txn_line_details a,
5354: csi_t_transaction_lines b
5355: WHERE a.transaction_line_id = b.transaction_line_id
5356: AND b.source_transaction_id = p_src_trx_id
5357: AND b.source_transaction_table = p_src_trx_table

Line 5425: update csi_t_txn_line_details

5421:
5422: debug('l_mod_value ='||l_mod_value);
5423: debug('p_ratio ='||p_ratio);
5424:
5425: update csi_t_txn_line_details
5426: set quantity = p_ratio
5427: WHERE txn_line_detail_id = C1.txn_line_detail_id;
5428:
5429: debug('Converting the ids to index ');

Line 6005: FROM csi_t_txn_line_details

6001: IS
6002: CURSOR get_instance_id (c_txn_line_detail_id IN NUMBER)
6003: IS
6004: SELECT instance_id
6005: FROM csi_t_txn_line_details
6006: WHERE txn_line_detail_id = c_txn_line_detail_id ;
6007:
6008: l_subject_instance_id NUMBER ;
6009: l_object_instance_id NUMBER ;

Line 6116: FROM csi_t_txn_line_details a ,

6112:
6113: CURSOR source_txn_table_cur (c_txn_line_detail_id IN NUMBER)
6114: IS
6115: SELECT source_transaction_table, source_transaction_id
6116: FROM csi_t_txn_line_details a ,
6117: csi_t_transaction_lines b
6118: WHERE a.transaction_line_id = b.transaction_line_id
6119: AND a.txn_line_detail_id = c_txn_line_detail_id ;
6120:

Line 6134: FROM csi_t_txn_line_details a ,

6130: CURSOR wsh_partner_tld_cur (c_partner_oe_tld IN NUMBER)
6131: IS
6132: ---For Shippable and Non-shippable Items--
6133: SELECT a.*
6134: FROM csi_t_txn_line_details a ,
6135: csi_t_transaction_lines b ,
6136: mtl_system_items_b c
6137: WHERE a.transaction_line_id = b.transaction_line_id
6138: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')

Line 6182: From csi_t_transaction_lines tl, csi_t_txn_line_details tld

6178:
6179: Begin
6180: Select source_transaction_id
6181: Into l_orig_oe_src_txn_id
6182: From csi_t_transaction_lines tl, csi_t_txn_line_details tld
6183: Where tld.transaction_line_id = tl.transaction_line_id
6184: And tld.txn_line_detail_id = l_orig_oe_tld;
6185: Exception when others Then
6186: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 6885: csi_t_txn_line_details ctld

6881:
6882: CURSOR tld_cur (p_ord_line_id IN number, p_instance_id IN number) IS
6883: SELECT 'X'
6884: FROM csi_t_transaction_lines ctl,
6885: csi_t_txn_line_details ctld
6886: WHERE ctl.source_transaction_id = p_ord_line_id
6887: AND ctl.source_transaction_table = 'WSH_DELIVERY_DETAILS'
6888: AND ctld.transaction_line_id = ctl.transaction_line_id
6889: AND nvl(ctld.source_transaction_flag,'N') = 'N'