[Home] [Help]
88:
89: --As per discussion with AMY and RAVI
90: --If error occurs from pricing engine we need to look at pricing temp table
91: --copy the temp table unit selling price to the line
92: Procedure Reset_Fields(p_line_rec in Oe_Order_Pub.Line_Rec_Type)As
93:
94: Cursor get_price(p_line_id in Number) is
95: Select Unit_Price,
96: Adjusted_Unit_Price,
317: PROCEDURE Header_Adjs
318: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
319: , p_validation_level IN NUMBER
320: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
321: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
322: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
323: )
324: IS
325: l_return_status VARCHAR2(1);
318: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
319: , p_validation_level IN NUMBER
320: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
321: , p_x_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
322: , p_x_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
323: )
324: IS
325: l_return_status VARCHAR2(1);
326: l_control_rec OE_GLOBALS.Control_Rec_Type;
323: )
324: IS
325: l_return_status VARCHAR2(1);
326: l_control_rec OE_GLOBALS.Control_Rec_Type;
327: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
328: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
329: -- local variables to store OUT parameters from security check procedures
330: l_sec_result NUMBER;
331: l_on_operation_action NUMBER;
324: IS
325: l_return_status VARCHAR2(1);
326: l_control_rec OE_GLOBALS.Control_Rec_Type;
327: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
328: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
329: -- local variables to store OUT parameters from security check procedures
330: l_sec_result NUMBER;
331: l_on_operation_action NUMBER;
332: I pls_integer; -- Used as index for while loop
374:
375: IF p_x_old_Header_Adj_tbl.EXISTS(I) THEN
376: l_old_Header_Adj_rec := p_x_old_Header_Adj_tbl(I);
377: ELSE
378: l_old_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
379: END IF;
380:
381: if l_old_header_adj_rec.price_adjustment_id = FND_API.G_MISS_NUM then
382:
914: PROCEDURE Line_Adjs
915: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
916: , p_validation_level IN NUMBER
917: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
918: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
919: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
920: )
921: IS
922: l_return_status VARCHAR2(1);
915: ( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
916: , p_validation_level IN NUMBER
917: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
918: , p_x_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
919: , p_x_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
920: )
921: IS
922: l_return_status VARCHAR2(1);
923: l_control_rec OE_GLOBALS.Control_Rec_Type;
920: )
921: IS
922: l_return_status VARCHAR2(1);
923: l_control_rec OE_GLOBALS.Control_Rec_Type;
924: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
926: -- local variables to store OUT parameters from security check procedures
927: l_sec_result NUMBER;
928: l_on_operation_action NUMBER;
921: IS
922: l_return_status VARCHAR2(1);
923: l_control_rec OE_GLOBALS.Control_Rec_Type;
924: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
925: l_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
926: -- local variables to store OUT parameters from security check procedures
927: l_sec_result NUMBER;
928: l_on_operation_action NUMBER;
929: I pls_integer; -- Used as table index for the loop.
940: l_change_sequence VARCHAR2(50);
941: l_source_document_type_id NUMBER;
942: l_source_document_id NUMBER;
943: l_source_document_line_id NUMBER;
944: l_line_temp_rec OE_Order_PUB.Line_Rec_Type;
945:
946: BEGIN
947:
948: IF l_debug_level > 0 THEN
978:
979: IF p_x_old_Line_Adj_tbl.EXISTS(I) THEN
980: l_old_Line_Adj_rec := p_x_old_Line_Adj_tbl(I);
981: ELSE
982: l_old_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
983: END IF;
984:
985: if l_old_line_Adj_rec.price_adjustment_id = FND_API.G_MISS_NUM then
986:
1641: PROCEDURE HEader_Price_Atts
1642: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
1643: , p_validation_level IN NUMBER
1644: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1645: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1646: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1647: )
1648: is
1649: l_return_status VARCHAR2(1);
1642: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
1643: , p_validation_level IN NUMBER
1644: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
1645: , p_x_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1646: , p_x_old_HEader_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.HEader_Price_Att_Tbl_Type
1647: )
1648: is
1649: l_return_status VARCHAR2(1);
1650: l_control_rec OE_GLOBALS.Control_Rec_Type;
1647: )
1648: is
1649: l_return_status VARCHAR2(1);
1650: l_control_rec OE_GLOBALS.Control_Rec_Type;
1651: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1652: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1653: -- local variables to store OUT parameters from security check procedures
1654: l_sec_result NUMBER;
1655: l_on_operation_action NUMBER;
1648: is
1649: l_return_status VARCHAR2(1);
1650: l_control_rec OE_GLOBALS.Control_Rec_Type;
1651: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1652: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1653: -- local variables to store OUT parameters from security check procedures
1654: l_sec_result NUMBER;
1655: l_on_operation_action NUMBER;
1656: I pls_integer; -- Used as index for while loop
1696:
1697: IF p_x_old_Header_Price_Att_tbl.EXISTS(I) THEN
1698: l_old_Header_Price_Att_rec := p_x_old_Header_Price_Att_tbl(I);
1699: ELSE
1700: l_old_Header_Price_Att_rec := OE_Order_PUB.G_MISS_HEADER_Price_Att_REC;
1701: END IF;
1702:
1703: if l_old_header_Price_Att_rec.Order_price_attrib_id = FND_API.G_MISS_NUM then
1704: IF l_header_Price_Att_rec.header_Id IS NOT NULL AND
2187: PROCEDURE Header_Adj_Atts
2188: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2189: , p_validation_level IN NUMBER
2190: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2191: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2192: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2193: )
2194: is
2195: l_return_status VARCHAR2(1);
2188: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2189: , p_validation_level IN NUMBER
2190: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2191: , p_x_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2192: , p_x_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
2193: )
2194: is
2195: l_return_status VARCHAR2(1);
2196: l_control_rec OE_GLOBALS.Control_Rec_Type;
2193: )
2194: is
2195: l_return_status VARCHAR2(1);
2196: l_control_rec OE_GLOBALS.Control_Rec_Type;
2197: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2198: l_old_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2199: -- local variables to store OUT parameters from security check procedures
2200: I pls_integer; -- Used as index for while loop
2201: BEGIN
2194: is
2195: l_return_status VARCHAR2(1);
2196: l_control_rec OE_GLOBALS.Control_Rec_Type;
2197: l_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2198: l_old_Header_Adj_Att_rec OE_Order_PUB.Header_Adj_Att_Rec_Type;
2199: -- local variables to store OUT parameters from security check procedures
2200: I pls_integer; -- Used as index for while loop
2201: BEGIN
2202:
2225:
2226: IF p_x_old_Header_Adj_Att_tbl.EXISTS(I) THEN
2227: l_old_Header_Adj_Att_rec := p_x_old_Header_Adj_Att_tbl(I);
2228: ELSE
2229: l_old_Header_Adj_Att_rec := OE_Order_PUB.G_MISS_Header_Adj_Att_REC;
2230: END IF;
2231:
2232: if l_old_Header_Adj_Att_rec.Price_Adj_attrib_id = FND_API.G_MISS_NUM then
2233:
2466: PROCEDURE Header_Adj_Assocs
2467: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2468: , p_validation_level IN NUMBER
2469: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2470: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2471: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2472: )
2473: is
2474: l_return_status VARCHAR2(1);
2467: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2468: , p_validation_level IN NUMBER
2469: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2470: , p_x_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2471: , p_x_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
2472: )
2473: is
2474: l_return_status VARCHAR2(1);
2475: l_control_rec OE_GLOBALS.Control_Rec_Type;
2472: )
2473: is
2474: l_return_status VARCHAR2(1);
2475: l_control_rec OE_GLOBALS.Control_Rec_Type;
2476: l_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2477: l_old_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2478: -- local variables to store OUT parameters from security check procedures
2479: I pls_integer; -- Used as index for while loop
2480: BEGIN
2473: is
2474: l_return_status VARCHAR2(1);
2475: l_control_rec OE_GLOBALS.Control_Rec_Type;
2476: l_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2477: l_old_Header_Adj_Assoc_rec OE_Order_PUB.Header_Adj_Assoc_Rec_Type;
2478: -- local variables to store OUT parameters from security check procedures
2479: I pls_integer; -- Used as index for while loop
2480: BEGIN
2481:
2504:
2505: IF p_x_old_Header_Adj_Assoc_tbl.EXISTS(I) THEN
2506: l_old_Header_Adj_Assoc_rec := p_x_old_Header_Adj_Assoc_tbl(I);
2507: ELSE
2508: l_old_Header_Adj_Assoc_rec := OE_Order_PUB.G_MISS_Header_Adj_Assoc_REC;
2509: END IF;
2510:
2511: if l_old_Header_Adj_Assoc_rec.Price_Adj_assoc_id = FND_API.G_MISS_NUM then
2512:
2744: PROCEDURE Line_Price_Atts
2745: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2746: , p_validation_level IN NUMBER
2747: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2748: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2749: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2750: )
2751: is
2752: l_return_status VARCHAR2(1);
2745: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
2746: , p_validation_level IN NUMBER
2747: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
2748: , p_x_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2749: , p_x_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
2750: )
2751: is
2752: l_return_status VARCHAR2(1);
2753: l_control_rec OE_GLOBALS.Control_Rec_Type;
2750: )
2751: is
2752: l_return_status VARCHAR2(1);
2753: l_control_rec OE_GLOBALS.Control_Rec_Type;
2754: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2755: l_old_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2756: -- local variables to store OUT parameters from security check procedures
2757: l_sec_result NUMBER;
2758: l_on_operation_action NUMBER;
2751: is
2752: l_return_status VARCHAR2(1);
2753: l_control_rec OE_GLOBALS.Control_Rec_Type;
2754: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2755: l_old_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2756: -- local variables to store OUT parameters from security check procedures
2757: l_sec_result NUMBER;
2758: l_on_operation_action NUMBER;
2759: I pls_integer; -- Used as index for while loop
2799:
2800: IF p_x_old_Line_price_att_tbl.EXISTS(I) THEN
2801: l_old_Line_price_att_rec := p_x_old_Line_price_att_tbl(I);
2802: ELSE
2803: l_old_Line_price_att_rec := OE_Order_PUB.G_MISS_Line_Price_Att_REC;
2804: END IF;
2805:
2806: if l_old_Line_price_att_rec.Order_price_attrib_id = FND_API.G_MISS_NUM then
2807:
3300: end Line_Price_Atts;
3301:
3302:
3303: PROCEDURE Insert_Adj_Atts
3304: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
3305: )
3306: is
3307: I PLS_INTEGER;
3308: l_line_dummy_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3304: (p_Line_Adj_attribs_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
3305: )
3306: is
3307: I PLS_INTEGER;
3308: l_line_dummy_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3309: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3310: l_control_rec OE_GLOBALS.Control_Rec_Type;
3311: Begin
3312: l_line_adj_att_tbl := p_Line_Adj_attribs_tbl;
3305: )
3306: is
3307: I PLS_INTEGER;
3308: l_line_dummy_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3309: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3310: l_control_rec OE_GLOBALS.Control_Rec_Type;
3311: Begin
3312: l_line_adj_att_tbl := p_Line_Adj_attribs_tbl;
3313:
3320:
3321: I := p_Line_Adj_attribs_tbl.first;
3322:
3323: While I Is Not Null Loop
3324: --l_line_adj_assoc_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
3325: l_line_adj_att_tbl(i).Operation := OE_Globals.G_OPR_CREATE;
3326:
3327: Select OE_PRICE_ADJ_ATTRIBS_S.nextval
3328: Into l_line_adj_att_tbl(i).price_adj_attrib_id
3343: PROCEDURE Line_Adj_Atts
3344: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3345: , p_validation_level IN NUMBER
3346: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3347: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3348: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3349: )
3350: is
3351: l_return_status VARCHAR2(1);
3344: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3345: , p_validation_level IN NUMBER
3346: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3347: , p_x_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3348: , p_x_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
3349: )
3350: is
3351: l_return_status VARCHAR2(1);
3352: l_control_rec OE_GLOBALS.Control_Rec_Type;
3349: )
3350: is
3351: l_return_status VARCHAR2(1);
3352: l_control_rec OE_GLOBALS.Control_Rec_Type;
3353: l_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3354: l_old_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3355: -- local variables to store OUT parameters from security check procedures
3356: I pls_integer; -- Used as index for while loop
3357: BEGIN
3350: is
3351: l_return_status VARCHAR2(1);
3352: l_control_rec OE_GLOBALS.Control_Rec_Type;
3353: l_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3354: l_old_Line_Adj_att_rec OE_Order_PUB.Line_Adj_Att_Rec_Type;
3355: -- local variables to store OUT parameters from security check procedures
3356: I pls_integer; -- Used as index for while loop
3357: BEGIN
3358:
3380:
3381: IF p_x_old_Line_Adj_Att_tbl.EXISTS(I) THEN
3382: l_old_Line_Adj_Att_rec := p_x_old_Line_Adj_Att_tbl(I);
3383: ELSE
3384: l_old_Line_Adj_Att_rec := OE_Order_PUB.G_MISS_Line_Adj_Att_REC;
3385: END IF;
3386:
3387: if l_old_Line_Adj_Att_rec.Price_Adj_attrib_id = FND_API.G_MISS_NUM then
3388:
3639: adj_debug('Exiting oe_order_Adj_pvt.Line_Adj_Atts', 1);
3640: end Line_Adj_Atts;
3641:
3642: PROCEDURE Insert_Adj_Assocs
3643: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3644: )
3645: is
3646: I PLS_INTEGER;
3647: l_line_dummy_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3643: (p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3644: )
3645: is
3646: I PLS_INTEGER;
3647: l_line_dummy_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3648: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3649: l_control_rec OE_GLOBALS.Control_Rec_Type;
3650: Begin
3651: l_line_adj_assoc_tbl := p_Line_Adj_Assoc_tbl;
3644: )
3645: is
3646: I PLS_INTEGER;
3647: l_line_dummy_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3648: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3649: l_control_rec OE_GLOBALS.Control_Rec_Type;
3650: Begin
3651: l_line_adj_assoc_tbl := p_Line_Adj_Assoc_tbl;
3652: l_control_rec.private_call := TRUE;
3658:
3659: I := p_line_adj_assoc_tbl.first;
3660:
3661: While I Is Not Null Loop
3662: --l_line_adj_assoc_tbl(i) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
3663: l_Line_Adj_Assoc_tbl(i).Operation := OE_Globals.G_OPR_CREATE;
3664:
3665: Select oe_price_adj_assocs_s.nextval
3666: Into l_line_adj_assoc_tbl(i).price_adj_assoc_id
3680: PROCEDURE Line_Adj_Assocs
3681: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3682: , p_validation_level IN NUMBER
3683: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3684: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3685: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3686: )
3687: is
3688: l_return_status VARCHAR2(1);
3681: ( p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE
3682: , p_validation_level IN NUMBER
3683: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
3684: , p_x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3685: , p_x_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
3686: )
3687: is
3688: l_return_status VARCHAR2(1);
3689: l_control_rec OE_GLOBALS.Control_Rec_Type;
3686: )
3687: is
3688: l_return_status VARCHAR2(1);
3689: l_control_rec OE_GLOBALS.Control_Rec_Type;
3690: l_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3691: l_old_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3692: -- local variables to store OUT parameters from security check procedures
3693: I pls_integer; -- Used as index for while loop
3694: BEGIN
3687: is
3688: l_return_status VARCHAR2(1);
3689: l_control_rec OE_GLOBALS.Control_Rec_Type;
3690: l_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3691: l_old_Line_Adj_Assoc_rec OE_Order_PUB.Line_Adj_Assoc_Rec_Type;
3692: -- local variables to store OUT parameters from security check procedures
3693: I pls_integer; -- Used as index for while loop
3694: BEGIN
3695:
3720: adj_debug('price adj '||l_Line_Adj_Assoc_rec.PRICE_ADJUSTMENT_ID,2);
3721: IF p_x_old_Line_Adj_Assoc_tbl.EXISTS(I) THEN
3722: l_old_Line_Adj_Assoc_rec := p_x_old_Line_Adj_Assoc_tbl(I);
3723: ELSE
3724: l_old_Line_Adj_Assoc_rec := OE_Order_PUB.G_MISS_Line_Adj_Assoc_REC;
3725: END IF;
3726:
3727: if l_old_Line_Adj_Assoc_rec.Price_Adj_assoc_id = FND_API.G_MISS_NUM then
3728:
3970: begin
3971:
3972: G_STMT_NO := 'Enforce_Price_lists_Flag#10';
3973: select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
3974: from oe_line_types_v where line_type_id=OE_Order_PUB.G_Line.Line_Type_id;
3975: exception when no_data_found then
3976: l_enforce_price_flag := 'N';
3977: end ;
3978:
3979: If l_enforce_price_flag='N' then
3980: begin
3981: G_STMT_NO := 'Enforce_Price_lists_Flag#20';
3982: select nvl(enforce_line_prices_flag,'N') into l_enforce_price_flag
3983: from oe_Order_types_v where Order_type_id=OE_Order_PUB.g_hdr.Order_Type_Id;
3984: exception when no_data_found then
3985: l_enforce_price_flag := 'N';
3986: end ;
3987: end if;
4054: Return Null;
4055: end Get_Rounding_factor;
4056:
4057: procedure copy_Header_to_request(
4058: p_header_rec OE_Order_PUB.Header_Rec_Type
4059: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
4060: --,p_pricing_event varchar2
4061: ,p_Request_Type_Code varchar2
4062: ,p_calculate_price_flag varchar2
4088:
4089: If p_Header_rec.transactional_curr_code is Not Null Then
4090: G_ORDER_CURRENCY := p_Header_rec.transactional_curr_code;
4091: Else
4092: G_ORDER_CURRENCY := OE_Order_PUB.g_hdr.transactional_curr_code;
4093: End If;
4094:
4095: --Rounding factor now will be handled by pricing engine.
4096:
4099:
4100: end copy_Header_to_request;
4101:
4102: procedure copy_Line_to_request(
4103: p_Line_rec OE_Order_PUB.Line_Rec_Type
4104: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
4105: ,p_pricing_event varchar2
4106: ,p_Request_Type_Code varchar2
4107: ,p_honor_price_flag VARCHAR2 Default 'Y'
4189:
4190: px_req_line_tbl(l_line_index).PRICED_UOM_CODE := p_Line_rec.pricing_quantity_uom;
4191:
4192: px_req_line_tbl(l_line_index).CURRENCY_CODE :=
4193: OE_Order_PUB.g_hdr.transactional_curr_code;
4194: -- uom begin
4195: If p_Line_rec.unit_list_price_per_pqty <> FND_API.G_MISS_NUM Then
4196: px_req_line_tbl(l_line_index).UNIT_PRICE := p_Line_rec.unit_list_price_per_pqty;
4197:
4304:
4305: End If;
4306:
4307: px_req_line_tbl(l_line_index).Active_date_first_type := 'ORD';
4308: px_req_line_tbl(l_line_index).Active_date_first := OE_Order_Pub.G_HDR.Ordered_date;
4309:
4310: If p_Line_rec.schedule_ship_date is not null then
4311: px_req_line_tbl(l_line_index).Active_date_Second_type := 'SHIP';
4312: px_req_line_tbl(l_line_index).Active_date_Second := p_Line_rec.schedule_ship_date;
4321:
4322: procedure copy_adjs_to_request(
4323: p_line_index pls_integer
4324: ,p_adj_index pls_integer
4325: ,p_Line_adj_rec OE_Order_PUB.Line_Adj_Rec_Type
4326: ,px_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_tbl_Type
4327: )
4328: is
4329: l_RLD_Index pls_integer := p_adj_index;
4406:
4407: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
4408: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
4409:
4410: If OE_Order_PUB.G_Line.agreement_id is not null and
4411: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
4412: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4413: -- BLANKETS: Start Code Merge
4414: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4407: If p_qualifier_contexts_Tbl(i).context_name ='MODLIST' and
4408: p_qualifier_contexts_Tbl(i).Attribute_Name ='QUALIFIER_ATTRIBUTE4' then
4409:
4410: If OE_Order_PUB.G_Line.agreement_id is not null and
4411: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
4412: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4413: -- BLANKETS: Start Code Merge
4414: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4415: OE_Order_PUB.G_Line.blanket_number is not null and
4411: OE_Order_PUB.G_Line.agreement_id <> fnd_api.g_miss_num then
4412: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4413: -- BLANKETS: Start Code Merge
4414: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4415: OE_Order_PUB.G_Line.blanket_number is not null and
4416: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4417: OE_Order_PUB.G_Line.blanket_line_number is not null and
4418: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4419: Then
4412: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4413: -- BLANKETS: Start Code Merge
4414: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4415: OE_Order_PUB.G_Line.blanket_number is not null and
4416: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4417: OE_Order_PUB.G_Line.blanket_line_number is not null and
4418: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4419: Then
4420:
4413: -- BLANKETS: Start Code Merge
4414: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4415: OE_Order_PUB.G_Line.blanket_number is not null and
4416: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4417: OE_Order_PUB.G_Line.blanket_line_number is not null and
4418: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4419: Then
4420:
4421: -- Set validated_flag to 'Y' if price list is AGR
4414: Elsif OE_Code_Control.Code_Release_Level >= '110509' and
4415: OE_Order_PUB.G_Line.blanket_number is not null and
4416: OE_Order_PUB.G_Line.blanket_number <> fnd_api.g_miss_num and
4417: OE_Order_PUB.G_Line.blanket_line_number is not null and
4418: OE_Order_PUB.G_Line.blanket_line_number <> fnd_api.g_miss_num
4419: Then
4420:
4421: -- Set validated_flag to 'Y' if price list is AGR
4422: -- type or enforce price list is checked on blanket.
4420:
4421: -- Set validated_flag to 'Y' if price list is AGR
4422: -- type or enforce price list is checked on blanket.
4423: If Get_List_Type
4424: (OE_Order_PUB.G_Line.price_list_id) = 'AGR'
4425: OR Get_Enforce_Price_List
4426: (OE_Order_PUB.G_Line.blanket_number
4427: ,OE_Order_PUB.G_Line.blanket_line_number)='Y'
4428: Then
4422: -- type or enforce price list is checked on blanket.
4423: If Get_List_Type
4424: (OE_Order_PUB.G_Line.price_list_id) = 'AGR'
4425: OR Get_Enforce_Price_List
4426: (OE_Order_PUB.G_Line.blanket_number
4427: ,OE_Order_PUB.G_Line.blanket_line_number)='Y'
4428: Then
4429:
4430: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4423: If Get_List_Type
4424: (OE_Order_PUB.G_Line.price_list_id) = 'AGR'
4425: OR Get_Enforce_Price_List
4426: (OE_Order_PUB.G_Line.blanket_number
4427: ,OE_Order_PUB.G_Line.blanket_line_number)='Y'
4428: Then
4429:
4430: px_Req_Qual_Tbl(l_qual_index).Validated_Flag := 'Y';
4431:
5381:
5382: end Append_asked_for;
5383:
5384: procedure Get_the_parent_Line(p_Reference_line_Id Number,
5385: px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type,
5386: px_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.Related_Lines_Tbl_Type,
5387: p_line_Tbl_index Number)
5388: is
5389: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
5385: px_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type,
5386: px_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.Related_Lines_Tbl_Type,
5387: p_line_Tbl_index Number)
5388: is
5389: l_Line_Rec OE_Order_Pub.Line_Rec_Type;
5390: line_Tbl_Index pls_integer;
5391: l_related_lines_Index pls_integer;
5392: Begin
5393: G_STMT_NO := 'Get_the_parent_Line#10';
5428:
5429: End Get_the_parent_Line;
5430:
5431: procedure set_item_for_iue(
5432: px_line_rec in out nocopy OE_Order_PUB.line_rec_type
5433: ,p_req_line_detail_rec QP_PREQ_GRP.line_detail_rec_type
5434: )
5435: is
5436: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5476:
5477: adj_debug('Exiting oe_order_Adj_pvt.set_item_for_iue');
5478: end set_item_for_iue;
5479:
5480: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
5481: is
5482: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5483: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5484: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5529: p_use_current_header in Boolean Default FALSE
5530: --if use_current_header set to true, it will not set the header info
5531: --and it will use current header information set by the caller.
5532: --It is useful when getting a quote where header_id is not available.
5533: --in this case the caller will need to set Oe_Order_Pub.G_Hdr values
5534: ,p_write_to_db Boolean Default TRUE
5535: ,x_any_frozen_line out nocopy Boolean
5536:
5537: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5533: --in this case the caller will need to set Oe_Order_Pub.G_Hdr values
5534: ,p_write_to_db Boolean Default TRUE
5535: ,x_any_frozen_line out nocopy Boolean
5536:
5537: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5538:
5539: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5540: ,p_honor_price_flag VARCHAR2 Default 'Y'
5541: ,p_multiple_events in VARCHAR2 Default 'N'
5535: ,x_any_frozen_line out nocopy Boolean
5536:
5537: ,x_Header_Rec out nocopy oe_Order_Pub.Header_REc_Type
5538:
5539: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
5540: ,p_honor_price_flag VARCHAR2 Default 'Y'
5541: ,p_multiple_events in VARCHAR2 Default 'N'
5542: ,p_action_code in VARCHAR2 Default 'NONE'
5543: )
5543: )
5544: is
5545: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5546: l_return_status_Text varchar2(240) ;
5547: l_header_rec OE_Order_PUB.Header_Rec_Type;
5548: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5549: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5550: --1472635
5551: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5544: is
5545: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5546: l_return_status_Text varchar2(240) ;
5547: l_header_rec OE_Order_PUB.Header_Rec_Type;
5548: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5549: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5550: --1472635
5551: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5552: i2 PLS_INTEGER;
5545: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
5546: l_return_status_Text varchar2(240) ;
5547: l_header_rec OE_Order_PUB.Header_Rec_Type;
5548: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5549: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5550: --1472635
5551: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5552: i2 PLS_INTEGER;
5553: l_all_lines_from_db Boolean :=False;
5547: l_header_rec OE_Order_PUB.Header_Rec_Type;
5548: l_Line_Tbl OE_Order_PUB.Line_Tbl_Type;
5549: l_line_tbl_tmp OE_Order_PUB.Line_Tbl_Type;
5550: --1472635
5551: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5552: i2 PLS_INTEGER;
5553: l_all_lines_from_db Boolean :=False;
5554:
5555: l_Line_Rec OE_Order_PUB.Line_Rec_Type;
5551: l_temp_line_tbl OE_Order_PUB.Line_Tbl_type;
5552: i2 PLS_INTEGER;
5553: l_all_lines_from_db Boolean :=False;
5554:
5555: l_Line_Rec OE_Order_PUB.Line_Rec_Type;
5556: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
5557: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
5558: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
5559: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
5642:
5643: Begin
5644:
5645: oe_Header_util.query_row (p_header_id => p_Header_id
5646: ,x_header_rec=>OE_Order_PUB.g_hdr );
5647: Exception when no_data_found then
5648: x_return_status := 'NOOP';
5649: adj_debug(G_STMT_NO||'Invalid header_id '||p_Header_id,1);
5650: Return;
5657: (p_control_rec.pricing_event,l_order_status_rec);
5658:
5659: oe_debug_pub.add('Pricing Engine return pass all_lines value:'||l_order_status_rec.ALL_LINES_FLAG);
5660: oe_debug_pub.add('Pricing Engine return pass changed line value:'||l_order_status_rec.Changed_Lines_Flag);
5661: oe_debug_pub.add('Cache header operation:'||oe_order_pub.g_hdr.operation);
5662:
5663:
5664: If G_INT_CHANGED_LINE_ON = 'Y' Then
5665: 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
5756: If p_use_current_header = FALSE Then
5757: Begin
5758: If l_line_tbl.first is not null Then
5759: oe_Header_util.query_row
5760: (p_header_id=> l_line_Tbl(l_line_tbl.first).Header_id, x_header_rec => OE_Order_PUB.g_hdr );
5761: Else
5762: oe_debug_pub.add(' Error: No line records in l_line_tbl');
5763: End If;
5764:
5818: --If oe_line_util.Get_Return_Item_Type_Code(l_Line_Tbl(line_Tbl_Index)) <> 'CONFIG' Then
5819:
5820:
5821: -- Populate that Global Structure
5822: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
5823: -- uom begin
5824: If OE_Order_PUB.G_LINE.unit_list_price_per_pqty = fnd_api.g_miss_num then
5825: OE_Order_PUB.G_LINE.unit_list_price_per_pqty:= Null;
5826: End If;
5820:
5821: -- Populate that Global Structure
5822: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
5823: -- uom begin
5824: If OE_Order_PUB.G_LINE.unit_list_price_per_pqty = fnd_api.g_miss_num then
5825: OE_Order_PUB.G_LINE.unit_list_price_per_pqty:= Null;
5826: End If;
5827: -- uom end
5828:
5821: -- Populate that Global Structure
5822: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
5823: -- uom begin
5824: If OE_Order_PUB.G_LINE.unit_list_price_per_pqty = fnd_api.g_miss_num then
5825: OE_Order_PUB.G_LINE.unit_list_price_per_pqty:= Null;
5826: End If;
5827: -- uom end
5828:
5829: -- Check if the line is service item
5828:
5829: -- Check if the line is service item
5830:
5831: G_STMT_NO := 'calculate_adjustments#120';
5832: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
5833: FND_API.G_MISS_NUM and
5834: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
5835: Then
5836:
5830:
5831: G_STMT_NO := 'calculate_adjustments#120';
5832: If (OE_Order_PUB.G_LINE.Service_Reference_Line_Id <>
5833: FND_API.G_MISS_NUM and
5834: OE_Order_PUB.G_LINE.Service_Reference_Line_Id is not null)
5835: Then
5836:
5837: /* Added the following if condition for fixing the bug 1828553 */
5838: /* If the service reference context is ORDER, then the service_reference*/
5879: End If;
5880:
5881: -- Get Line Attributes
5882: G_STMT_NO := 'calculate_adjustments#130';
5883: Get_Item_For_Iue(px_line_rec => OE_Order_Pub.G_Line);
5884:
5885: If l_bypass_pricing = 'Y' Then
5886:
5887: adj_debug('Bypassing the qualifier build',1);
6113: l_calculate_price_flag := 'Y';
6114: END IF;
6115:
6116: copy_Header_to_request(
6117: p_header_rec => OE_Order_PUB.g_hdr
6118: ,px_req_line_tbl => l_req_line_tbl
6119: ,p_Request_Type_Code => p_Request_Type_Code
6120: ,p_calculate_price_flag =>l_calculate_price_flag
6121: );
6197:
6198: --Q means ask pricing engine to determine rounding options.
6199: l_control_rec.rounding_flag := 'Q';
6200: l_control_rec.use_multi_currency:='Y';
6201: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6202: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6203: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6204: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6205:
6198: --Q means ask pricing engine to determine rounding options.
6199: l_control_rec.rounding_flag := 'Q';
6200: l_control_rec.use_multi_currency:='Y';
6201: l_control_rec.USER_CONVERSION_RATE:= OE_ORDER_PUB.G_HDR.CONVERSION_RATE;
6202: l_control_rec.USER_CONVERSION_TYPE:= OE_ORDER_PUB.G_HDR.CONVERSION_TYPE_CODE;
6203: l_set_of_books := Oe_Order_Cache.Load_Set_Of_Books;
6204: l_control_rec.FUNCTION_CURRENCY := l_set_of_books.currency_code;
6205:
6206: G_STMT_NO := 'QP_PRICE_REQUEST_GRP';
6271: x_Req_line_detail_attr_tbl := l_req_line_detail_attr_tbl;
6272: x_Req_related_lines_tbl := l_req_related_lines_tbl;
6273: */
6274:
6275: x_header_Rec := OE_Order_PUB.g_hdr;
6276: x_line_tbl := l_line_tbl;
6277:
6278: --reseting global structure after engine call
6279: OE_Order_PUB.G_LINE := NULL;
6275: x_header_Rec := OE_Order_PUB.g_hdr;
6276: x_line_tbl := l_line_tbl;
6277:
6278: --reseting global structure after engine call
6279: OE_Order_PUB.G_LINE := NULL;
6280: OE_Order_PUB.G_HDR := NULL;
6281: -- Process the lines...
6282:
6283: adj_debug('Exiting oe_order_Adj_pvt.calulate_adjustments', 1);
6276: x_line_tbl := l_line_tbl;
6277:
6278: --reseting global structure after engine call
6279: OE_Order_PUB.G_LINE := NULL;
6280: OE_Order_PUB.G_HDR := NULL;
6281: -- Process the lines...
6282:
6283: adj_debug('Exiting oe_order_Adj_pvt.calulate_adjustments', 1);
6284:
6339:
6340: end calculate_adjustments;
6341:
6342: Function Update_Adj_Line_rec(
6343: p_Line_Adj_Rec in out nocopy OE_Order_Pub.Line_Adj_Rec_Type
6344: ,p_req_line_detail_Rec qp_preq_grp.line_detail_rec_type
6345: )
6346: Return Boolean
6347: is
6639: Procedure Find_Duplicate_Adj_Lines(
6640: p_header_Id Number default null
6641: ,p_Line_id Number default null
6642: ,p_req_line_detail_Rec qp_preq_grp.line_detail_rec_type
6643: ,px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
6644: ,X_Adj_Index out nocopy Number
6645:
6646: ,p_mode in Varchar2
6647: ,px_line_key_tbl in out nocopy key_tbl_type
6730: If x_adj_index= -1 or x_adj_index > l_end_index Then
6731: -- This is a new Record
6732: --
6733: x_Adj_Index := px_line_adj_Tbl.count + 1;
6734: px_line_adj_tbl(x_adj_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
6735: px_line_adj_Tbl(x_Adj_Index).operation := OE_GLOBALS.G_OPR_CREATE;
6736: px_line_adj_Tbl(x_Adj_Index).Updated_Flag := 'N';
6737: px_line_adj_Tbl(x_Adj_Index).adjusted_amount_per_pqty := null;
6738: --
6803:
6804: Procedure Query_Adj_Assocs(
6805: p_price_adjustment_id Number,
6806: p_Adj_Index Number,
6807: p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.line_adj_Assoc_tbl_Type,
6808: p_delete_flag in Varchar2 default 'Y'
6809: ) Is
6810: L_Line_Adj_Assoc_Tbl OE_Order_Pub.line_adj_Assoc_tbl_Type;
6811: l_index pls_integer;
6806: p_Adj_Index Number,
6807: p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.line_adj_Assoc_tbl_Type,
6808: p_delete_flag in Varchar2 default 'Y'
6809: ) Is
6810: L_Line_Adj_Assoc_Tbl OE_Order_Pub.line_adj_Assoc_tbl_Type;
6811: l_index pls_integer;
6812: i pls_integer;
6813: Begin
6814: adj_debug('Entering oe_order_Adj_pvt.Query_Adj_Assocs',1);
6868: p_line_id Number default null,
6869: p_Pricing_Event Varchar2 default null,
6870: p_any_frozen_line Boolean default FALSE,
6871: p_price_flag VARCHAR2 default null,
6872: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
6873: px_line_key_tbl in out nocopy key_tbl_type,
6874: px_header_key_tbl in out nocopy key_tbl_type,
6875: p_mode in varchar2 default NULL,
6876: px_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
6872: px_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type,
6873: px_line_key_tbl in out nocopy key_tbl_type,
6874: px_header_key_tbl in out nocopy key_tbl_type,
6875: p_mode in varchar2 default NULL,
6876: px_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
6877: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_Tbl_type,
6878: x_updated_flag out nocopy varchar2,
6879:
6880: p_multiple_events in VARCHAR2 Default 'N'
6873: px_line_key_tbl in out nocopy key_tbl_type,
6874: px_header_key_tbl in out nocopy key_tbl_type,
6875: p_mode in varchar2 default NULL,
6876: px_line_rec in out nocopy Oe_Order_Pub.Line_Rec_Type,
6877: px_line_adj_assoc_tbl in out nocopy OE_Order_PUB.Line_Adj_Assoc_Tbl_type,
6878: x_updated_flag out nocopy varchar2,
6879:
6880: p_multiple_events in VARCHAR2 Default 'N'
6881: )
6880: p_multiple_events in VARCHAR2 Default 'N'
6881: )
6882: is
6883: l_Pricing_Phase_id Index_Tbl_Type;
6884: l_Line_Adj_Tbl OE_Order_Pub.Line_Adj_Tbl_Type;
6885: i pls_integer;
6886: J pls_integer;
6887: p_override_freeze_flag VARCHAR2(1) := NULL;
6888: l_visited_flag BOOLEAN Default FALSE;
7045:
7046: Procedure Query_Adj_Attribs(
7047: p_price_adjustment_id Number,
7048: p_Adj_Index Number,
7049: p_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type
7050: ) Is
7051: L_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;
7052: l_index pls_integer;
7053: Begin
7047: p_price_adjustment_id Number,
7048: p_Adj_Index Number,
7049: p_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.line_adj_att_tbl_Type
7050: ) Is
7051: L_Line_Adj_Att_Tbl OE_Order_Pub.line_adj_att_tbl_Type;
7052: l_index pls_integer;
7053: Begin
7054: adj_debug('Entering oe_order_Adj_pvt.Query_Adj_Attribs',1);
7055:
7101: QP_PREQ_GRP.Line_Detail_Qual_Rec_Type,
7102: p_Req_Line_Detail_Attr_Rec
7103: QP_PREQ_GRP.Line_Detail_Attr_Rec_Type,
7104: p_Adj_index Number,
7105: p_Line_Adj_Att_Tbl in out nocopy OE_Order_Pub.Line_Adj_Att_Tbl_Type,
7106: p_att_type Varchar2,
7107: p_price_adjustment_id Number
7108: )
7109: is
7149:
7150: G_STMT_NO := 'Find_Duplicate_Adj_Attribs#20';
7151: -- Create a New Record
7152: l_index := p_Line_Adj_Att_Tbl.count+1;
7153: p_Line_Adj_Att_Tbl(l_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_REC;
7154: p_Line_Adj_Att_Tbl(l_index).operation := OE_GLOBALS.G_OPR_CREATE;
7155: p_Line_Adj_Att_Tbl(l_index).Adj_index := P_Adj_Index;
7156: p_Line_Adj_Att_Tbl(l_index).price_adjustment_id := p_price_adjustment_id;
7157: p_Line_Adj_Att_Tbl(l_index).flex_title := 'QP_ATTR_DEFNS_QUALIFIER';
7205: End Loop;
7206:
7207: -- Create a New Record
7208: l_index := p_Line_Adj_Att_Tbl.count+1;
7209: p_line_adj_att_tbl(l_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_REC;
7210: p_Line_Adj_Att_Tbl(l_index).operation := OE_GLOBALS.G_OPR_CREATE;
7211: p_Line_Adj_Att_Tbl(l_index).Adj_index := P_Adj_Index;
7212: p_Line_Adj_Att_Tbl(l_index).price_adjustment_id := p_price_adjustment_id;
7213: p_Line_Adj_Att_Tbl(l_index).flex_title := 'QP_ATTR_DEFNS_PRICING';
7282: ,p_Parent_Adj_Index Number
7283: ,p_parent_line_index Number
7284: ,p_Rltd_line_details_prcd in out nocopy Index_Tbl_Type
7285: ,p_Rltd_lines_prcd in out nocopy Index_Tbl_Type
7286: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7287: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7288: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7289: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7290: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7283: ,p_parent_line_index Number
7284: ,p_Rltd_line_details_prcd in out nocopy Index_Tbl_Type
7285: ,p_Rltd_lines_prcd in out nocopy Index_Tbl_Type
7286: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7287: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7288: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7289: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7290: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7291: )
7284: ,p_Rltd_line_details_prcd in out nocopy Index_Tbl_Type
7285: ,p_Rltd_lines_prcd in out nocopy Index_Tbl_Type
7286: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7287: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7288: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7289: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7290: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7291: )
7292: is
7286: ,p_Line_Tbl in out nocopy OE_Order_Pub.Line_Tbl_Type
7287: ,p_Line_Adj_Tbl in out nocopy OE_Order_Pub.Line_Adj_Tbl_Type
7288: ,p_Line_Adj_Assoc_Tbl in out nocopy OE_Order_Pub.Line_Adj_Assoc_Tbl_Type
7289: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7290: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7291: )
7292: is
7293: l_line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
7294: l_line_Rec OE_Order_Pub.Line_Rec_Type;
7289: ,p_line_detail_replaced in out nocopy Index_Tbl_Type
7290: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7291: )
7292: is
7293: l_line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
7294: l_line_Rec OE_Order_Pub.Line_Rec_Type;
7295: l_Match_Exists Boolean := False;
7296: l_Req_Line_Index pls_integer;
7297: l_Adj_Index pls_integer;
7290: ,p_buy_line_rec in Oe_Order_Pub.Line_Rec_Type
7291: )
7292: is
7293: l_line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
7294: l_line_Rec OE_Order_Pub.Line_Rec_Type;
7295: l_Match_Exists Boolean := False;
7296: l_Req_Line_Index pls_integer;
7297: l_Adj_Index pls_integer;
7298: l_assoc_index pls_integer;
7523: -- Check If this Related Line Has Already been processed in an earlier loop
7524: If Not p_Rltd_lines_prcd.exists(l_Req_Line_Index) Then
7525:
7526: adj_debug('Creating a new line record for header '||P_Header_Id);
7527: l_line_rec:=OE_ORDER_PUB.G_MISS_LINE_REC;
7528: l_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
7529:
7530: l_line_rec.Header_id := P_Header_Id;
7531: --for bug 2412868 Begin
7675:
7676: If Not p_Rltd_line_details_prcd.exists(p_Line_detail_Index) Then
7677:
7678: l_Adj_Index := p_line_adj_Tbl.count+1;
7679: p_line_adj_tbl(l_adj_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
7680: p_line_adj_Tbl(l_Adj_Index).operation := OE_GLOBALS.G_OPR_CREATE;
7681:
7682: adj_debug('Creating an adjustment record for PRG '||l_Adj_Index);
7683: If Update_Adj_Line_rec(
7706:
7707: --Commented for Bug2211670
7708: -- l_assoc_index := p_Line_Adj_Assoc_tbl.count+1;
7709:
7710: p_line_adj_assoc_tbl(l_assoc_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
7711: p_Line_Adj_Assoc_tbl(l_assoc_index).line_index := Null;
7712: p_Line_Adj_Assoc_tbl(l_assoc_index).Adj_Index := P_Parent_Adj_Index;
7713: p_Line_Adj_Assoc_tbl(l_assoc_index).Rltd_Adj_Index :=
7714: p_Rltd_line_Details_prcd(p_Line_detail_Index);
7830:
7831: Function find_updated_adjustments(
7832: p_header_id number default null
7833: ,p_Line_id number default null
7834: ,p_Line_Adj_Tbl oe_order_pub.line_adj_tbl_type
7835: )
7836: Return boolean
7837: is
7838: i pls_integer;
8146:
8147: end CAlculate_Adjusted_Price;
8148:
8149: Procedure Calculate_Price (
8150: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8151: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8152: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8153: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8154: ,p_allow_Negative_Price Varchar2
8147: end CAlculate_Adjusted_Price;
8148:
8149: Procedure Calculate_Price (
8150: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8151: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8152: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8153: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8154: ,p_allow_Negative_Price Varchar2
8155: ,p_request_Type_Code Varchar2
8148:
8149: Procedure Calculate_Price (
8150: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8151: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8152: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8153: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8154: ,p_allow_Negative_Price Varchar2
8155: ,p_request_Type_Code Varchar2
8156: ,p_any_line_frozen Boolean default False
8149: Procedure Calculate_Price (
8150: p_Header_Rec Oe_Order_Pub.Header_Rec_Type
8151: ,p_Line_Tbl in out nocopy Oe_Order_Pub.Line_Tbl_Type
8152: ,p_Line_Adj_Tbl in out nocopy Oe_Order_Pub.Line_Adj_Tbl_Type
8153: ,p_line_adj_assoc_Tbl Oe_Order_Pub.line_adj_assoc_Tbl_Type
8154: ,p_allow_Negative_Price Varchar2
8155: ,p_request_Type_Code Varchar2
8156: ,p_any_line_frozen Boolean default False
8157: ,p_price_event Varchar2 default null --for bug 2273446
8191:
8192: --moac
8193: l_gsa_violation_action := oe_sys_parameters.value('ONT_GSA_VIOLATION_ACTION',p_header_rec.org_id);
8194:
8195: --OE_Order_Pub.G_HDR := p_header_rec;
8196:
8197: G_STMT_NO := 'Calculate_Price#05';
8198: i := p_Line_Adj_Tbl.First;
8199:
8829: Order no longer qualifies for PRG modifier. Either delete (or) update
8830: the free goods lines, depending on whether they are shipped or not
8831: */
8832: PROCEDURE change_prg_lines(p_price_adjustment_id IN NUMBER,
8833: p_line_tbl IN OUT NoCopy OE_Order_PUB.Line_Tbl_Type,
8834: p_line_adj_tbl IN OUT NoCopy OE_Order_PUB.Line_Adj_Tbl_Type,
8835: p_delete_prg_lines IN OUT NoCopy index_tbl_type) IS
8836:
8837: Cursor prg_lines is
8830: the free goods lines, depending on whether they are shipped or not
8831: */
8832: PROCEDURE change_prg_lines(p_price_adjustment_id IN NUMBER,
8833: p_line_tbl IN OUT NoCopy OE_Order_PUB.Line_Tbl_Type,
8834: p_line_adj_tbl IN OUT NoCopy OE_Order_PUB.Line_Adj_Tbl_Type,
8835: p_delete_prg_lines IN OUT NoCopy index_tbl_type) IS
8836:
8837: Cursor prg_lines is
8838: Select radj.line_id
8848:
8849: l_prg_line_id NUMBER;
8850: l_found_prg_line BOOLEAN;
8851: l_match_phase_id BOOLEAN := FALSE;
8852: l_line_rec OE_ORDER_PUB.line_rec_type;
8853: l_phase_id NUMBER;
8854: pricing_ph_id NUMBER;
8855: j PLS_INTEGER;
8856: l_return_status VARCHAR2(30);
8991: p_Req_Line_Detail_Attr_tbl QP_PREQ_GRP.line_detail_attr_tbl_type,
8992: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
8993: ,p_write_to_db Boolean
8994: ,p_any_frozen_line in Boolean
8995: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
8996: ,p_header_rec oe_Order_Pub.header_rec_type
8997: ,p_multiple_events in Varchar2 Default 'N'
8998: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
8999: )
8992: p_Req_related_lines_tbl QP_PREQ_GRP.related_lines_tbl_type
8993: ,p_write_to_db Boolean
8994: ,p_any_frozen_line in Boolean
8995: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
8996: ,p_header_rec oe_Order_Pub.header_rec_type
8997: ,p_multiple_events in Varchar2 Default 'N'
8998: ,p_honor_price_flag in Varchar2 Default 'Y' --bug 2503186
8999: )
9000: is
9001: l_Req_Line_Detail_qual_Rec QP_PREQ_GRP.line_detail_qual_rec_type;
9002: l_Req_Line_Detail_attr_Rec QP_PREQ_GRP.line_detail_attr_rec_type;
9003: l_req_line_rec qp_preq_grp.line_rec_type;
9004: l_control_rec Oe_Globals.Control_rec_type;
9005: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9006: --l_old_line_rec oe_order_pub.line_rec_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9002: l_Req_Line_Detail_attr_Rec QP_PREQ_GRP.line_detail_attr_rec_type;
9003: l_req_line_rec qp_preq_grp.line_rec_type;
9004: l_control_rec Oe_Globals.Control_rec_type;
9005: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9006: --l_old_line_rec oe_order_pub.line_rec_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9003: l_req_line_rec qp_preq_grp.line_rec_type;
9004: l_control_rec Oe_Globals.Control_rec_type;
9005: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9006: --l_old_line_rec oe_order_pub.line_rec_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9004: l_control_rec Oe_Globals.Control_rec_type;
9005: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9006: --l_old_line_rec oe_order_pub.line_rec_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9005: l_header_rec oe_Order_Pub.header_rec_type := p_header_rec;
9006: --l_old_line_rec oe_order_pub.line_rec_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9006: --l_old_line_rec oe_order_pub.line_rec_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9007: l_line_rec oe_order_pub.line_rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9008: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9009: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9010: l_line_tbl_Final OE_Order_PUB.Line_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9011: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9012: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9013: l_Line_Adj_Att_Rec OE_Order_PUB.Line_Adj_Att_Rec_type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9014: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9015: l_Line_Adj_Assoc_Rec OE_Order_PUB.Line_Adj_Assoc_Rec_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9016: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9017: --l_x_header_rec OE_Order_PUB.Header_Rec_Type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9018: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9019: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9020: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9021: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9029: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9022: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9029: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9030: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9023: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9029: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9030: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9031: l_x_msg_count number;
9024: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9029: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9030: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9031: l_x_msg_count number;
9032: l_x_msg_data Varchar2(2000);
9025: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9029: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9030: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9031: l_x_msg_count number;
9032: l_x_msg_data Varchar2(2000);
9033: l_x_result_out Varchar2(30);
9026: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
9027: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
9028: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
9029: --l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
9030: --l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
9031: l_x_msg_count number;
9032: l_x_msg_data Varchar2(2000);
9033: l_x_result_out Varchar2(30);
9034: l_line_details_prcd Index_Tbl_Type;
9063: l_invalid_line Varchar2(1):= 'N';
9064: --Manual begin
9065: l_preinsert_manual_adj VARCHAR2(1):= Nvl(Fnd_Profile.Value('ONT_PREINSERT_MANUAL_ADJ'),'N');
9066: --Manual end
9067: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
9068: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD'); -- PROMOTIONS SEP/01
9069:
9070: /* Promotional modifier issues - Bug 1503357 */
9071: l_delete_prg_lines index_tbl_type;
9090: l_source_document_line_id NUMBER;
9091:
9092: rec_cnt NUMBER := 0;
9093: --serla begin
9094: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
9095: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
9096: --serla end
9097: begin
9098:
9091:
9092: rec_cnt NUMBER := 0;
9093: --serla begin
9094: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
9095: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
9096: --serla end
9097: begin
9098:
9099: x_return_status := FND_API.G_RET_STS_SUCCESS;
9979: l_assoc_index := l_Line_Adj_Assoc_tbl.last+1;
9980: ELSE
9981: l_assoc_index := 1;
9982: END IF;
9983: l_Line_Adj_Assoc_tbl(l_assoc_index) := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_REC;
9984: l_Line_Adj_Assoc_tbl(l_assoc_index).Line_Index := Null;
9985: l_Line_Adj_Assoc_tbl(l_assoc_index).Adj_Index :=
9986: l_line_details_prcd(p_Req_Related_Lines_Tbl(i).Line_Detail_Index);
9987: l_Line_Adj_Assoc_tbl(l_assoc_index).Rltd_Adj_Index :=
10807:
10808: Function Bypass_Performance_Path(
10809: p_Header_id Number Default Null
10810: , p_Line_id Number Default Null
10811: , px_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
10812: ) Return Boolean
10813: IS
10814: l_source_document_type_id NUMBER;
10815: l_booked_flag Varchar2(1);
10812: ) Return Boolean
10813: IS
10814: l_source_document_type_id NUMBER;
10815: l_booked_flag Varchar2(1);
10816: l_header_rec OE_Order_PUB.Header_Rec_Type;
10817: l_header_id NUMBER;
10818: l_tmp_no number;
10819: Begin
10820:
10916: ,p_Header_id Number Default Null
10917: ,p_Request_Type_code Varchar2
10918: ,p_Control_Rec QP_PREQ_GRP.control_record_type
10919: ,p_write_to_db Boolean Default TRUE
10920: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
10921: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
10922: ,p_honor_price_flag VARCHAR2 Default 'Y'
10923: ,p_multiple_events in Varchar2 default 'N'
10924: ,p_action_code in Varchar2 default Null
10917: ,p_Request_Type_code Varchar2
10918: ,p_Control_Rec QP_PREQ_GRP.control_record_type
10919: ,p_write_to_db Boolean Default TRUE
10920: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
10921: ,x_line_Tbl in out nocopy oe_Order_Pub.Line_Tbl_Type
10922: ,p_honor_price_flag VARCHAR2 Default 'Y'
10923: ,p_multiple_events in Varchar2 default 'N'
10924: ,p_action_code in Varchar2 default Null
10925: )
10932: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
10933: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
10934: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
10935: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
10936: lx_Header_Rec oe_Order_Pub.Header_REc_Type;
10937: l_dummy varchar2(1);
10938: l_any_frozen_line Boolean;
10939: l_price_control_rec OE_ORDER_PRICE_pvt.control_rec_type;
10940: --For bug#2675212
11104:
11105: ,p_Header_id Number DEfault null
11106: ,p_Line_id Number DEfault null
11107: ,p_request_type_code varchar2
11108: ,p_request_rec OE_Order_PUB.request_rec_type default oe_order_pub.G_MISS_REQUEST_REC
11109:
11110: )
11111: is
11112: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11110: )
11111: is
11112: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11113: l_control_rec Oe_Globals.Control_rec_type;
11114: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11115: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11111: is
11112: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11113: l_control_rec Oe_Globals.Control_rec_type;
11114: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11115: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11112: l_Req_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
11113: l_control_rec Oe_Globals.Control_rec_type;
11114: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11115: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11113: l_control_rec Oe_Globals.Control_rec_type;
11114: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11115: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11114: l_Line_tbl OE_Order_PUB.Line_tbl_type;
11115: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11115: l_old_Line_tbl OE_Order_PUB.Line_tbl_type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11116: l_Line_tbl1 OE_Order_PUB.Line_tbl_type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11117: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11119: l_Old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11120: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11121: l_dummy_adj_assoc_tbl OE_Order_PUB.line_adj_assoc_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11122: l_header_rec OE_Order_PUB.Header_Rec_Type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11123: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11124: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11125: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11126: --l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11127: --l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11135: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11128: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11135: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11136: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11129: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11135: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11136: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11137: l_x_msg_count number;
11130: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11135: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11136: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11137: l_x_msg_count number;
11138: l_x_msg_data Varchar2(2000);
11131: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11135: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11136: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11137: l_x_msg_count number;
11138: l_x_msg_data Varchar2(2000);
11139: i pls_integer;
11132: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
11133: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
11134: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
11135: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
11136: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
11137: l_x_msg_count number;
11138: l_x_msg_data Varchar2(2000);
11139: i pls_integer;
11140: l_line_index pls_integer;
11144: l_set_price_flag_on_manual Varchar2(30) := nvl(fnd_profile.value('ONT_SET_PRICE_FLAG_ON_MANUAL'),'N');
11145: --Manual End
11146: l_dummy key_tbl_type;
11147: l_updated_flag varchar2(1);
11148: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
11149: l_price_control_rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE;
11150: x_line_tbl oe_order_pub.line_tbl_type;
11151: l_status_code Varchar2(5);
11152: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11146: l_dummy key_tbl_type;
11147: l_updated_flag varchar2(1);
11148: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
11149: l_price_control_rec OE_ORDER_PRICE_PVT.CONTROL_REC_TYPE;
11150: x_line_tbl oe_order_pub.line_tbl_type;
11151: l_status_code Varchar2(5);
11152: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11153: --serla begin
11154: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11150: x_line_tbl oe_order_pub.line_tbl_type;
11151: l_status_code Varchar2(5);
11152: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11153: --serla begin
11154: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11155: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
11156: --serla end
11157: begin
11158:
11151: l_status_code Varchar2(5);
11152: l_item_rec OE_ORDER_CACHE.item_rec_type; -- OPM 2547940
11153: --serla begin
11154: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
11155: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
11156: --serla end
11157: begin
11158:
11159: adj_debug('Entering oe_order_Adj_pvt.Price_adjustments',1);
11512: )
11513: is
11514: l_Price_Control_rec QP_PREQ_GRP.control_record_type;
11515: l_return_status varchar2(1);
11516: l_x_line_tbl oe_order_pub.line_tbl_type;
11517: l_line_id number;
11518: l_header_id number;
11519: l_delimiter1 number;
11520: l_delimiter2 number;
11878: )
11879: is
11880: l_Price_Control_rec QP_PREQ_GRP.control_record_type;
11881: l_return_status varchar2(1);
11882: l_x_line_tbl oe_order_pub.line_tbl_type;
11883: l_line_list varchar2(32000) := p_line_list;
11884: l_Header_list varchar2(32000) := p_Header_list;
11885: l_line_id number;
11886: l_header_id number;
12092:
12093:
12094: Procedure Set_Header(p_header IN quote_header_rec_type) As
12095: Begin
12096: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12097: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12093:
12094: Procedure Set_Header(p_header IN quote_header_rec_type) As
12095: Begin
12096: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12097: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12094: Procedure Set_Header(p_header IN quote_header_rec_type) As
12095: Begin
12096: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12097: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12095: Begin
12096: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12097: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12096: oe_order_pub.g_hdr.accounting_rule_id :=p_header.accounting_rule_id ;
12097: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12097: oe_order_pub.g_hdr.agreement_id :=p_header.agreement_id ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12098: oe_order_pub.g_hdr.booked_flag :=p_header.booked_flag ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12099: oe_order_pub.g_hdr.cancelled_flag :=p_header.cancelled_flag ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12100: oe_order_pub.g_hdr.context :=p_header.context ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12101: oe_order_pub.g_hdr.conversion_rate :=p_header.conversion_rate ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12102: oe_order_pub.g_hdr.conversion_rate_date :=p_header.conversion_rate_date ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12103: oe_order_pub.g_hdr.conversion_type_code :=p_header.conversion_type_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12104: oe_order_pub.g_hdr.customer_preference_set_code :=p_header.customer_preference_set_code;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12105: oe_order_pub.g_hdr.cust_po_number :=p_header.cust_po_number ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12106: oe_order_pub.g_hdr.deliver_to_contact_id :=p_header.deliver_to_contact_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12107: oe_order_pub.g_hdr.deliver_to_org_id :=p_header.deliver_to_org_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12108: oe_order_pub.g_hdr.demand_class_code :=p_header.demand_class_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12109: oe_order_pub.g_hdr.expiration_date :=p_header.expiration_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12110: oe_order_pub.g_hdr.fob_point_code :=p_header.fob_point_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12111: oe_order_pub.g_hdr.freight_carrier_code :=p_header.freight_carrier_code ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12112: oe_order_pub.g_hdr.freight_terms_code :=p_header.freight_terms_code ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12113: oe_order_pub.g_hdr.invoice_to_contact_id :=p_header.invoice_to_contact_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12114: oe_order_pub.g_hdr.invoice_to_org_id :=p_header.invoice_to_org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12115: oe_order_pub.g_hdr.invoicing_rule_id :=p_header.invoicing_rule_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12116: oe_order_pub.g_hdr.order_category_code :=p_header.order_category_code ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12117: oe_order_pub.g_hdr.ordered_date :=p_header.ordered_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12118: oe_order_pub.g_hdr.order_date_type_code :=p_header.order_date_type_code ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12119: oe_order_pub.g_hdr.order_number :=p_header.order_number ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12120: oe_order_pub.g_hdr.order_source_id :=p_header.order_source_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12121: oe_order_pub.g_hdr.order_type_id :=p_header.order_type_id ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12122: oe_order_pub.g_hdr.org_id :=p_header.org_id ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12123: oe_order_pub.g_hdr.payment_term_id :=p_header.payment_term_id ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12124: oe_order_pub.g_hdr.price_list_id :=p_header.price_list_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12125: oe_order_pub.g_hdr.pricing_date :=p_header.pricing_date ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12126: oe_order_pub.g_hdr.request_date :=p_header.request_date ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12127: oe_order_pub.g_hdr.request_id :=p_header.request_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12128: oe_order_pub.g_hdr.salesrep_id :=p_header.salesrep_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12129: oe_order_pub.g_hdr.sales_channel_code :=p_header.sales_channel_code ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12130: oe_order_pub.g_hdr.shipment_priority_code :=p_header.shipment_priority_code ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12131: oe_order_pub.g_hdr.shipping_method_code :=p_header.shipping_method_code ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12132: oe_order_pub.g_hdr.ship_from_org_id :=p_header.ship_from_org_id ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12133: oe_order_pub.g_hdr.ship_to_contact_id :=p_header.ship_to_contact_id ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12134: oe_order_pub.g_hdr.ship_to_org_id :=p_header.ship_to_org_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12135: oe_order_pub.g_hdr.sold_from_org_id :=p_header.sold_from_org_id ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12136: oe_order_pub.g_hdr.sold_to_contact_id :=p_header.sold_to_contact_id ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12137: oe_order_pub.g_hdr.sold_to_org_id :=p_header.sold_to_org_id ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12138: oe_order_pub.g_hdr.source_document_id :=p_header.source_document_id ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12139: oe_order_pub.g_hdr.source_document_type_id :=p_header.source_document_type_id ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12147: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12140: oe_order_pub.g_hdr.transactional_curr_code :=p_header.transactional_curr_code ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12147: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12148: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12141: oe_order_pub.g_hdr.drop_ship_flag :=p_header.drop_ship_flag ;
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12147: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12148: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12149:
12142: oe_order_pub.g_hdr.customer_payment_term_id :=p_header.customer_payment_term_id ;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12147: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12148: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12149:
12150: End Set_Header;
12143: oe_order_pub.g_hdr.payment_type_code :=p_header.payment_type_code ;
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12147: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12148: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12149:
12150: End Set_Header;
12151:
12144: oe_order_pub.g_hdr.payment_amount :=p_header.payment_amount ;
12145: oe_order_pub.g_hdr.credit_card_code :=p_header.credit_card_code ;
12146: oe_order_pub.g_hdr.credit_card_holder_name :=p_header.credit_card_holder_name ;
12147: oe_order_pub.g_hdr.credit_card_number :=p_header.credit_card_number ;
12148: oe_order_pub.g_hdr.marketing_source_code_id :=p_header.marketing_source_code_id ;
12149:
12150: End Set_Header;
12151:
12152: Procedure Load_Line_Tbl(p_quote_line_tbl in quote_line_tbl_type,
12149:
12150: End Set_Header;
12151:
12152: Procedure Load_Line_Tbl(p_quote_line_tbl in quote_line_tbl_type,
12153: x_line_tbl out nocopy Oe_Order_Pub.line_tbl_type) As
12154:
12155: i PLS_INTEGER;
12156: Begin
12157: --DBMS_OUTPUT.PUT_LINE('In load line tbl');
12216: End Loop;
12217:
12218: End;
12219:
12220: Procedure Load_Out_Quote_Line (p_line_tbl In Oe_Order_Pub.Line_tbl_Type,
12221: p_req_line_tbl In QP_PREQ_GRP.LINE_TBL_TYPE,
12222: x_quote_line_tbl out nocopy quote_line_tbl_type) As
12223:
12224: i PLS_INTEGER;
12320:
12321: x_return_status_text out nocopy Varchar2) As
12322:
12323:
12324: l_line_tbl Oe_Order_Pub.line_tbl_type;
12325: l_control_rec Qp_Preq_Grp.control_record_type;
12326: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
12327: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12328: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12330: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
12331: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
12332: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
12333: l_any_frozen_line Boolean;
12334: l_hdr_rec Oe_Order_Pub.Header_Rec_Type;
12335: l_stmt Varchar2(50);
12336: i PLS_INTEGER;
12337: Begin
12338:
12401: Procedure Create_Manual_Adjustments(p_line_id In Number)
12402: As
12403: l_return_stauts Varchar2(15);
12404: l_manual_adj_tbl Oe_Order_Adj_Pvt.Manual_Adj_Tbl_Type;
12405: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
12406: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
12407: l_control_rec OE_GLOBALS.Control_Rec_Type;
12408: i PLS_INTEGER;
12409: k PLS_INTEGER:=1;
12402: As
12403: l_return_stauts Varchar2(15);
12404: l_manual_adj_tbl Oe_Order_Adj_Pvt.Manual_Adj_Tbl_Type;
12405: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
12406: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
12407: l_control_rec OE_GLOBALS.Control_Rec_Type;
12408: i PLS_INTEGER;
12409: k PLS_INTEGER:=1;
12410: l_return_status Varchar2(15);
12501:
12502: Procedure Get_Manual_Adjustments (
12503: p_header_id in number Default Null,
12504: p_line_id in number Default Null,
12505: p_line_rec in oe_Order_Pub.Line_Rec_Type Default oe_order_pub.g_miss_line_rec,
12506: p_level in Varchar2 default 'LINE',
12507: p_pbh_mode in Varchar2 default 'CHILD',
12508: p_cross_order in Varchar2 Default 'N',
12509: p_line_level in Varchar2 Default 'N',
12517: --if no header id passed in this procedure it will return header id based on line id passed in
12518: )
12519: As
12520: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12521: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12522: l_line_rec oe_order_pub.line_rec_type;
12523: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12524: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12525: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12518: )
12519: As
12520: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12521: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12522: l_line_rec oe_order_pub.line_rec_type;
12523: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12524: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12525: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
12526: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
12681: Else
12682: l_line_tbl(1):= p_line_rec;
12683: End If;
12684:
12685: OE_Order_PUB.G_LINE := NULL;
12686: OE_Order_PUB.G_HDR := NULL;
12687:
12688: If p_header_id is Not Null and p_cross_order = 'N' Then
12689: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12682: l_line_tbl(1):= p_line_rec;
12683: End If;
12684:
12685: OE_Order_PUB.G_LINE := NULL;
12686: OE_Order_PUB.G_HDR := NULL;
12687:
12688: If p_header_id is Not Null and p_cross_order = 'N' Then
12689: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12690: End If;
12685: OE_Order_PUB.G_LINE := NULL;
12686: OE_Order_PUB.G_HDR := NULL;
12687:
12688: If p_header_id is Not Null and p_cross_order = 'N' Then
12689: oe_Header_util.query_row(p_header_id=>p_header_id,x_header_rec => OE_Order_PUB.g_hdr );
12690: End If;
12691:
12692:
12693: G_STMT_NO := 'Get_manual_adjustment#1';
12696:
12697: --Cross order lines, lines may not came from same header need to query header for each line
12698: If p_cross_order = 'Y' and p_header_id Is Null Then
12699: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,
12700: x_header_rec => OE_Order_PUB.g_hdr );
12701: oe_debug_pub.add(' Currency Code:'||OE_Order_PUB.g_hdr.transactional_curr_code);
12702: x_header_id := l_line_tbl(line_tbl_index).header_id;
12703: End If;
12704:
12697: --Cross order lines, lines may not came from same header need to query header for each line
12698: If p_cross_order = 'Y' and p_header_id Is Null Then
12699: oe_Header_util.query_row(p_header_id=>l_line_tbl(line_tbl_index).header_id,
12700: x_header_rec => OE_Order_PUB.g_hdr );
12701: oe_debug_pub.add(' Currency Code:'||OE_Order_PUB.g_hdr.transactional_curr_code);
12702: x_header_id := l_line_tbl(line_tbl_index).header_id;
12703: End If;
12704:
12705: --Populate global structure since attribute mapping only read global structure
12702: x_header_id := l_line_tbl(line_tbl_index).header_id;
12703: End If;
12704:
12705: --Populate global structure since attribute mapping only read global structure
12706: OE_Order_PUB.G_LINE := l_Line_Tbl(line_Tbl_Index);
12707: Begin
12708: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12709: --5598523
12710: IF l_line_tbl(line_tbl_index).line_id=p_line_id THEN
12723: p_pricing_type => 'L',
12724: x_price_contexts_result_tbl => l_pricing_contexts_Tbl,
12725: x_qual_contexts_result_tbl => l_qualifier_Contexts_Tbl);
12726: END IF;
12727: OE_Order_PUB.G_LINE := NULL;
12728: Exception
12729: When Others then
12730: oe_debug_pub.add(' QP ATTR MAPPING ERRORS 1');
12731: Raise QP_ATTR_MAPPING_ERRORS;
12830: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12831: QP_Attr_Mapping_PUB.Build_Contexts(
12832: p_request_type_code => 'ONT',
12833: p_pricing_type_code => 'H',
12834: p_line_index=> l_line_index + 1 --oe_order_pub.g_hdr.header_id
12835: );
12836: ELSE
12837: QP_Attr_Mapping_PUB.Build_Contexts(
12838: p_request_type_code => 'ONT',
12852:
12853: -- bucket man
12854: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12855: oe_order_price_pvt.copy_Header_to_request(
12856: p_header_rec => OE_Order_PUB.g_hdr
12857: ,px_req_line_tbl => l_req_line_tbl
12858: ,p_Request_Type_Code => 'ONT'
12859: ,p_calculate_price_flag =>'Y'
12860: ,px_line_index => l_line_index
12860: ,px_line_index => l_line_index
12861: );
12862: ELSE
12863: copy_Header_to_request(
12864: p_header_rec => OE_Order_PUB.g_hdr
12865: ,px_req_line_tbl => l_req_line_tbl
12866: ,p_Request_Type_Code => 'ONT'
12867: ,p_calculate_price_flag =>'Y'
12868: );