APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 1588: update csi_t_txn_line_details

1584: IF p_line_dtl_tbl(l_td_ind).quantity > 1 THEN
1585:
1586: l_split_count := l_split_count + 1;
1587:
1588: update csi_t_txn_line_details
1589: set quantity = 1,
1590: processing_status = 'IN_PROCESS' ,
1591: source_txn_line_detail_id = p_line_dtl_tbl(l_td_ind).txn_line_detail_id
1592: where txn_line_detail_id = p_line_dtl_tbl(l_td_ind).txn_line_detail_id;

Line 1681: update csi_t_txn_line_details

1677: END LOOP; -- (qauantity -1) loop
1678:
1679: ELSE
1680:
1681: update csi_t_txn_line_details
1682: set processing_status = 'IN_PROCESS'
1683: where txn_line_detail_id = p_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1684:
1685: END IF; -- qty > 1

Line 1736: update csi_t_txn_line_details

1732: FOR l_td_ind in px_line_dtl_tbl.FIRST .. px_line_dtl_tbl.LAST
1733: LOOP
1734: IF px_line_dtl_tbl(l_td_ind).quantity > p_quantity_ratio THEN
1735:
1736: update csi_t_txn_line_details
1737: set quantity = p_quantity_ratio,
1738: processing_status = 'IN_PROCESS'
1739: where txn_line_detail_id = px_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1740:

Line 1834: UPDATE csi_t_txn_line_details

1830:
1831: END LOOP;
1832: END IF;
1833: ELSE
1834: UPDATE csi_t_txn_line_details
1835: SET processing_status = 'IN_PROCESS'
1836: WHERE txn_line_detail_id = px_line_dtl_tbl(l_td_ind).txn_line_detail_id;
1837:
1838: l_o_ind := l_o_ind + 1;

Line 4905: SELECT 'x' FROM csi_t_txn_line_details ctld

4901: AND cii.last_oe_order_line_id = p_option_line_rec.line_id
4902: AND cii.location_type_code = 'HZ_PARTY_SITES'
4903: AND cii.instance_usage_code = 'OUT_OF_ENTERPRISE'
4904: AND not exists (
4905: SELECT 'x' FROM csi_t_txn_line_details ctld
4906: WHERE ctld.transaction_line_id = p_transaction_line_id
4907: AND ctld.source_transaction_flag = 'N'
4908: AND ctld.instance_id = cii.instance_id);
4909: BEGIN

Line 8591: CSI_T_TXN_LINE_DETAILS ctld

8587: Begin
8588: SELECT changed_instance_id,ctl.transaction_line_id
8589: INTO l_ul_instance_rec.instance_id,l_ul_txn_line_id
8590: FROM CSI_T_TRANSACTION_LINES ctl,
8591: CSI_T_TXN_LINE_DETAILS ctld
8592: WHERE ctl.source_transaction_table = 'CONFIGURATOR'
8593: AND ctl.config_session_hdr_id = l_om_session_key.session_hdr_id
8594: AND ctl.config_session_rev_num = l_om_session_key.session_rev_num
8595: AND ctl.config_session_item_id = l_om_session_key.session_item_id

Line 8648: UPDATE csi_t_txn_line_details

8644: --
8645: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8646: RAISE fnd_api.g_exc_error;
8647: ELSE
8648: UPDATE csi_t_txn_line_details
8649: SET processing_status = 'PROCESSED'
8650: WHERE transaction_line_id = l_ul_txn_line_id;
8651: --
8652: RAISE skip_regular_process;

Line 9285: UPDATE csi_t_txn_line_details

9281:
9282: IF l_line_dtl_tbl.COUNT > 0 THEN
9283: FOR l_td_ind IN l_line_dtl_tbl.FIRST .. l_line_dtl_tbl.LAST
9284: LOOP
9285: UPDATE csi_t_txn_line_details
9286: SET processing_status = 'IN_PROCESS'
9287: WHERE txn_line_detail_id = l_line_dtl_tbl(l_td_ind).txn_line_detail_id;
9288: END LOOP;
9289: END IF;

Line 9370: UPDATE csi_t_txn_line_details

9366:
9367: -- get the transaction details for final processing
9368: /* mark all the non source transaction details as 'IN_PROCESS' */
9369:
9370: UPDATE csi_t_txn_line_details
9371: SET processing_status = 'IN_PROCESS'
9372: WHERE transaction_line_id = l_txn_line_rec.transaction_line_id
9373: AND source_transaction_flag = 'N';
9374: