APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 1628: update csi_t_txn_line_details

1624: IF p_line_dtl_tbl(l_td_ind).quantity > 1 THEN
1625:
1626: l_split_count := l_split_count + 1;
1627:
1628: update csi_t_txn_line_details
1629: set quantity = 1,
1630: processing_status = 'IN_PROCESS' ,
1631: source_txn_line_detail_id = p_line_dtl_tbl(l_td_ind).txn_line_detail_id
1632: where txn_line_detail_id = p_line_dtl_tbl(l_td_ind).txn_line_detail_id;

Line 1721: update csi_t_txn_line_details

1717: END LOOP; -- (qauantity -1) loop
1718:
1719: ELSE
1720:
1721: update csi_t_txn_line_details
1722: set processing_status = 'IN_PROCESS'
1723: where txn_line_detail_id = p_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1724:
1725: END IF; -- qty > 1

Line 1776: update csi_t_txn_line_details

1772: FOR l_td_ind in px_line_dtl_tbl.FIRST .. px_line_dtl_tbl.LAST
1773: LOOP
1774: IF px_line_dtl_tbl(l_td_ind).quantity > p_quantity_ratio THEN
1775:
1776: update csi_t_txn_line_details
1777: set quantity = p_quantity_ratio,
1778: processing_status = 'IN_PROCESS'
1779: where txn_line_detail_id = px_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1780:

Line 1874: UPDATE csi_t_txn_line_details

1870:
1871: END LOOP;
1872: END IF;
1873: ELSE
1874: UPDATE csi_t_txn_line_details
1875: SET processing_status = 'IN_PROCESS'
1876: WHERE txn_line_detail_id = px_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1877:
1878: l_o_ind := l_o_ind + 1;

Line 4953: SELECT 'x' FROM csi_t_txn_line_details ctld

4949: AND cii.last_oe_order_line_id = p_option_line_rec.line_id
4950: AND cii.location_type_code = 'HZ_PARTY_SITES'
4951: AND cii.instance_usage_code IN ( 'OUT_OF_ENTERPRISE','IN_RELATIONSHIP') -- Changed for bug#14267193
4952: AND not exists (
4953: SELECT 'x' FROM csi_t_txn_line_details ctld
4954: WHERE ctld.transaction_line_id = p_transaction_line_id
4955: AND ctld.source_transaction_flag = 'N'
4956: AND ctld.instance_id = cii.instance_id);
4957: BEGIN

Line 9546: CSI_T_TXN_LINE_DETAILS ctld

9542: Begin
9543: SELECT changed_instance_id,ctl.transaction_line_id
9544: INTO l_ul_instance_rec.instance_id,l_ul_txn_line_id
9545: FROM CSI_T_TRANSACTION_LINES ctl,
9546: CSI_T_TXN_LINE_DETAILS ctld
9547: WHERE ctl.source_transaction_table = 'CONFIGURATOR'
9548: AND ctl.config_session_hdr_id = l_om_session_key.session_hdr_id
9549: AND ctl.config_session_rev_num = l_om_session_key.session_rev_num
9550: AND ctl.config_session_item_id = l_om_session_key.session_item_id

Line 9603: UPDATE csi_t_txn_line_details

9599: --
9600: IF l_return_status <> fnd_api.g_ret_sts_success THEN
9601: RAISE fnd_api.g_exc_error;
9602: ELSE
9603: UPDATE csi_t_txn_line_details
9604: SET processing_status = 'PROCESSED'
9605: WHERE transaction_line_id = l_ul_txn_line_id;
9606: --
9607: RAISE skip_regular_process;

Line 10295: UPDATE csi_t_txn_line_details

10291:
10292: IF l_line_dtl_tbl.COUNT > 0 THEN
10293: FOR l_td_ind IN l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST
10294: LOOP
10295: UPDATE csi_t_txn_line_details
10296: SET processing_status = 'IN_PROCESS'
10297: WHERE txn_line_detail_id = l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
10298: END LOOP;
10299: END IF;

Line 10381: UPDATE csi_t_txn_line_details

10377:
10378: -- get the transaction details for final processing
10379: /* mark all the non source transaction details as 'IN_PROCESS' */
10380:
10381: UPDATE csi_t_txn_line_details
10382: SET processing_status = 'IN_PROCESS'
10383: WHERE transaction_line_id = l_txn_line_rec.transaction_line_id
10384: AND source_transaction_flag = 'N';
10385: