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