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 2902: FROM csi_t_txn_line_details ctld,

2898: ctld.quantity,
2899: ctld.transaction_line_id,
2900: ctld.transaction_system_id,
2901: ctld.csi_system_id
2902: FROM csi_t_txn_line_details ctld,
2903: csi_t_transaction_lines ctl
2904: WHERE ctl.source_transaction_id = p_src_txn_id
2905: AND ctl.source_transaction_table = p_src_txn_table
2906: AND ctld.transaction_line_id = ctl.transaction_line_id

Line 2963: UPDATE csi_t_txn_line_details

2959: debug(' ii_rltns_tbl.count :'||o_ii_rltns_tbl.count);
2960:
2961: IF o_line_dtl_tbl.COUNT > 0 THEN
2962:
2963: UPDATE csi_t_txn_line_details
2964: SET quantity = 1
2965: WHERE txn_line_detail_id = o_line_dtl_tbl(1).txn_line_detail_id;
2966:
2967:

Line 3764: update csi_t_txn_line_details

3760: l_line_dtl_rec.processing_status := 'IN_PROCESS';
3761:
3762: debug('Splitting the txn_line_dtls INTO qty of one');
3763:
3764: update csi_t_txn_line_details
3765: set quantity = 1
3766: WHERE txn_line_detail_id = split_txn_dtl_id;
3767:
3768: x_txn_line_dtls_lst(x_txn_line_dtls_lst.count+1).txn_line_detail_id := split_txn_dtl_id;

Line 5432: FROM csi_t_txn_line_details a,

5428: a.quantity,
5429: a.transaction_line_id,
5430: a.transaction_system_id,
5431: a.csi_system_id
5432: FROM csi_t_txn_line_details a,
5433: csi_t_transaction_lines b
5434: WHERE a.transaction_line_id = b.transaction_line_id
5435: AND b.source_transaction_id = p_src_trx_id
5436: AND b.source_transaction_table = p_src_trx_table

Line 5504: update csi_t_txn_line_details

5500:
5501: debug('l_mod_value ='||l_mod_value);
5502: debug('p_ratio ='||p_ratio);
5503:
5504: update csi_t_txn_line_details
5505: set quantity = p_ratio
5506: WHERE txn_line_detail_id = C1.txn_line_detail_id;
5507:
5508: debug('Converting the ids to index ');

Line 6084: FROM csi_t_txn_line_details

6080: IS
6081: CURSOR get_instance_id (c_txn_line_detail_id IN NUMBER)
6082: IS
6083: SELECT instance_id
6084: FROM csi_t_txn_line_details
6085: WHERE txn_line_detail_id = c_txn_line_detail_id ;
6086:
6087: l_subject_instance_id NUMBER ;
6088: l_object_instance_id NUMBER ;

Line 6195: FROM csi_t_txn_line_details a ,

6191:
6192: CURSOR source_txn_table_cur (c_txn_line_detail_id IN NUMBER)
6193: IS
6194: SELECT source_transaction_table, source_transaction_id
6195: FROM csi_t_txn_line_details a ,
6196: csi_t_transaction_lines b
6197: WHERE a.transaction_line_id = b.transaction_line_id
6198: AND a.txn_line_detail_id = c_txn_line_detail_id ;
6199:

Line 6213: FROM csi_t_txn_line_details a ,

6209: CURSOR wsh_partner_tld_cur (c_partner_oe_tld IN NUMBER)
6210: IS
6211: ---For Shippable and Non-shippable Items--
6212: SELECT a.*
6213: FROM csi_t_txn_line_details a ,
6214: csi_t_transaction_lines b ,
6215: mtl_system_items_b c
6216: WHERE a.transaction_line_id = b.transaction_line_id
6217: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')

Line 6261: From csi_t_transaction_lines tl, csi_t_txn_line_details tld

6257:
6258: Begin
6259: Select source_transaction_id
6260: Into l_orig_oe_src_txn_id
6261: From csi_t_transaction_lines tl, csi_t_txn_line_details tld
6262: Where tld.transaction_line_id = tl.transaction_line_id
6263: And tld.txn_line_detail_id = l_orig_oe_tld;
6264: Exception when others Then
6265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 6973: csi_t_txn_line_details ctld

6969:
6970: CURSOR tld_cur (p_ord_line_id IN number, p_instance_id IN number) IS
6971: SELECT 'X'
6972: FROM csi_t_transaction_lines ctl,
6973: csi_t_txn_line_details ctld
6974: WHERE ctl.source_transaction_id = p_ord_line_id
6975: AND ctl.source_transaction_table = 'WSH_DELIVERY_DETAILS'
6976: AND ctld.transaction_line_id = ctl.transaction_line_id
6977: AND nvl(ctld.source_transaction_flag,'N') = 'N'