29:
30: PROCEDURE Price_List
31: ( p_validation_level IN NUMBER
32: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
33: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
34: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
35: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
37: )
30: PROCEDURE Price_List
31: ( p_validation_level IN NUMBER
32: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
33: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
34: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
35: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
37: )
38: IS
31: ( p_validation_level IN NUMBER
32: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
33: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
34: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
35: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
37: )
38: IS
39: l_return_status VARCHAR2(1);
32: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
33: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
34: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type
35: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
37: )
38: IS
39: l_return_status VARCHAR2(1);
40: l_control_rec OE_GLOBALS.Control_Rec_Type;
37: )
38: IS
39: l_return_status VARCHAR2(1);
40: l_control_rec OE_GLOBALS.Control_Rec_Type;
41: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
42: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
43: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
44: BEGIN
45:
38: IS
39: l_return_status VARCHAR2(1);
40: l_control_rec OE_GLOBALS.Control_Rec_Type;
41: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
42: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
43: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
44: BEGIN
45:
46: -- Load API control record
39: l_return_status VARCHAR2(1);
40: l_control_rec OE_GLOBALS.Control_Rec_Type;
41: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
42: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
43: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
44: BEGIN
45:
46: -- Load API control record
47:
272:
273: PROCEDURE Price_List_Lines
274: ( p_validation_level IN NUMBER
275: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
276: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
277: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
278: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
280: )
273: PROCEDURE Price_List_Lines
274: ( p_validation_level IN NUMBER
275: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
276: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
277: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
278: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
280: )
281: IS
274: ( p_validation_level IN NUMBER
275: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
276: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
277: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
278: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
280: )
281: IS
282: l_return_status VARCHAR2(1);
275: , p_control_rec IN OE_GLOBALS.Control_Rec_Type
276: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
277: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type
278: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
280: )
281: IS
282: l_return_status VARCHAR2(1);
283: l_control_rec OE_GLOBALS.Control_Rec_Type;
280: )
281: IS
282: l_return_status VARCHAR2(1);
283: l_control_rec OE_GLOBALS.Control_Rec_Type;
284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
288: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
281: IS
282: l_return_status VARCHAR2(1);
283: l_control_rec OE_GLOBALS.Control_Rec_Type;
284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
288: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
289: BEGIN
282: l_return_status VARCHAR2(1);
283: l_control_rec OE_GLOBALS.Control_Rec_Type;
284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
288: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
289: BEGIN
290:
283: l_control_rec OE_GLOBALS.Control_Rec_Type;
284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
288: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
289: BEGIN
290:
291: -- Init local table variables.
284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
288: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
289: BEGIN
290:
291: -- Init local table variables.
292:
302:
303: IF l_old_PRICE_LIST_LINE_tbl.EXISTS(I) THEN
304: l_old_PRICE_LIST_LINE_rec := l_old_PRICE_LIST_LINE_tbl(I);
305: ELSE
306: l_old_PRICE_LIST_LINE_rec := OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;
307: END IF;
308:
309: -- Load API control record
310:
587: OE_GLOBALS.G_MISS_CONTROL_REC
588: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
589: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
590: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
592: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
588: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
589: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
590: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
592: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
589: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
590: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
592: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
590: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
592: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
592: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
592: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
600: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
600: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
601: )
594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
600: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
601: )
602: IS
595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
600: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
601: )
602: IS
603: l_api_version_number CONSTANT NUMBER := 1.0;
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
597: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
600: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
601: )
602: IS
603: l_api_version_number CONSTANT NUMBER := 1.0;
604: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
603: l_api_version_number CONSTANT NUMBER := 1.0;
604: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
605: l_return_status VARCHAR2(1);
606: l_control_rec OE_GLOBALS.Control_Rec_Type;
607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
604: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';
605: l_return_status VARCHAR2(1);
606: l_control_rec OE_GLOBALS.Control_Rec_Type;
607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
605: l_return_status VARCHAR2(1);
606: l_control_rec OE_GLOBALS.Control_Rec_Type;
607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
606: l_control_rec OE_GLOBALS.Control_Rec_Type;
607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
616: l_p_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
616: l_p_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
617: BEGIN
610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
616: l_p_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
617: BEGIN
618:
611: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
616: l_p_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
617: BEGIN
618:
619: -- Standard call to check for call compatibility
612: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
613: l_p_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
616: l_p_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
617: BEGIN
618:
619: -- Standard call to check for call compatibility
620:
826: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
827: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
828: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
829: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
832: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
827: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
828: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
829: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
832: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
835: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
828: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
829: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
832: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
835: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
836: )
829: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
832: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
835: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
836: )
837: IS
830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
832: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
835: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
836: )
837: IS
838: l_api_version_number CONSTANT NUMBER := 1.0;
831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
832: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
835: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
836: )
837: IS
838: l_api_version_number CONSTANT NUMBER := 1.0;
839: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
837: IS
838: l_api_version_number CONSTANT NUMBER := 1.0;
839: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
840: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
841: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
842: BEGIN
843:
844: -- Standard call to check for call compatibility
845:
998: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
999: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1000: , p_name IN VARCHAR2
1001: , p_price_list_id IN NUMBER
1002: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1003: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1004: )
1005: IS
1006: l_api_version_number CONSTANT NUMBER := 1.0;
999: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1000: , p_name IN VARCHAR2
1001: , p_price_list_id IN NUMBER
1002: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
1003: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
1004: )
1005: IS
1006: l_api_version_number CONSTANT NUMBER := 1.0;
1007: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
1004: )
1005: IS
1006: l_api_version_number CONSTANT NUMBER := 1.0;
1007: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
1008: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1009: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1010: BEGIN
1011:
1012: -- Standard call to check for call compatibility
1005: IS
1006: l_api_version_number CONSTANT NUMBER := 1.0;
1007: l_api_name CONSTANT VARCHAR2(30):= 'Get_Price_List';
1008: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;
1009: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
1010: BEGIN
1011:
1012: -- Standard call to check for call compatibility
1013: