18: -- End of Comments
19:
20: PROCEDURE Process_Price_List
21: ( p_api_version_number IN NUMBER
22: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
19:
20: PROCEDURE Process_Price_List
21: ( p_api_version_number IN NUMBER
22: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
27: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20: PROCEDURE Process_Price_List
21: ( p_api_version_number IN NUMBER
22: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
24: , p_commit IN VARCHAR2 := FND_API.G_FALSE
25: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
27: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
68: -- End of Comments
69:
70: PROCEDURE Lock_Price_List
71: ( p_api_version_number IN NUMBER
72: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
73: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
74: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69:
70: PROCEDURE Lock_Price_List
71: ( p_api_version_number IN NUMBER
72: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
73: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
74: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: , p_PRICE_LIST_rec IN QP_Price_List_PUB.Price_List_Rec_Type :=
117: -- End of Comments
118:
119: PROCEDURE Get_Price_List
120: ( p_api_version_number IN NUMBER
121: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
122: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
123: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118:
119: PROCEDURE Get_Price_List
120: ( p_api_version_number IN NUMBER
121: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
122: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
123: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_list_header_id IN NUMBER :=
123: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_list_header_id IN NUMBER :=
127: FND_API.G_MISS_NUM
128: , p_list_header IN VARCHAR2 :=
129: FND_API.G_MISS_CHAR
130: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
125: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126: , p_list_header_id IN NUMBER :=
127: FND_API.G_MISS_NUM
128: , p_list_header IN VARCHAR2 :=
129: FND_API.G_MISS_CHAR
130: , x_PRICE_LIST_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
131: , x_PRICE_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type
132: , x_PRICE_LIST_LINE_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Tbl_Type
133: , x_PRICE_LIST_LINE_val_tbl OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Line_Val_Tbl_Type