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 1205: UPDATE csi_t_txn_line_details

1201: --Assign the literals.. bug 4311676
1202: l_literal1 := 'PROCESSED';
1203: l_literal2 := 'WSH_DELIVERY_DETAILS';
1204:
1205: UPDATE csi_t_txn_line_details
1206: SET processing_status = 'IN_PROCESS'
1207: WHERE transaction_line_id IN (
1208: SELECT transaction_line_id
1209: FROM csi_t_transaction_lines

Line 1445: csi_t_txn_line_details sub_tld,

1441: CURSOR other_nsrc_cur(p_tl_id IN number, p_tld_id IN number) IS
1442: SELECT sub_tld.instance_id sub_instance_id,
1443: obj_tld.instance_id obj_instance_id
1444: FROM csi_t_ii_relationships iir,
1445: csi_t_txn_line_details sub_tld,
1446: csi_t_txn_line_details obj_tld
1447: WHERE iir.transaction_line_id = p_tl_id
1448: AND (iir.subject_id = p_tld_id
1449: OR

Line 1446: csi_t_txn_line_details obj_tld

1442: SELECT sub_tld.instance_id sub_instance_id,
1443: obj_tld.instance_id obj_instance_id
1444: FROM csi_t_ii_relationships iir,
1445: csi_t_txn_line_details sub_tld,
1446: csi_t_txn_line_details obj_tld
1447: WHERE iir.transaction_line_id = p_tl_id
1448: AND (iir.subject_id = p_tld_id
1449: OR
1450: iir.object_id = p_tld_id)

Line 3388: UPDATE csi_t_txn_line_details

3384: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
3385: raise fnd_api.g_exc_error;
3386: END IF;
3387:
3388: UPDATE csi_t_txn_line_details
3389: SET processing_status = 'SUBMIT'
3390: WHERE txn_line_detail_id = x_txn_line_detail_tbl(j).txn_line_detail_id;
3391:
3392: l_upd := l_upd +1;

Line 4828: UPDATE csi_t_txn_line_details a

4824: IF l_total_qty >= l_order_quantity THEN
4825:
4826: debug(' last transaction for this order line...!');
4827:
4828: UPDATE csi_t_txn_line_details a
4829: SET error_code = NULL,
4830: error_explanation = NULL ,
4831: processing_status = 'PROCESSED'
4832: WHERE a.processing_status <> l_literal1

Line 4845: DELETE FROM csi_t_txn_line_details

4841: UPDATE csi_t_transaction_lines
4842: SET processing_status = 'PROCESSED'
4843: WHERE source_transaction_id = p_order_line_rec.order_line_id;
4844:
4845: DELETE FROM csi_t_txn_line_details
4846: WHERE transaction_line_id = p_transaction_line_id
4847: AND source_transaction_flag = 'Y'
4848: AND processing_status <> l_literal1;
4849:

Line 7531: from CSI_T_TXN_LINE_DETAILS

7527: UPDATE CSI_T_TRANSACTION_LINES
7528: set PROCESSING_STATUS = 'PROCESSED'
7529: where transaction_line_id in
7530: ( select transaction_line_id
7531: from CSI_T_TXN_LINE_DETAILS
7532: where config_inst_hdr_id = p_txn_line_detail_tbl(J).config_inst_hdr_id
7533: and config_inst_rev_num = p_txn_line_detail_tbl(J).config_inst_rev_num
7534: and config_inst_item_id = p_txn_line_detail_tbl(J).config_inst_item_id
7535: )

Line 7538: UPDATE CSI_T_TXN_LINE_DETAILS

7534: and config_inst_item_id = p_txn_line_detail_tbl(J).config_inst_item_id
7535: )
7536: and processing_status = 'SUBMIT';
7537: --
7538: UPDATE CSI_T_TXN_LINE_DETAILS
7539: set PROCESSING_STATUS = 'PROCESSED'
7540: where config_inst_hdr_id = p_txn_line_detail_tbl(J).config_inst_hdr_id
7541: and config_inst_rev_num = p_txn_line_detail_tbl(J).config_inst_rev_num
7542: and config_inst_item_id = p_txn_line_detail_tbl(J).config_inst_item_id