eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_LIST_PVT dependencies on OE_PRICE_LIST_PUB

Line 33: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

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: )

Line 34: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type

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

Line 35: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

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);

Line 36: , x_old_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

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;

Line 41: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

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:

Line 42: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

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

Line 43: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

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:

Line 276: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type

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: )

Line 277: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type

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

Line 278: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

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);

Line 279: , x_old_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

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;

Line 284: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_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;

Line 285: l_p_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_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

Line 286: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

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:

Line 287: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

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.

Line 288: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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.
292:

Line 306: l_old_PRICE_LIST_LINE_rec := OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC;

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:

Line 591: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

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 :=

Line 592: OE_Price_List_PUB.G_MISS_PRICE_LIST_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 :=
596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 593: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

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 :=

Line 594: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

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

Line 595: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

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

Line 596: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

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

Line 597: , p_old_PRICE_LIST_LINE_tbl IN 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: )

Line 598: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

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

Line 599: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

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;

Line 600: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ 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;
604: l_api_name CONSTANT VARCHAR2(30):= 'Process_Price_List';

Line 607: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

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;

Line 608: l_p_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_PRICE_LIST_rec;

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;

Line 609: l_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

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;

Line 610: l_p_old_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type := p_old_PRICE_LIST_rec;

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;

Line 611: l_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;

Line 612: l_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;

Line 613: l_p_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

Line 614: l_old_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

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:

Line 615: l_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

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

Line 616: l_p_old_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_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
620:

Line 830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

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

Line 831: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

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

Line 832: , p_PRICE_LIST_LINE_tbl IN 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: )

Line 833: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

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

Line 834: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

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;

Line 835: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_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;
839: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';

Line 841: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;

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:

Line 1002: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

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;

Line 1003: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

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';

Line 1008: l_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type;

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

Line 1009: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;

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: