APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_TXN_LINE_DETAILS

Line 399: FROM csi_t_txn_line_details

395: AND source_transaction_id = p_order_line_rec.order_line_id;
396:
397: SELECT sum(abs(quantity))
398: INTO l_total_tld_quantity
399: FROM csi_t_txn_line_details
400: WHERE transaction_line_id = l_transaction_line_id
401: AND source_transaction_flag = 'Y';
402:
403: IF l_total_tld_quantity < p_order_line_rec.ordered_quantity THEN

Line 1148: UPDATE csi_t_txn_line_details

1144: --Assign the literals.. bug 4311676
1145: l_literal1 := 'PROCESSED';
1146: l_literal2 := 'WSH_DELIVERY_DETAILS';
1147:
1148: UPDATE csi_t_txn_line_details
1149: SET processing_status = 'IN_PROCESS'
1150: WHERE transaction_line_id IN (
1151: SELECT transaction_line_id
1152: FROM csi_t_transaction_lines

Line 1388: csi_t_txn_line_details sub_tld,

1384: CURSOR other_nsrc_cur(p_tl_id IN number, p_tld_id IN number) IS
1385: SELECT sub_tld.instance_id sub_instance_id,
1386: obj_tld.instance_id obj_instance_id
1387: FROM csi_t_ii_relationships iir,
1388: csi_t_txn_line_details sub_tld,
1389: csi_t_txn_line_details obj_tld
1390: WHERE iir.transaction_line_id = p_tl_id
1391: AND (iir.subject_id = p_tld_id
1392: OR

Line 1389: csi_t_txn_line_details obj_tld

1385: SELECT sub_tld.instance_id sub_instance_id,
1386: obj_tld.instance_id obj_instance_id
1387: FROM csi_t_ii_relationships iir,
1388: csi_t_txn_line_details sub_tld,
1389: csi_t_txn_line_details obj_tld
1390: WHERE iir.transaction_line_id = p_tl_id
1391: AND (iir.subject_id = p_tld_id
1392: OR
1393: iir.object_id = p_tld_id)

Line 3329: UPDATE csi_t_txn_line_details

3325: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3326: raise fnd_api.g_exc_error;
3327: END IF;
3328:
3329: UPDATE csi_t_txn_line_details
3330: SET processing_status = 'SUBMIT'
3331: WHERE txn_line_detail_id = x_txn_line_detail_tbl(j).txn_line_detail_id;
3332:
3333: l_upd := l_upd +1;

Line 4749: UPDATE csi_t_txn_line_details a

4745: IF l_total_qty >= l_order_quantity THEN
4746:
4747: debug(' last transaction for this order line...!');
4748:
4749: UPDATE csi_t_txn_line_details a
4750: SET error_code = NULL,
4751: error_explanation = NULL ,
4752: processing_status = 'PROCESSED'
4753: WHERE a.processing_status <> l_literal1

Line 4766: DELETE FROM csi_t_txn_line_details

4762: UPDATE csi_t_transaction_lines
4763: SET processing_status = 'PROCESSED'
4764: WHERE source_transaction_id = p_order_line_rec.order_line_id;
4765:
4766: DELETE FROM csi_t_txn_line_details
4767: WHERE transaction_line_id = p_transaction_line_id
4768: AND source_transaction_flag = 'Y'
4769: AND processing_status <> l_literal1;
4770:

Line 7212: from CSI_T_TXN_LINE_DETAILS

7208: UPDATE CSI_T_TRANSACTION_LINES
7209: set PROCESSING_STATUS = 'PROCESSED'
7210: where transaction_line_id in
7211: ( select transaction_line_id
7212: from CSI_T_TXN_LINE_DETAILS
7213: where config_inst_hdr_id = p_txn_line_detail_tbl(J).config_inst_hdr_id
7214: and config_inst_rev_num = p_txn_line_detail_tbl(J).config_inst_rev_num
7215: and config_inst_item_id = p_txn_line_detail_tbl(J).config_inst_item_id
7216: )

Line 7219: UPDATE CSI_T_TXN_LINE_DETAILS

7215: and config_inst_item_id = p_txn_line_detail_tbl(J).config_inst_item_id
7216: )
7217: and processing_status = 'SUBMIT';
7218: --
7219: UPDATE CSI_T_TXN_LINE_DETAILS
7220: set PROCESSING_STATUS = 'PROCESSED'
7221: where config_inst_hdr_id = p_txn_line_detail_tbl(J).config_inst_hdr_id
7222: and config_inst_rev_num = p_txn_line_detail_tbl(J).config_inst_rev_num
7223: and config_inst_item_id = p_txn_line_detail_tbl(J).config_inst_item_id