[Home] [Help]
89:
90: --As per discussion with AMY and RAVI
91: --If error occurs from pricing engine we need to look at pricing temp table
92: --copy the temp table unit selling price to the line
93: Procedure Reset_Fields(p_line_rec in Oe_Order_Pub.Line_Rec_Type)As
94:
95: Cursor get_price(p_line_id in Number) is
96: Select Unit_Price,
97: Adjusted_Unit_Price,
318: PROCEDURE Header_Adjs
319: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
320: , p_validation_level IN NUMBER
321: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
322: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
323: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
324: )
325: IS
326: l_return_status VARCHAR2(1);
319: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
320: , p_validation_level IN NUMBER
321: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
322: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
323: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
324: )
325: IS
326: l_return_status VARCHAR2(1);
327: l_control_rec OE_GLOBALS.Control_Rec_Type;
324: )
325: IS
326: l_return_status VARCHAR2(1);
327: l_control_rec OE_GLOBALS.Control_Rec_Type;
328: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
329: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
330: -- local variables to store OUT parameters from security check procedures
331: l_sec_result NUMBER;
332: l_on_operation_action NUMBER;
325: IS
326: l_return_status VARCHAR2(1);
327: l_control_rec OE_GLOBALS.Control_Rec_Type;
328: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
329: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
330: -- local variables to store OUT parameters from security check procedures
331: l_sec_result NUMBER;
332: l_on_operation_action NUMBER;
333: I pls_integer; -- Used as index for while loop
375:
376: IF p_x_old_Header_Adj_tbl.EXISTS(I) THEN
377: l_old_Header_Adj_rec := p_x_old_Header_Adj_tbl(I);
378: ELSE
379: l_old_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
380: END IF;
381:
382: if l_old_header_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM then
383:
949: PROCEDURE Line_Adjs
950: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
951: , p_validation_level IN NUMBER
952: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
953: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
954: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
955: )
956: IS
957: l_return_status VARCHAR2(1);
950: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
951: , p_validation_level IN NUMBER
952: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
953: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
954: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
955: )
956: IS
957: l_return_status VARCHAR2(1);
958: l_control_rec OE_GLOBALS.Control_Rec_Type;
955: )
956: IS
957: l_return_status VARCHAR2(1);
958: l_control_rec OE_GLOBALS.Control_Rec_Type;
959: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
960: l_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
961: -- local variables to store OUT parameters from security check procedures
962: l_sec_result NUMBER;
963: l_on_operation_action NUMBER;
956: IS
957: l_return_status VARCHAR2(1);
958: l_control_rec OE_GLOBALS.Control_Rec_Type;
959: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
960: l_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
961: -- local variables to store OUT parameters from security check procedures
962: l_sec_result NUMBER;
963: l_on_operation_action NUMBER;
964: I pls_integer; -- Used as table index for the loop.
975: l_change_sequence VARCHAR2(50);
976: l_source_document_type_id NUMBER;
977: l_source_document_id NUMBER;
978: l_source_document_line_id NUMBER;
979: l_line_temp_rec OE_Order_PUB.Line_Rec_Type;
980:
981: BEGIN
982:
983: IF l_debug_level > 0 THEN
1013:
1014: IF p_x_old_Line_Adj_tbl.EXISTS(I) THEN
1015: l_old_Line_Adj_rec := p_x_old_Line_Adj_tbl(I);
1016: ELSE
1017: l_old_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
1018: END IF;
1019:
1020: if l_old_line_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM then
1021:
1724: PROCEDURE HEader_Price_Atts
1725: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
1726: , p_validation_level IN NUMBER
1727: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1728: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1729: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1730: )
1731: is
1732: l_return_status VARCHAR2(1);
1725: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
1726: , p_validation_level IN NUMBER
1727: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1728: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1729: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1730: )
1731: is
1732: l_return_status VARCHAR2(1);
1733: l_control_rec OE_GLOBALS.Control_Rec_Type;
1730: )
1731: is
1732: l_return_status VARCHAR2(1);
1733: l_control_rec OE_GLOBALS.Control_Rec_Type;
1734: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1735: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1736: -- local variables to store OUT parameters from security check procedures
1737: l_sec_result NUMBER;
1738: l_on_operation_action NUMBER;
1731: is
1732: l_return_status VARCHAR2(1);
1733: l_control_rec OE_GLOBALS.Control_Rec_Type;
1734: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1735: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1736: -- local variables to store OUT parameters from security check procedures
1737: l_sec_result NUMBER;
1738: l_on_operation_action NUMBER;
1739: I pls_integer; -- Used as index for while loop
1779:
1780: IF p_x_old_Header_Price_Att_tbl.EXISTS(I) THEN
1781: l_old_Header_Price_Att_rec := p_x_old_Header_Price_Att_tbl(I);
1782: ELSE
1783: l_old_Header_Price_Att_rec := OE_Order_PUB.G_MISS_HEADER_Price_Att_REC;
1784: END IF;
1785:
1786: if l_old_header_Price_Att_rec.Order_price_attrib_id = FND_API.G_MISS_NUM then
1787: IF l_header_Price_Att_rec.header_Id IS NOT NULL AND
2270: PROCEDURE Header_Adj_Atts
2271: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2272: , p_validation_level IN NUMBER
2273: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2274: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2275: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2276: )
2277: is
2278: l_return_status VARCHAR2(1);
2271: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2272: , p_validation_level IN NUMBER
2273: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2274: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2275: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2276: )
2277: is
2278: l_return_status VARCHAR2(1);
2279: l_control_rec OE_GLOBALS.Control_Rec_Type;
2276: )
2277: is
2278: l_return_status VARCHAR2(1);
2279: l_control_rec OE_GLOBALS.Control_Rec_Type;
2280: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2281: l_old_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2282: -- local variables to store OUT parameters from security check procedures
2283: I pls_integer; -- Used as index for while loop
2284: BEGIN
2277: is
2278: l_return_status VARCHAR2(1);
2279: l_control_rec OE_GLOBALS.Control_Rec_Type;
2280: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2281: l_old_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2282: -- local variables to store OUT parameters from security check procedures
2283: I pls_integer; -- Used as index for while loop
2284: BEGIN
2285:
2308:
2309: IF p_x_old_Header_Adj_Att_tbl.EXISTS(I) THEN
2310: l_old_Header_Adj_Att_rec := p_x_old_Header_Adj_Att_tbl(I);
2311: ELSE
2312: l_old_Header_Adj_Att_rec := OE_Order_PUB.G_MISS_Header_Adj_Att_REC;
2313: END IF;
2314:
2315: if l_old_Header_Adj_Att_rec.Price_Adj_attrib_id = FND_API.G_MISS_NUM then
2316:
2549: PROCEDURE Header_Adj_Assocs
2550: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2551: , p_validation_level IN NUMBER
2552: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2553: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2554: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2555: )
2556: is
2557: l_return_status VARCHAR2(1);
2550: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2551: , p_validation_level IN NUMBER
2552: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2553: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2554: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2555: )
2556: is
2557: l_return_status VARCHAR2(1);
2558: l_control_rec OE_GLOBALS.Control_Rec_Type;
2555: )
2556: is
2557: l_return_status VARCHAR2(1);
2558: l_control_rec OE_GLOBALS.Control_Rec_Type;
2559: l_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2560: l_old_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2561: -- local variables to store OUT parameters from security check procedures
2562: I pls_integer; -- Used as index for while loop
2563: BEGIN
2556: is
2557: l_return_status VARCHAR2(1);
2558: l_control_rec OE_GLOBALS.Control_Rec_Type;
2559: l_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2560: l_old_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2561: -- local variables to store OUT parameters from security check procedures
2562: I pls_integer; -- Used as index for while loop
2563: BEGIN
2564:
2587:
2588: IF p_x_old_Header_Adj_Assoc_tbl.EXISTS(I) THEN
2589: l_old_Header_Adj_Assoc_rec := p_x_old_Header_Adj_Assoc_tbl(I);
2590: ELSE
2591: l_old_Header_Adj_Assoc_rec := OE_Order_PUB.G_MISS_Header_Adj_Assoc_REC;
2592: END IF;
2593:
2594: if l_old_Header_Adj_Assoc_rec.Price_Adj_assoc_id = FND_API.G_MISS_NUM then
2595:
2827: PROCEDURE Line_Price_Atts
2828: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2829: , p_validation_level IN NUMBER
2830: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2831: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2832: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2833: )
2834: is
2835: l_return_status VARCHAR2(1);
2828: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2829: , p_validation_level IN NUMBER
2830: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2831: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2832: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2833: )
2834: is
2835: l_return_status VARCHAR2(1);
2836: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: )
2834: is
2835: l_return_status VARCHAR2(1);
2836: l_control_rec OE_GLOBALS.Control_Rec_Type;
2837: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2838: l_old_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2839: -- local variables to store OUT parameters from security check procedures
2840: l_sec_result NUMBER;
2841: l_on_operation_action NUMBER;
2834: is
2835: l_return_status VARCHAR2(1);
2836: l_control_rec OE_GLOBALS.Control_Rec_Type;
2837: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2838: l_old_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2839: -- local variables to store OUT parameters from security check procedures
2840: l_sec_result NUMBER;
2841: l_on_operation_action NUMBER;
2842: I pls_integer; -- Used as index for while loop
2882:
2883: IF p_x_old_Line_price_att_tbl.EXISTS(I) THEN
2884: l_old_Line_price_att_rec := p_x_old_Line_price_att_tbl(I);
2885: ELSE
2886: l_old_Line_price_att_rec := OE_Order_PUB.G_MISS_Line_Price_Att_REC;
2887: END IF;
2888:
2889: if l_old_Line_price_att_rec.Order_price_attrib_id = FND_API.G_MISS_NUM then
2890:
3383: end Line_Price_Atts;
3384:
3385:
3386: PROCEDURE Insert_Adj_Atts
3387: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
3388: )
3389: is
3390: I PLS_INTEGER;
3391: l_line_dummy_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3387: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
3388: )
3389: is
3390: I PLS_INTEGER;
3391: l_line_dummy_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3392: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3393: l_control_rec OE_GLOBALS.Control_Rec_Type;
3394: Begin
3395: l_line_adj_att_tbl := p_Line_Adj_attribs_tbl;
3388: )
3389: is
3390: I PLS_INTEGER;
3391: l_line_dummy_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3392: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3393: l_control_rec OE_GLOBALS.Control_Rec_Type;
3394: Begin
3395: l_line_adj_att_tbl := p_Line_Adj_attribs_tbl;
3396:
3403:
3404: I := p_Line_Adj_attribs_tbl.first;
3405:
3406: While I Is Not Null Loop
3407: --l_line_adj_assoc_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
3408: l_line_adj_att_tbl(i).Operation := OE_Globals.G_OPR_CREATE;
3409:
3410: Select OE_PRICE_ADJ_ATTRIBS_S.nextval
3411: Into l_line_adj_att_tbl(i).price_adj_attrib_id
3426: PROCEDURE Line_Adj_Atts
3427: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3428: , p_validation_level IN NUMBER
3429: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3430: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3431: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3432: )
3433: is
3434: l_return_status VARCHAR2(1);
3427: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3428: , p_validation_level IN NUMBER
3429: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3430: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3431: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3432: )
3433: is
3434: l_return_status VARCHAR2(1);
3435: l_control_rec OE_GLOBALS.Control_Rec_Type;
3432: )
3433: is
3434: l_return_status VARCHAR2(1);
3435: l_control_rec OE_GLOBALS.Control_Rec_Type;
3436: l_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3437: l_old_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3438: -- local variables to store OUT parameters from security check procedures
3439: I pls_integer; -- Used as index for while loop
3440: BEGIN
3433: is
3434: l_return_status VARCHAR2(1);
3435: l_control_rec OE_GLOBALS.Control_Rec_Type;
3436: l_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3437: l_old_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3438: -- local variables to store OUT parameters from security check procedures
3439: I pls_integer; -- Used as index for while loop
3440: BEGIN
3441:
3463:
3464: IF p_x_old_Line_Adj_Att_tbl.EXISTS(I) THEN
3465: l_old_Line_Adj_Att_rec := p_x_old_Line_Adj_Att_tbl(I);
3466: ELSE
3467: l_old_Line_Adj_Att_rec := OE_Order_PUB.G_MISS_Line_Adj_Att_REC;
3468: END IF;
3469:
3470: if l_old_Line_Adj_Att_rec.Price_Adj_attrib_id = FND_API.G_MISS_NUM then
3471:
3722: adj_debug('Exiting oe_order_Adj_pvt.Line_Adj_Atts', 1);
3723: end Line_Adj_Atts;
3724:
3725: PROCEDURE Insert_Adj_Assocs
3726: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3727: )
3728: is
3729: I PLS_INTEGER;
3730: l_line_dummy_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3726: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3727: )
3728: is
3729: I PLS_INTEGER;
3730: l_line_dummy_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3731: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3732: l_control_rec OE_GLOBALS.Control_Rec_Type;
3733: Begin
3734: l_line_adj_assoc_tbl := p_Line_Adj_Assoc_tbl;
3727: )
3728: is
3729: I PLS_INTEGER;
3730: l_line_dummy_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3731: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3732: l_control_rec OE_GLOBALS.Control_Rec_Type;
3733: Begin
3734: l_line_adj_assoc_tbl := p_Line_Adj_Assoc_tbl;
3735: l_control_rec.private_call := TRUE;
3741:
3742: I := p_line_adj_assoc_tbl.first;
3743:
3744: While I Is Not Null Loop
3745: --l_line_adj_assoc_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
3746: l_Line_Adj_Assoc_tbl(i).Operation := OE_Globals.G_OPR_CREATE;
3747:
3748: Select oe_price_adj_assocs_s.nextval
3749: Into l_line_adj_assoc_tbl(i).price_adj_assoc_id
3763: PROCEDURE Line_Adj_Assocs
3764: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3765: , p_validation_level IN NUMBER
3766: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3767: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3768: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3769: )
3770: is
3771: l_return_status VARCHAR2(1);
3764: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3765: , p_validation_level IN NUMBER
3766: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3767: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3768: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3769: )
3770: is
3771: l_return_status VARCHAR2(1);
3772: l_control_rec OE_GLOBALS.Control_Rec_Type;
3769: )
3770: is
3771: l_return_status VARCHAR2(1);
3772: l_control_rec OE_GLOBALS.Control_Rec_Type;
3773: l_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3774: l_old_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3775: -- local variables to store OUT parameters from security check procedures
3776: I pls_integer; -- Used as index for while loop
3777: BEGIN
3770: is
3771: l_return_status VARCHAR2(1);
3772: l_control_rec OE_GLOBALS.Control_Rec_Type;
3773: l_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3774: l_old_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3775: -- local variables to store OUT parameters from security check procedures
3776: I pls_integer; -- Used as index for while loop
3777: BEGIN
3778:
3803: adj_debug('price adj '||l_Line_Adj_Assoc_rec.PRICE_ADJUSTMENT_ID,2);
3804: IF p_x_old_Line_Adj_Assoc_tbl.EXISTS(I) THEN
3805: l_old_Line_Adj_Assoc_rec := p_x_old_Line_Adj_Assoc_tbl(I);
3806: ELSE
3807: l_old_Line_Adj_Assoc_rec := OE_Order_PUB.G_MISS_Line_Adj_Assoc_REC;
3808: END IF;
3809:
3810: if l_old_Line_Adj_Assoc_rec.Price_Adj_assoc_id = FND_API.G_MISS_NUM then
3811:
4053: begin
4054:
4055: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
4056: select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
4057: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id;
4058: exception when no_data_found then
4059: l_enforce_price_flag := 'N';
4060: end ;
4061:
4062: If l_enforce_price_flag='N' then
4063: begin
4064: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
4065: select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
4066: from oe_Order_types_v where Order_type_id=OE_Order_PUB.g_hdr.Order_Type_Id;
4067: exception when no_data_found then
4068: l_enforce_price_flag := 'N';
4069: end ;
4070: end if;
4137: Return Null;
4138: end Get_Rounding_factor;
4139:
4140: procedure copy_Header_to_request(
4141: p_header_rec OE_Order_PUB.Header_Rec_Type
4142: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
4143: --,p_pricing_event varchar2
4144: ,p_Request_Type_Code varchar2
4145: ,p_calculate_price_flag varchar2
4171:
4172: If p_Header_rec.transactional_curr_code is Not Null Then
4173: G_ORDER_CURRENCY := p_Header_rec.transactional_curr_code;
4174: Else
4175: G_ORDER_CURRENCY := OE_Order_PUB.g_hdr.transactional_curr_code;
4176: End If;
4177:
4178: --Rounding factor now will be handled by pricing engine.
4179:
4182:
4183: end copy_Header_to_request;
4184:
4185: procedure copy_Line_to_request(
4186: p_Line_rec OE_Order_PUB.Line_Rec_Type
4187: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
4188: ,p_pricing_event varchar2
4189: ,p_Request_Type_Code varchar2
4190: ,p_honor_price_flag VARCHAR2 Default 'Y'
4272:
4273: px_req_line_tbl(l_line_index).PRICED_UOM_CODE := p_Line_rec.pricing_quantity_uom;
4274:
4275: px_req_line_tbl(l_line_index).CURRENCY_CODE :=
4276: OE_Order_PUB.g_hdr.transactional_curr_code;
4277: -- uom begin
4278: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
4279: px_req_line_tbl(l_line_index).UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
4280:
4387:
4388: End If;
4389:
4390: px_req_line_tbl(l_line_index).Active_date_first_type := 'ORD';
4391: px_req_line_tbl(l_line_index).Active_date_first := OE_Order_Pub.G_HDR.Ordered_date;
4392:
4393: If p_Line_rec.schedule_ship_date is not null then
4394: px_req_line_tbl(l_line_index).Active_date_Second_type := 'SHIP';
4395: px_req_line_tbl(l_line_index).Active_date_Second := p_Line_rec.schedule_ship_date;
4404:
4405: procedure copy_adjs_to_request(
4406: p_line_index pls_integer
4407: ,p_adj_index pls_integer
4408: ,p_Line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type
4409: ,px_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_tbl_Type
4410: )
4411: is
4412: l_RLD_Index pls_integer := p_adj_index;
4489:
4490: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
4491: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
4492:
4493: If OE_Order_PUB.G_Line.agreement_id is not null and
4494: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
4495: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4496: -- BLANKETS: Start Code Merge
4497: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4490: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
4491: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
4492:
4493: If OE_Order_PUB.G_Line.agreement_id is not null and
4494: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
4495: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4496: -- BLANKETS: Start Code Merge
4497: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4498: OE_Order_PUB.G_Line.blanket_number is not null and
4494: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
4495: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4496: -- BLANKETS: Start Code Merge
4497: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4498: OE_Order_PUB.G_Line.blanket_number is not null and
4499: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4500: OE_Order_PUB.G_Line.blanket_line_number is not null and
4501: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4502: Then
4495: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4496: -- BLANKETS: Start Code Merge
4497: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4498: OE_Order_PUB.G_Line.blanket_number is not null and
4499: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4500: OE_Order_PUB.G_Line.blanket_line_number is not null and
4501: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4502: Then
4503:
4496: -- BLANKETS: Start Code Merge
4497: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4498: OE_Order_PUB.G_Line.blanket_number is not null and
4499: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4500: OE_Order_PUB.G_Line.blanket_line_number is not null and
4501: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4502: Then
4503:
4504: -- Set validated_flag to 'Y' if price list is AGR
4497: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4498: OE_Order_PUB.G_Line.blanket_number is not null and
4499: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4500: OE_Order_PUB.G_Line.blanket_line_number is not null and
4501: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4502: Then
4503:
4504: -- Set validated_flag to 'Y' if price list is AGR
4505: -- type or enforce price list is checked on blanket.
4503:
4504: -- Set validated_flag to 'Y' if price list is AGR
4505: -- type or enforce price list is checked on blanket.
4506: If Get_List_Type
4507: (OE_Order_PUB.G_Line.price_list_id) = 'AGR'
4508: OR Get_Enforce_Price_List
4509: (OE_Order_PUB.G_Line.blanket_number
4510: ,OE_Order_PUB.G_Line.blanket_line_number)='Y'
4511: Then
4505: -- type or enforce price list is checked on blanket.
4506: If Get_List_Type
4507: (OE_Order_PUB.G_Line.price_list_id) = 'AGR'
4508: OR Get_Enforce_Price_List
4509: (OE_Order_PUB.G_Line.blanket_number
4510: ,OE_Order_PUB.G_Line.blanket_line_number)='Y'
4511: Then
4512:
4513: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4506: If Get_List_Type
4507: (OE_Order_PUB.G_Line.price_list_id) = 'AGR'
4508: OR Get_Enforce_Price_List
4509: (OE_Order_PUB.G_Line.blanket_number
4510: ,OE_Order_PUB.G_Line.blanket_line_number)='Y'
4511: Then
4512:
4513: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4514:
5464:
5465: end Append_asked_for;
5466:
5467: procedure Get_the_parent_Line(p_Reference_line_Id Number,
5468: px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type,
5469: px_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.Related_Lines_Tbl_Type,
5470: p_line_Tbl_index Number)
5471: is
5472: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
5468: px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type,
5469: px_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.Related_Lines_Tbl_Type,
5470: p_line_Tbl_index Number)
5471: is
5472: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
5473: line_Tbl_Index pls_integer;
5474: l_related_lines_Index pls_integer;
5475: Begin
5476: G_STMT_NO := 'Get_the_parent_Line#10';
5511:
5512: End Get_the_parent_Line;
5513:
5514: procedure set_item_for_iue(
5515: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
5516: ,p_req_line_detail_rec QP_PREQ_GRP.line_detail_rec_type
5517: )
5518: is
5519: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5559:
5560: adj_debug('Exiting oe_order_Adj_pvt.set_item_for_iue');
5561: end set_item_for_iue;
5562:
5563: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
5564: is
5565: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5566: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5567: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5612: p_use_current_header in Boolean Default FALSE
5613: --if use_current_header set to true, it will not set the header info
5614: --and it will use current header information set by the caller.
5615: --It is useful when getting a quote where header_id is not available.
5616: --in this case the caller will need to set Oe_Order_Pub.G_Hdr values
5617: ,p_write_to_db Boolean Default TRUE
5618: ,x_any_frozen_line out nocopy Boolean
5619:
5620: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5616: --in this case the caller will need to set Oe_Order_Pub.G_Hdr values
5617: ,p_write_to_db Boolean Default TRUE
5618: ,x_any_frozen_line out nocopy Boolean
5619:
5620: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5621:
5622: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5623: ,p_honor_price_flag VARCHAR2 Default 'Y'
5624: ,p_multiple_events in VARCHAR2 Default 'N'
5618: ,x_any_frozen_line out nocopy Boolean
5619:
5620: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5621:
5622: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5623: ,p_honor_price_flag VARCHAR2 Default 'Y'
5624: ,p_multiple_events in VARCHAR2 Default 'N'
5625: ,p_action_code in VARCHAR2 Default 'NONE'
5626: )
5626: )
5627: is
5628: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5629: l_return_status_Text varchar2(240) ;
5630: l_header_rec OE_Order_PUB.Header_Rec_Type;
5631: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5632: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5633: --1472635
5634: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5627: is
5628: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5629: l_return_status_Text varchar2(240) ;
5630: l_header_rec OE_Order_PUB.Header_Rec_Type;
5631: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5632: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5633: --1472635
5634: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5635: i2 PLS_INTEGER;
5628: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5629: l_return_status_Text varchar2(240) ;
5630: l_header_rec OE_Order_PUB.Header_Rec_Type;
5631: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5632: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5633: --1472635
5634: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5635: i2 PLS_INTEGER;
5636: l_all_lines_from_db Boolean :=False;
5630: l_header_rec OE_Order_PUB.Header_Rec_Type;
5631: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5632: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5633: --1472635
5634: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5635: i2 PLS_INTEGER;
5636: l_all_lines_from_db Boolean :=False;
5637:
5638: l_Line_Rec OE_Order_PUB.Line_Rec_Type;
5634: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5635: i2 PLS_INTEGER;
5636: l_all_lines_from_db Boolean :=False;
5637:
5638: l_Line_Rec OE_Order_PUB.Line_Rec_Type;
5639: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5640: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5641: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5642: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5725:
5726: Begin
5727:
5728: oe_Header_util.query_row (p_header_id => p_Header_id
5729: ,x_header_rec=>OE_Order_PUB.g_hdr );
5730: Exception when no_data_found then
5731: x_return_status := 'NOOP';
5732: adj_debug(G_STMT_NO||'Invalid header_id '||p_Header_id,1);
5733: Return;
5748: -- bug 9728497 end
5749:
5750: oe_debug_pub.add('Pricing Engine return pass all_lines value:'||l_order_status_rec.ALL_LINES_FLAG);
5751: oe_debug_pub.add('Pricing Engine return pass changed line value:'||l_order_status_rec.Changed_Lines_Flag);
5752: oe_debug_pub.add('Cache header operation:'||oe_order_pub.g_hdr.operation);
5753:
5754:
5755: If G_INT_CHANGED_LINE_ON = 'Y' Then
5756: If (l_order_status_rec.ALL_LINES_FLAG = 'Y' and nvl(OE_LINE_ADJ_UTIL.G_SEND_ALL_LINES_FOR_DSP,'Y') = 'Y') --bug 2965218
5847: If p_use_current_header = FALSE Then
5848: Begin
5849: If l_line_tbl.first is not null Then
5850: oe_Header_util.query_row
5851: (p_header_id=> l_line_Tbl(l_line_tbl.first).Header_id, x_header_rec => OE_Order_PUB.g_hdr );
5852: Else
5853: oe_debug_pub.add(' Error: No line records in l_line_tbl');
5854: End If;
5855:
5909: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then
5910:
5911:
5912: -- Populate that Global Structure
5913: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
5914: -- uom begin
5915: If OE_Order_PUB.G_LINE.unit_list_price_per_pqty = fnd_api.g_miss_num then
5916: OE_Order_PUB.G_LINE.unit_list_price_per_pqty:= Null;
5917: End If;
5911:
5912: -- Populate that Global Structure
5913: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
5914: -- uom begin
5915: If OE_Order_PUB.G_LINE.unit_list_price_per_pqty = fnd_api.g_miss_num then
5916: OE_Order_PUB.G_LINE.unit_list_price_per_pqty:= Null;
5917: End If;
5918: -- uom end
5919:
5912: -- Populate that Global Structure
5913: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
5914: -- uom begin
5915: If OE_Order_PUB.G_LINE.unit_list_price_per_pqty = fnd_api.g_miss_num then
5916: OE_Order_PUB.G_LINE.unit_list_price_per_pqty:= Null;
5917: End If;
5918: -- uom end
5919:
5920: -- Check if the line is service item
5919:
5920: -- Check if the line is service item
5921:
5922: G_STMT_NO := 'calculate_adjustments#120';
5923: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
5924: FND_API.G_MISS_NUM and
5925: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
5926: Then
5927:
5921:
5922: G_STMT_NO := 'calculate_adjustments#120';
5923: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
5924: FND_API.G_MISS_NUM and
5925: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
5926: Then
5927:
5928: /* Added the following if condition for fixing the bug 1828553 */
5929: /* If the service reference context is ORDER, then the service_reference*/
5970: End If;
5971:
5972: -- Get Line Attributes
5973: G_STMT_NO := 'calculate_adjustments#130';
5974: Get_Item_For_Iue(px_line_rec => OE_Order_Pub.G_Line);
5975:
5976: If l_bypass_pricing = 'Y' Then
5977:
5978: adj_debug('Bypassing the qualifier build',1);
6204: l_calculate_price_flag := 'Y';
6205: END IF;
6206:
6207: copy_Header_to_request(
6208: p_header_rec => OE_Order_PUB.g_hdr
6209: ,px_req_line_tbl => l_req_line_tbl
6210: ,p_Request_Type_Code => p_Request_Type_Code
6211: ,p_calculate_price_flag =>l_calculate_price_flag
6212: );
6288:
6289: --Q means ask pricing engine to determine rounding options.
6290: l_control_rec.rounding_flag := 'Q';
6291: l_control_rec.use_multi_currency:='Y';
6292: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6293: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6294: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6295: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6296:
6289: --Q means ask pricing engine to determine rounding options.
6290: l_control_rec.rounding_flag := 'Q';
6291: l_control_rec.use_multi_currency:='Y';
6292: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6293: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6294: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6295: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6296:
6297: G_STMT_NO := 'QP_PRICE_REQUEST_GRP';
6362: x_Req_line_detail_attr_tbl := l_req_line_detail_attr_tbl;
6363: x_Req_related_lines_tbl := l_req_related_lines_tbl;
6364: */
6365:
6366: x_header_Rec := OE_Order_PUB.g_hdr;
6367: x_line_tbl := l_line_tbl;
6368:
6369: --reseting global structure after engine call
6370: OE_Order_PUB.G_LINE := NULL;
6366: x_header_Rec := OE_Order_PUB.g_hdr;
6367: x_line_tbl := l_line_tbl;
6368:
6369: --reseting global structure after engine call
6370: OE_Order_PUB.G_LINE := NULL;
6371: OE_Order_PUB.G_HDR := NULL;
6372: -- Process the lines...
6373:
6374: adj_debug('Exiting oe_order_Adj_pvt.calulate_adjustments', 1);
6367: x_line_tbl := l_line_tbl;
6368:
6369: --reseting global structure after engine call
6370: OE_Order_PUB.G_LINE := NULL;
6371: OE_Order_PUB.G_HDR := NULL;
6372: -- Process the lines...
6373:
6374: adj_debug('Exiting oe_order_Adj_pvt.calulate_adjustments', 1);
6375:
6430:
6431: end calculate_adjustments;
6432:
6433: Function Update_Adj_Line_rec(
6434: p_Line_Adj_Rec in out nocopy OE_Order_Pub.Line_Adj_Rec_Type
6435: ,p_req_line_detail_Rec qp_preq_grp.line_detail_rec_type
6436: )
6437: Return Boolean
6438: is
6730: Procedure Find_Duplicate_Adj_Lines(
6731: p_header_Id Number default null
6732: ,p_Line_id Number default null
6733: ,p_req_line_detail_Rec qp_preq_grp.line_detail_rec_type
6734: ,px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
6735: ,X_Adj_Index out nocopy Number
6736:
6737: ,p_mode in Varchar2
6738: ,px_line_key_tbl in out nocopy key_tbl_type
6821: If x_adj_index= -1 or x_adj_index > l_end_index Then
6822: -- This is a new Record
6823: --
6824: x_Adj_Index := px_line_adj_Tbl.count + 1;
6825: px_line_adj_tbl(x_adj_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
6826: px_line_adj_Tbl(x_Adj_Index).operation := OE_GLOBALS.G_OPR_CREATE;
6827: px_line_adj_Tbl(x_Adj_Index).Updated_Flag := 'N';
6828: px_line_adj_Tbl(x_Adj_Index).adjusted_amount_per_pqty := null;
6829: --
6894:
6895: Procedure Query_Adj_Assocs(
6896: p_price_adjustment_id Number,
6897: p_Adj_Index Number,
6898: p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.line_adj_Assoc_tbl_Type,
6899: p_delete_flag in Varchar2 default 'Y'
6900: ) Is
6901: L_Line_Adj_Assoc_Tbl OE_Order_Pub.line_adj_Assoc_tbl_Type;
6902: l_index pls_integer;
6897: p_Adj_Index Number,
6898: p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.line_adj_Assoc_tbl_Type,
6899: p_delete_flag in Varchar2 default 'Y'
6900: ) Is
6901: L_Line_Adj_Assoc_Tbl OE_Order_Pub.line_adj_Assoc_tbl_Type;
6902: l_index pls_integer;
6903: i pls_integer;
6904: Begin
6905: adj_debug('Entering oe_order_Adj_pvt.Query_Adj_Assocs',1);
6959: p_line_id Number default null,
6960: p_Pricing_Event Varchar2 default null,
6961: p_any_frozen_line Boolean default FALSE,
6962: p_price_flag VARCHAR2 default null,
6963: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
6964: px_line_key_tbl in out nocopy key_tbl_type,
6965: px_header_key_tbl in out nocopy key_tbl_type,
6966: p_mode in varchar2 default NULL,
6967: px_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
6963: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
6964: px_line_key_tbl in out nocopy key_tbl_type,
6965: px_header_key_tbl in out nocopy key_tbl_type,
6966: p_mode in varchar2 default NULL,
6967: px_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
6968: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_Tbl_type,
6969: x_updated_flag out nocopy varchar2,
6970:
6971: p_multiple_events in VARCHAR2 Default 'N'
6964: px_line_key_tbl in out nocopy key_tbl_type,
6965: px_header_key_tbl in out nocopy key_tbl_type,
6966: p_mode in varchar2 default NULL,
6967: px_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
6968: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_Tbl_type,
6969: x_updated_flag out nocopy varchar2,
6970:
6971: p_multiple_events in VARCHAR2 Default 'N'
6972: )
6971: p_multiple_events in VARCHAR2 Default 'N'
6972: )
6973: is
6974: l_Pricing_Phase_id Index_Tbl_Type;
6975: l_Line_Adj_Tbl OE_Order_Pub.Line_Adj_Tbl_Type;
6976: i pls_integer;
6977: J pls_integer;
6978: p_override_freeze_flag VARCHAR2(1) := NULL;
6979: l_visited_flag BOOLEAN Default FALSE;
7137:
7138: Procedure Query_Adj_Attribs(
7139: p_price_adjustment_id Number,
7140: p_Adj_Index Number,
7141: p_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type
7142: ) Is
7143: L_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;
7144: l_index pls_integer;
7145: Begin
7139: p_price_adjustment_id Number,
7140: p_Adj_Index Number,
7141: p_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type
7142: ) Is
7143: L_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;
7144: l_index pls_integer;
7145: Begin
7146: adj_debug('Entering oe_order_Adj_pvt.Query_Adj_Attribs',1);
7147:
7193: QP_PREQ_GRP.Line_Detail_Qual_Rec_Type,
7194: p_Req_Line_Detail_Attr_Rec
7195: QP_PREQ_GRP.Line_Detail_Attr_Rec_Type,
7196: p_Adj_index Number,
7197: p_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.Line_Adj_Att_Tbl_Type,
7198: p_att_type Varchar2,
7199: p_price_adjustment_id Number
7200: )
7201: is
7241:
7242: G_STMT_NO := 'Find_Duplicate_Adj_Attribs#20';
7243: -- Create a New Record
7244: l_index := p_Line_Adj_Att_Tbl.count+1;
7245: p_Line_Adj_Att_Tbl(l_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_REC;
7246: p_Line_Adj_Att_Tbl(l_index).operation := OE_GLOBALS.G_OPR_CREATE;
7247: p_Line_Adj_Att_Tbl(l_index).Adj_index := P_Adj_Index;
7248: p_Line_Adj_Att_Tbl(l_index).price_adjustment_id := p_price_adjustment_id;
7249: p_Line_Adj_Att_Tbl(l_index).flex_title := 'QP_ATTR_DEFNS_QUALIFIER';
7297: End Loop;
7298:
7299: -- Create a New Record
7300: l_index := p_Line_Adj_Att_Tbl.count+1;
7301: p_line_adj_att_tbl(l_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_REC;
7302: p_Line_Adj_Att_Tbl(l_index).operation := OE_GLOBALS.G_OPR_CREATE;
7303: p_Line_Adj_Att_Tbl(l_index).Adj_index := P_Adj_Index;
7304: p_Line_Adj_Att_Tbl(l_index).price_adjustment_id := p_price_adjustment_id;
7305: p_Line_Adj_Att_Tbl(l_index).flex_title := 'QP_ATTR_DEFNS_PRICING';
7374: ,p_Parent_Adj_Index Number
7375: ,p_parent_line_index Number
7376: ,p_Rltd_line_details_prcd in out nocopy Index_Tbl_Type
7377: ,p_Rltd_lines_prcd in out nocopy Index_Tbl_Type
7378: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7379: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7380: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7381: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7382: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7375: ,p_parent_line_index Number
7376: ,p_Rltd_line_details_prcd in out nocopy Index_Tbl_Type
7377: ,p_Rltd_lines_prcd in out nocopy Index_Tbl_Type
7378: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7379: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7380: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7381: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7382: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7383: )
7376: ,p_Rltd_line_details_prcd in out nocopy Index_Tbl_Type
7377: ,p_Rltd_lines_prcd in out nocopy Index_Tbl_Type
7378: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7379: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7380: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7381: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7382: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7383: )
7384: is
7378: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7379: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7380: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7381: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7382: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7383: )
7384: is
7385: l_line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
7386: l_line_Rec OE_Order_Pub.Line_Rec_Type;
7381: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7382: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7383: )
7384: is
7385: l_line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
7386: l_line_Rec OE_Order_Pub.Line_Rec_Type;
7387: l_Match_Exists Boolean := False;
7388: l_Req_Line_Index pls_integer;
7389: l_Adj_Index pls_integer;
7382: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7383: )
7384: is
7385: l_line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
7386: l_line_Rec OE_Order_Pub.Line_Rec_Type;
7387: l_Match_Exists Boolean := False;
7388: l_Req_Line_Index pls_integer;
7389: l_Adj_Index pls_integer;
7390: l_assoc_index pls_integer;
7615: -- Check If this Related Line Has Already been processed in an earlier loop
7616: If Not p_Rltd_lines_prcd.exists(l_Req_Line_Index) Then
7617:
7618: adj_debug('Creating a new line record for header '||P_Header_Id);
7619: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
7620: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
7621:
7622: l_line_rec.Header_id := P_Header_Id;
7623: --for bug 2412868 Begin
7767:
7768: If Not p_Rltd_line_details_prcd.exists(p_Line_detail_Index) Then
7769:
7770: l_Adj_Index := p_line_adj_Tbl.count+1;
7771: p_line_adj_tbl(l_adj_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
7772: p_line_adj_Tbl(l_Adj_Index).operation := OE_GLOBALS.G_OPR_CREATE;
7773:
7774: adj_debug('Creating an adjustment record for PRG '||l_Adj_Index);
7775: If Update_Adj_Line_rec(
7798:
7799: --Commented for Bug2211670
7800: -- l_assoc_index := p_Line_Adj_Assoc_tbl.count+1;
7801:
7802: p_line_adj_assoc_tbl(l_assoc_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
7803: p_Line_Adj_Assoc_tbl(l_assoc_index).line_index := Null;
7804: p_Line_Adj_Assoc_tbl(l_assoc_index).Adj_Index := P_Parent_Adj_Index;
7805: p_Line_Adj_Assoc_tbl(l_assoc_index).Rltd_Adj_Index :=
7806: p_Rltd_line_Details_prcd(p_Line_detail_Index);
7922:
7923: Function find_updated_adjustments(
7924: p_header_id number default null
7925: ,p_Line_id number default null
7926: ,p_Line_Adj_Tbl oe_order_pub.line_adj_tbl_type
7927: )
7928: Return boolean
7929: is
7930: i pls_integer;
8238:
8239: end CAlculate_Adjusted_Price;
8240:
8241: Procedure Calculate_Price (
8242: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8243: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8244: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8245: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8246: ,p_allow_Negative_Price Varchar2
8239: end CAlculate_Adjusted_Price;
8240:
8241: Procedure Calculate_Price (
8242: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8243: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8244: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8245: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8246: ,p_allow_Negative_Price Varchar2
8247: ,p_request_Type_Code Varchar2
8240:
8241: Procedure Calculate_Price (
8242: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8243: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8244: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8245: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8246: ,p_allow_Negative_Price Varchar2
8247: ,p_request_Type_Code Varchar2
8248: ,p_any_line_frozen Boolean default False
8241: Procedure Calculate_Price (
8242: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8243: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8244: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8245: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8246: ,p_allow_Negative_Price Varchar2
8247: ,p_request_Type_Code Varchar2
8248: ,p_any_line_frozen Boolean default False
8249: ,p_price_event Varchar2 default null --for bug 2273446
8283:
8284: --moac
8285: l_gsa_violation_action := oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION',p_header_rec.org_id);
8286:
8287: --OE_Order_Pub.G_HDR := p_header_rec;
8288:
8289: G_STMT_NO := 'Calculate_Price#05';
8290: i := p_Line_Adj_Tbl.First;
8291:
8921: Order no longer qualifies for PRG modifier. Either delete (or) update
8922: the free goods lines, depending on whether they are shipped or not
8923: */
8924: PROCEDURE change_prg_lines(p_price_adjustment_id IN NUMBER,
8925: p_line_tbl IN OUT NoCopy OE_Order_PUB.Line_Tbl_Type,
8926: p_line_adj_tbl IN OUT NoCopy OE_Order_PUB.Line_Adj_Tbl_Type,
8927: p_delete_prg_lines IN OUT NoCopy index_tbl_type) IS
8928:
8929: Cursor prg_lines is
8922: the free goods lines, depending on whether they are shipped or not
8923: */
8924: PROCEDURE change_prg_lines(p_price_adjustment_id IN NUMBER,
8925: p_line_tbl IN OUT NoCopy OE_Order_PUB.Line_Tbl_Type,
8926: p_line_adj_tbl IN OUT NoCopy OE_Order_PUB.Line_Adj_Tbl_Type,
8927: p_delete_prg_lines IN OUT NoCopy index_tbl_type) IS
8928:
8929: Cursor prg_lines is
8930: Select radj.line_id
8940:
8941: l_prg_line_id NUMBER;
8942: l_found_prg_line BOOLEAN;
8943: l_match_phase_id BOOLEAN := FALSE;
8944: l_line_rec OE_ORDER_PUB.line_rec_type;
8945: l_phase_id NUMBER;
8946: pricing_ph_id NUMBER;
8947: j PLS_INTEGER;
8948: l_return_status VARCHAR2(30);
9083: p_Req_Line_Detail_Attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type,
9084: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
9085: ,p_write_to_db Boolean
9086: ,p_any_frozen_line in Boolean
9087: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
9088: ,p_header_rec oe_Order_Pub.header_rec_type
9089: ,p_multiple_events in Varchar2 Default 'N'
9090: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
9091: )
9084: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
9085: ,p_write_to_db Boolean
9086: ,p_any_frozen_line in Boolean
9087: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
9088: ,p_header_rec oe_Order_Pub.header_rec_type
9089: ,p_multiple_events in Varchar2 Default 'N'
9090: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
9091: )
9092: is
9093: l_Req_Line_Detail_qual_Rec QP_PREQ_GRP.line_detail_qual_rec_type;
9094: l_Req_Line_Detail_attr_Rec QP_PREQ_GRP.line_detail_attr_rec_type;
9095: l_req_line_rec qp_preq_grp.line_rec_type;
9096: l_control_rec Oe_Globals.Control_rec_type;
9097: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9098: --l_old_line_rec oe_order_pub.line_rec_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9094: l_Req_Line_Detail_attr_Rec QP_PREQ_GRP.line_detail_attr_rec_type;
9095: l_req_line_rec qp_preq_grp.line_rec_type;
9096: l_control_rec Oe_Globals.Control_rec_type;
9097: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9098: --l_old_line_rec oe_order_pub.line_rec_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9095: l_req_line_rec qp_preq_grp.line_rec_type;
9096: l_control_rec Oe_Globals.Control_rec_type;
9097: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9098: --l_old_line_rec oe_order_pub.line_rec_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9096: l_control_rec Oe_Globals.Control_rec_type;
9097: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9098: --l_old_line_rec oe_order_pub.line_rec_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9097: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9098: --l_old_line_rec oe_order_pub.line_rec_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9098: --l_old_line_rec oe_order_pub.line_rec_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9099: l_line_rec oe_order_pub.line_rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9100: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9101: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9102: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9103: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9104: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9105: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9106: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9107: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9108: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9109: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9110: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9111: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9112: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9113: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9121: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9114: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9121: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9122: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9115: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9121: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9122: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9123: l_x_msg_count number;
9116: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9121: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9122: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9123: l_x_msg_count number;
9124: l_x_msg_data Varchar2(2000);
9117: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9121: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9122: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9123: l_x_msg_count number;
9124: l_x_msg_data Varchar2(2000);
9125: l_x_result_out Varchar2(30);
9118: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9119: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9120: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9121: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9122: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9123: l_x_msg_count number;
9124: l_x_msg_data Varchar2(2000);
9125: l_x_result_out Varchar2(30);
9126: l_line_details_prcd Index_Tbl_Type;
9155: l_invalid_line Varchar2(1):= 'N';
9156: --Manual begin
9157: l_preinsert_manual_adj VARCHAR2(1):= Nvl(Fnd_Profile.Value('ONT_PREINSERT_MANUAL_ADJ'),'N');
9158: --Manual end
9159: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
9160: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD'); -- PROMOTIONS SEP/01
9161:
9162: /* Promotional modifier issues - Bug 1503357 */
9163: l_delete_prg_lines index_tbl_type;
9182: l_source_document_line_id NUMBER;
9183:
9184: rec_cnt NUMBER := 0;
9185: --serla begin
9186: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
9187: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
9188: --serla end
9189: begin
9190:
9183:
9184: rec_cnt NUMBER := 0;
9185: --serla begin
9186: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
9187: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
9188: --serla end
9189: begin
9190:
9191: x_return_status := FND_API.G_RET_STS_SUCCESS;
10070: l_assoc_index := l_Line_Adj_Assoc_tbl.last+1;
10071: ELSE
10072: l_assoc_index := 1;
10073: END IF;
10074: l_Line_Adj_Assoc_tbl(l_assoc_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
10075: l_Line_Adj_Assoc_tbl(l_assoc_index).Line_Index := Null;
10076: l_Line_Adj_Assoc_tbl(l_assoc_index).Adj_Index :=
10077: l_line_details_prcd(p_Req_Related_Lines_Tbl(i).Line_Detail_Index);
10078: l_Line_Adj_Assoc_tbl(l_assoc_index).Rltd_Adj_Index :=
10915:
10916: Function Bypass_Performance_Path(
10917: p_Header_id Number Default Null
10918: , p_Line_id Number Default Null
10919: , px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
10920: ) Return Boolean
10921: IS
10922: l_source_document_type_id NUMBER;
10923: l_booked_flag Varchar2(1);
10920: ) Return Boolean
10921: IS
10922: l_source_document_type_id NUMBER;
10923: l_booked_flag Varchar2(1);
10924: l_header_rec OE_Order_PUB.Header_Rec_Type;
10925: l_header_id NUMBER;
10926: l_tmp_no number;
10927: Begin
10928:
11024: ,p_Header_id Number Default Null
11025: ,p_Request_Type_code Varchar2
11026: ,p_Control_Rec QP_PREQ_GRP.control_record_type
11027: ,p_write_to_db Boolean Default TRUE
11028: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
11029: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
11030: ,p_honor_price_flag VARCHAR2 Default 'Y'
11031: ,p_multiple_events in Varchar2 default 'N'
11032: ,p_action_code in Varchar2 default Null
11025: ,p_Request_Type_code Varchar2
11026: ,p_Control_Rec QP_PREQ_GRP.control_record_type
11027: ,p_write_to_db Boolean Default TRUE
11028: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
11029: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
11030: ,p_honor_price_flag VARCHAR2 Default 'Y'
11031: ,p_multiple_events in Varchar2 default 'N'
11032: ,p_action_code in Varchar2 default Null
11033: )
11040: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
11041: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
11042: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
11043: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
11044: lx_Header_Rec oe_Order_Pub.Header_REc_Type;
11045: l_dummy varchar2(1);
11046: l_any_frozen_line Boolean;
11047: l_price_control_rec OE_ORDER_PRICE_pvt.control_rec_type;
11048: --For bug#2675212
11212:
11213: ,p_Header_id Number DEfault null
11214: ,p_Line_id Number DEfault null
11215: ,p_request_type_code varchar2
11216: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
11217:
11218: )
11219: is
11220: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11218: )
11219: is
11220: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11221: l_control_rec Oe_Globals.Control_rec_type;
11222: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11223: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11219: is
11220: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11221: l_control_rec Oe_Globals.Control_rec_type;
11222: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11223: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11220: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11221: l_control_rec Oe_Globals.Control_rec_type;
11222: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11223: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11221: l_control_rec Oe_Globals.Control_rec_type;
11222: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11223: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11222: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11223: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11223: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11224: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11225: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11226: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11227: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11228: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11229: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11230: l_header_rec OE_Order_PUB.Header_Rec_Type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11231: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11232: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11233: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11234: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11235: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11243: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11236: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11243: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11244: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11237: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11243: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11244: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11245: l_x_msg_count number;
11238: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11243: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11244: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11245: l_x_msg_count number;
11246: l_x_msg_data Varchar2(2000);
11239: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11243: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11244: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11245: l_x_msg_count number;
11246: l_x_msg_data Varchar2(2000);
11247: i pls_integer;
11240: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11241: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11242: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11243: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11244: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11245: l_x_msg_count number;
11246: l_x_msg_data Varchar2(2000);
11247: i pls_integer;
11248: l_line_index pls_integer;
11252: l_set_price_flag_on_manual Varchar2(30) := nvl(fnd_profile.value('ONT_SET_PRICE_FLAG_ON_MANUAL'),'N');
11253: --Manual End
11254: l_dummy key_tbl_type;
11255: l_updated_flag varchar2(1);
11256: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
11257: l_price_control_rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE;
11258: x_line_tbl oe_order_pub.line_tbl_type;
11259: l_status_code Varchar2(5);
11260: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11254: l_dummy key_tbl_type;
11255: l_updated_flag varchar2(1);
11256: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
11257: l_price_control_rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE;
11258: x_line_tbl oe_order_pub.line_tbl_type;
11259: l_status_code Varchar2(5);
11260: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11261: --serla begin
11262: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11258: x_line_tbl oe_order_pub.line_tbl_type;
11259: l_status_code Varchar2(5);
11260: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11261: --serla begin
11262: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11263: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
11264: --serla end
11265: begin
11266:
11259: l_status_code Varchar2(5);
11260: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11261: --serla begin
11262: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11263: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
11264: --serla end
11265: begin
11266:
11267: adj_debug('Entering oe_order_Adj_pvt.Price_adjustments',1);
11620: )
11621: is
11622: l_Price_Control_rec QP_PREQ_GRP.control_record_type;
11623: l_return_status varchar2(1);
11624: l_x_line_tbl oe_order_pub.line_tbl_type;
11625: l_line_id number;
11626: l_header_id number;
11627: l_delimiter1 number;
11628: l_delimiter2 number;
11630: l_booked_flag varchar2(1);
11631: l_multiple_events Varchar2(1);
11632: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
11633: l_prev_line_hdr_id Number;
11634: l_locked_header_rec OE_ORDER_PUB.Header_Rec_Type; --13727700
11635:
11636: cursor has_prg_lines(p_line_id IN NUMBER) is
11637: Select 'Y'
11638: From OE_PRICE_ADJUSTMENTS a, OE_ORDER_LINES_ALL b
12018: )
12019: is
12020: l_Price_Control_rec QP_PREQ_GRP.control_record_type;
12021: l_return_status varchar2(1);
12022: l_x_line_tbl oe_order_pub.line_tbl_type;
12023: l_line_list varchar2(32000) := p_line_list;
12024: l_Header_list varchar2(32000) := p_Header_list;
12025: l_line_id number;
12026: l_header_id number;
12038: AND b.header_id = a.header_id
12039: And a.list_line_type_code = 'PRG';
12040:
12041: l_has_prg_lines varchar2(1):= 'Q';
12042: l_locked_header_rec OE_ORDER_PUB.Header_Rec_Type; --14647325
12043:
12044: begin
12045: adj_debug('Performing Price Action for level '||P_price_level);
12046:
12247:
12248:
12249: Procedure Set_Header(p_header IN quote_header_rec_type) As
12250: Begin
12251: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12252: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12248:
12249: Procedure Set_Header(p_header IN quote_header_rec_type) As
12250: Begin
12251: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12252: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12249: Procedure Set_Header(p_header IN quote_header_rec_type) As
12250: Begin
12251: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12252: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12250: Begin
12251: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12252: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12251: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12252: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12252: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12253: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12254: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12255: oe_order_pub.g_hdr.context :=p_header.context ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12256: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12257: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12258: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12259: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12260: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12261: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12262: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12263: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12264: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12265: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12266: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12267: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12268: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12269: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12270: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12271: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12272: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12273: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12274: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12275: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12276: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12277: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12278: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12279: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12280: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12281: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12282: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12283: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12284: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12285: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12286: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12287: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12288: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12289: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12290: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12291: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12292: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12293: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12294: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12302: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12295: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12302: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12303: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12296: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12302: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12303: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12304:
12297: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12302: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12303: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12304:
12305: End Set_Header;
12298: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12302: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12303: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12304:
12305: End Set_Header;
12306:
12299: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12300: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12301: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12302: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12303: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12304:
12305: End Set_Header;
12306:
12307: Procedure Load_Line_Tbl(p_quote_line_tbl in quote_line_tbl_type,
12304:
12305: End Set_Header;
12306:
12307: Procedure Load_Line_Tbl(p_quote_line_tbl in quote_line_tbl_type,
12308: x_line_tbl out nocopy Oe_Order_Pub.line_tbl_type) As
12309:
12310: i PLS_INTEGER;
12311: Begin
12312: --DBMS_OUTPUT.PUT_LINE('In load line tbl');
12371: End Loop;
12372:
12373: End;
12374:
12375: Procedure Load_Out_Quote_Line (p_line_tbl In Oe_Order_Pub.Line_tbl_Type,
12376: p_req_line_tbl In QP_PREQ_GRP.LINE_TBL_TYPE,
12377: x_quote_line_tbl out nocopy quote_line_tbl_type) As
12378:
12379: i PLS_INTEGER;
12475:
12476: x_return_status_text out nocopy Varchar2) As
12477:
12478:
12479: l_line_tbl Oe_Order_Pub.line_tbl_type;
12480: l_control_rec Qp_Preq_Grp.control_record_type;
12481: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
12482: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12483: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12485: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
12486: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
12487: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
12488: l_any_frozen_line Boolean;
12489: l_hdr_rec Oe_Order_Pub.Header_Rec_Type;
12490: l_stmt Varchar2(50);
12491: i PLS_INTEGER;
12492: Begin
12493:
12556: Procedure Create_Manual_Adjustments(p_line_id In Number)
12557: As
12558: l_return_stauts Varchar2(15);
12559: l_manual_adj_tbl Oe_Order_Adj_Pvt.Manual_Adj_Tbl_Type;
12560: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
12561: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
12562: l_control_rec OE_GLOBALS.Control_Rec_Type;
12563: i PLS_INTEGER;
12564: k PLS_INTEGER:=1;
12557: As
12558: l_return_stauts Varchar2(15);
12559: l_manual_adj_tbl Oe_Order_Adj_Pvt.Manual_Adj_Tbl_Type;
12560: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
12561: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
12562: l_control_rec OE_GLOBALS.Control_Rec_Type;
12563: i PLS_INTEGER;
12564: k PLS_INTEGER:=1;
12565: l_return_status Varchar2(15);
12656:
12657: Procedure Get_Manual_Adjustments (
12658: p_header_id in number Default Null,
12659: p_line_id in number Default Null,
12660: p_line_rec in oe_Order_Pub.Line_Rec_Type Default oe_order_pub.g_miss_line_rec,
12661: p_level in Varchar2 default 'LINE',
12662: p_pbh_mode in Varchar2 default 'CHILD',
12663: p_cross_order in Varchar2 Default 'N',
12664: p_line_level in Varchar2 Default 'N',
12672: --if no header id passed in this procedure it will return header id based on line id passed in
12673: )
12674: As
12675: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12676: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12677: l_line_rec oe_order_pub.line_rec_type;
12678: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12679: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12680: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12673: )
12674: As
12675: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12676: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12677: l_line_rec oe_order_pub.line_rec_type;
12678: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12679: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12680: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12681: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12845: Else
12846: l_line_tbl(1):= p_line_rec;
12847: End If;
12848:
12849: OE_Order_PUB.G_LINE := NULL;
12850: OE_Order_PUB.G_HDR := NULL;
12851:
12852: If p_header_id is Not Null and p_cross_order = 'N' Then
12853: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12846: l_line_tbl(1):= p_line_rec;
12847: End If;
12848:
12849: OE_Order_PUB.G_LINE := NULL;
12850: OE_Order_PUB.G_HDR := NULL;
12851:
12852: If p_header_id is Not Null and p_cross_order = 'N' Then
12853: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12854: End If;
12849: OE_Order_PUB.G_LINE := NULL;
12850: OE_Order_PUB.G_HDR := NULL;
12851:
12852: If p_header_id is Not Null and p_cross_order = 'N' Then
12853: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12854: End If;
12855:
12856:
12857: G_STMT_NO := 'Get_manual_adjustment#1';
12860:
12861: --Cross order lines, lines may not came from same header need to query header for each line
12862: If p_cross_order = 'Y' and p_header_id Is Null Then
12863: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,
12864: x_header_rec => OE_Order_PUB.g_hdr );
12865: oe_debug_pub.add(' Currency Code:'||OE_Order_PUB.g_hdr.transactional_curr_code);
12866: x_header_id := l_line_tbl(line_tbl_index).header_id;
12867: End If;
12868:
12861: --Cross order lines, lines may not came from same header need to query header for each line
12862: If p_cross_order = 'Y' and p_header_id Is Null Then
12863: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,
12864: x_header_rec => OE_Order_PUB.g_hdr );
12865: oe_debug_pub.add(' Currency Code:'||OE_Order_PUB.g_hdr.transactional_curr_code);
12866: x_header_id := l_line_tbl(line_tbl_index).header_id;
12867: End If;
12868:
12869: --Populate global structure since attribute mapping only read global structure
12866: x_header_id := l_line_tbl(line_tbl_index).header_id;
12867: End If;
12868:
12869: --Populate global structure since attribute mapping only read global structure
12870: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
12871: Begin
12872: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12873: --5598523
12874: IF l_line_tbl(line_tbl_index).line_id=p_line_id THEN
12894: p_pricing_type => 'L',
12895: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
12896: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl);
12897: END IF;
12898: OE_Order_PUB.G_LINE := NULL;
12899: Exception
12900: When Others then
12901: oe_debug_pub.add(' QP ATTR MAPPING ERRORS 1');
12902: Raise QP_ATTR_MAPPING_ERRORS;
13004: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
13005: QP_Attr_Mapping_PUB.Build_Contexts(
13006: p_request_type_code => 'ONT',
13007: p_pricing_type_code => 'H',
13008: p_line_index=> l_line_index + 1 --oe_order_pub.g_hdr.header_id
13009: );
13010: ELSE
13011: QP_Attr_Mapping_PUB.Build_Contexts(
13012: p_request_type_code => 'ONT',
13026:
13027: -- bucket man
13028: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
13029: oe_order_price_pvt.copy_Header_to_request(
13030: p_header_rec => OE_Order_PUB.g_hdr
13031: ,px_req_line_tbl => l_req_line_tbl
13032: ,p_Request_Type_Code => 'ONT'
13033: ,p_calculate_price_flag =>'Y'
13034: ,px_line_index => l_line_index
13034: ,px_line_index => l_line_index
13035: );
13036: ELSE
13037: copy_Header_to_request(
13038: p_header_rec => OE_Order_PUB.g_hdr
13039: ,px_req_line_tbl => l_req_line_tbl
13040: ,p_Request_Type_Code => 'ONT'
13041: ,p_calculate_price_flag =>'Y'
13042: );