DBA Data[Home] [Help]

APPS.QP_PRICE_LIST_PVT dependencies on OE_PRICE_LIST_PUB

Line 30: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

26: OE_GLOBALS.G_MISS_CONTROL_REC
27: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

27: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

28: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

Line 33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

29: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

Line 34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

30: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
38: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

31: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
38: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
39: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

32: , p_old_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
38: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
39: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
40: );

Line 37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

33: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
38: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
39: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
40: );
41:

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

34: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
38: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
39: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
40: );
41:
42: -- Start of Comments

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

35: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
36: , p_old_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
37: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
38: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
39: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
40: );
41:
42: -- Start of Comments
43: -- API name Lock_Price_List

Line 64: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

60: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
61: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
68: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type

Line 65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC

61: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
68: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
69: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type

Line 66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=

62: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
68: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
69: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
70: );

Line 67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL

63: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
68: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
69: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
70: );
71:

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

64: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=
65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
68: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
69: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
70: );
71:
72: -- Start of Comments

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

65: OE_Price_List_PUB.G_MISS_PRICE_LIST_REC
66: , p_PRICE_LIST_LINE_tbl IN OE_Price_List_PUB.Price_List_Line_Tbl_Type :=
67: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_TBL
68: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
69: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
70: );
71:
72: -- Start of Comments
73: -- API name Get_Price_List

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

92: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , p_name IN VARCHAR2
95: , p_price_list_id IN NUMBER
96: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
97: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
98: );
99:
100: -- Start of Comments

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

93: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , p_name IN VARCHAR2
95: , p_price_list_id IN NUMBER
96: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Rec_Type
97: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Tbl_Type
98: );
99:
100: -- Start of Comments
101: -- API name : Fetch_List_Price