[Home] [Help]
3295: l_progress := 1;
3296: BEGIN
3297: select mmt.organization_id, transaction_date
3298: into l_organization_id, l_transaction_date
3299: From mtl_material_transactions mmt
3300: where mmt.transaction_id= p_reference_id;
3301: EXCEPTION
3302: WHEN NO_DATA_FOUND then
3303: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
3824: IF l_cto_item_flag = 'Y' THEN
3825:
3826: select l.ato_line_id,l.header_id
3827: into l_ato_line_id,l_order_header_id
3828: from mtl_material_transactions mmt
3829: , oe_order_lines_all l
3830: WHERE MMT.transaction_id = p_transaction_id
3831: AND l.line_id = mmt.trx_source_line_id;
3832:
3839: ELSE
3840:
3841: SELECT trx_source_line_id
3842: INTO l_order_line_id
3843: FROM mtl_material_transactions
3844: WHERE transaction_id = p_transaction_id;
3845:
3846: END IF;
3847: EXCEPTION
4111: else
4112: BEGIN
4113: select 1
4114: INTO l_count
4115: From mtl_material_transactions
4116: WHERE transaction_id = p_transaction_id;
4117:
4118: l_transaction_id := p_transaction_id;
4119: l_order_line_id := null;
4575: then
4576: BEGIN
4577: select transaction_date
4578: into l_transaction_date
4579: From mtl_material_transactions mmt
4580: where mmt.transaction_id= p_transaction_id;
4581: EXCEPTION
4582: WHEN NO_DATA_FOUND then
4583: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_TRANSACTIONS');
4812: /* Added following logic for ISO with confgiured items calling of the CTO roll-up price API
4813: only when the price is not associated with the configured item */
4814: BEGIN
4815: SELECT transaction_source_type_id into l_trx_src_type_id
4816: FROM mtl_material_transactions
4817: WHERE transaction_id = p_transaction_id;
4818: if ( l_trx_src_type_id = 8 ) AND ( l_base_item <> 0 ) AND ( nvl(l_inv_transfer_price,0) <> 0 )
4819: AND ( l_inv_currency_code is not null ) then
4820: l_transfer_price := l_inv_transfer_price;