[Home] [Help]
165:
166: -- insted of modifying cursor, querying the line,
167: -- so that code remains clean.
168:
169: OE_Line_Util.Lock_Row( p_line_id => p_parent_line_id
170: ,p_x_line_rec => l_parent_line_rec
171: ,x_return_status => l_return_status);
172:
173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657:
658: -- insted of modifying cursor, querying the line,
659: -- so that code remains clean.
660:
661: OE_LINE_UTIL.Lock_Row(p_line_id => p_request_rec.param1,
662: p_x_line_rec => l_changed_line_rec,
663: x_return_status => l_return_status);
664:
665: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
841: --
842: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
843: --
844: BEGIN
845: OE_LINE_UTIL.Lock_Row(p_line_id => p_line_id
846: ,p_x_line_rec => l_line_rec
847: ,x_return_status => l_return_status);
848:
849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3293: IF l_debug_level > 0 THEN
3294: oe_debug_pub.add('ENTERING OE_CONFIG_UTIL.CREATE_HDR_XML' , 1);
3295: END IF;
3296:
3297: OE_LINE_UTIL.Query_Row(p_line_id => p_model_line_id
3298: ,x_line_rec => l_model_line_rec);
3299:
3300: -- now set the values from model_rec and org_id
3301: l_context_org_id :=
3815:
3816: -- Loop over fetched records
3817: FOR op in C1 LOOP
3818:
3819: OE_Line_Util.Query_Row( p_line_id => op.line_id
3820: ,x_line_rec => l_line_rec );
3821:
3822: IF (l_line_rec.open_flag = 'Y' OR
3823: p_send_cancel_lines = 'Y') AND
3886:
3887: -- Loop over fetched records
3888: FOR ato_option in C1 LOOP
3889:
3890: OE_Line_Util.Query_Row( p_line_id => ato_option.line_id
3891: ,x_line_rec => l_line_rec );
3892:
3893: IF (l_line_rec.open_flag = 'Y' OR
3894: p_send_cancel_lines = 'Y') AND
4080:
4081: -- Loop over fetched records
4082: FOR inc_item in C1 LOOP
4083:
4084: OE_Line_Util.Query_Row( p_line_id => inc_item.line_id
4085: ,x_line_rec => l_line_rec );
4086:
4087: IF (l_line_rec.open_flag = 'Y' OR
4088: p_send_cancel_lines = 'Y') AND
4119: Procedure Name : Process_Included_Items
4120: Description :
4121: This procedure is used to explode the included items for a
4122: PTO model/class or a kit. This procedure is called from
4123: oe_line_util if,
4124: the included items freeze method profile options is ENTRY or NULL.
4125: a new line is created in a booked order.
4126: a line with included items is schduled.
4127:
4300: oe_debug_pub.add('DO NOT LOCK' , 3 );
4301: END IF;
4302: ELSE
4303: IF p_line_id = FND_API.G_MISS_NUM THEN
4304: OE_LINE_UTIL.Lock_Row
4305: (p_line_id => p_line_rec.line_id
4306: ,p_x_line_rec => l_parent_line_rec
4307: ,x_return_status => l_return_status);
4308: -- Parent Line has been passed
4316: IF l_debug_level > 0 THEN
4317: oe_debug_pub.add('PARENT LINE_ID: '|| P_LINE_ID , 2 );
4318: END IF;
4319:
4320: OE_LINE_UTIL.Lock_Row
4321: (p_line_id => p_line_id
4322: ,p_x_line_rec => l_parent_line_rec
4323: ,x_return_status => l_return_status);
4324: END IF;
4919: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4920:
4921: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4922: IF p_line_id <> FND_API.G_MISS_NUM THEN
4923: OE_Line_Util.Query_Row(p_line_id => p_line_id
4924: ,x_line_rec => l_line_rec);
4925: ELSE
4926: RAISE FND_API.G_EXC_ERROR;
4927: END IF;
4985: -- if p_line_rec is not missing, use it as line_rec insted of querying.
4986:
4987: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
4988: IF p_line_id <> FND_API.G_MISS_NUM THEN
4989: OE_Line_Util.Query_Row(p_line_id => p_line_id
4990: ,x_line_rec => l_line_rec);
4991: ELSE
4992: RAISE FND_API.G_EXC_ERROR;
4993: END IF;
5050: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5051:
5052: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5053: IF p_line_id <> FND_API.G_MISS_NUM THEN
5054: OE_Line_Util.Query_Row(p_line_id => p_line_id
5055: ,x_line_rec => l_line_rec);
5056: ELSE
5057: RAISE FND_API.G_EXC_ERROR;
5058: END IF;
5113: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5114:
5115: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5116: IF p_line_id <> FND_API.G_MISS_NUM THEN
5117: OE_Line_Util.Query_Row(p_line_id => p_line_id
5118: ,x_line_rec => l_line_rec);
5119: ELSE
5120: RAISE FND_API.G_EXC_ERROR;
5121: END IF;
5176: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5177:
5178: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5179: IF p_line_id <> FND_API.G_MISS_NUM THEN
5180: OE_Line_Util.Query_Row(p_line_id => p_line_id
5181: ,x_line_rec => l_line_rec);
5182: ELSE
5183: RAISE FND_API.G_EXC_ERROR;
5184: END IF;
5243: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5244:
5245: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5246: IF p_line_id <> FND_API.G_MISS_NUM THEN
5247: OE_Line_Util.Query_Row(p_line_id => p_line_id
5248: ,x_line_rec => l_line_rec);
5249: ELSE
5250: RAISE FND_API.G_EXC_ERROR;
5251: END IF;
5306: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5307:
5308: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5309: IF p_line_id <> FND_API.G_MISS_NUM THEN
5310: OE_Line_Util.Query_Row(p_line_id => p_line_id
5311: ,x_line_rec => l_line_rec);
5312: ELSE
5313: RAISE FND_API.G_EXC_ERROR;
5314: END IF;
5372: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5373:
5374: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5375: IF p_line_id <> FND_API.G_MISS_NUM THEN
5376: OE_Line_Util.Query_Row(p_line_id => p_line_id
5377: ,x_line_rec => l_line_rec);
5378: ELSE
5379: RAISE FND_API.G_EXC_ERROR;
5380: END IF;
5436: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5437:
5438: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5439: IF p_line_id <> FND_API.G_MISS_NUM THEN
5440: OE_Line_Util.Query_Row(p_line_id => p_line_id
5441: ,x_line_rec => l_line_rec);
5442: ELSE
5443: RAISE FND_API.G_EXC_ERROR;
5444: END IF;
5502: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5503:
5504: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5505: IF p_line_id <> FND_API.G_MISS_NUM THEN
5506: OE_Line_Util.Query_Row(p_line_id => p_line_id
5507: ,x_line_rec => l_line_rec);
5508: ELSE
5509: RAISE FND_API.G_EXC_ERROR;
5510: END IF;
5564: -- if p_line_rec is not missing, use it as line_rec insted of querying.
5565:
5566: IF p_line_rec.line_id = FND_API.G_MISS_NUM THEN
5567: IF p_line_id <> FND_API.G_MISS_NUM THEN
5568: OE_Line_Util.Query_Row(p_line_id => p_line_id
5569: ,x_line_rec => l_line_rec);
5570: ELSE
5571: RAISE FND_API.G_EXC_ERROR;
5572: END IF;
5685: LOOP
5686: FETCH l_line_csr into l_line_id;
5687: EXIT WHEN l_line_csr%NOTFOUND;
5688:
5689: OE_Line_Util.Query_Row( p_line_id => l_line_id
5690: ,x_line_rec => l_line_rec );
5691:
5692: x_line_tbl(x_line_tbl.COUNT + 1) := l_line_rec;
5693:
7987: for included items. To improce performance of
7988: saving included items, we will set the
7989: control_rec.change_attributes parameter to FALSE.
7990: Hence all the delayed requests logged in
7991: oe_line_util.apply_attribute_changes procedure for
7992: included_items will be logged here.
7993: --------------------------------------------------------*/
7994: PROCEDURE Log_Included_Item_Requests
7995: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
9020: x_return_status := l_return_status;
9021:
9022: -- Getting the complete record structure for the top model parent line
9023: -- and Locking it at the same time
9024: OE_LINE_UTIL.Lock_Row
9025: (p_line_id => p_top_model_line_id
9026: ,p_x_line_rec => l_parent_line_rec
9027: ,x_return_status => l_return_status);
9028:
9048: LOOP
9049: FETCH C_PreExploded_Kit INTO l_included_item_line_id;
9050: EXIT WHEN C_PreExploded_Kit%NOTFOUND;
9051: y := y + 1;
9052: OE_LINE_UTIL.Query_Row
9053: ( p_line_id => l_included_item_line_id
9054: , x_line_rec => l_included_item_rec);
9055: l_included_item_tbl(y) := l_included_item_rec;
9056: END LOOP;