8: -- Procedure Entity
9:
10: PROCEDURE Entity
11: ( x_return_status OUT VARCHAR2
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: )
16: IS
9:
10: PROCEDURE Entity
11: ( x_return_status OUT VARCHAR2
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10: PROCEDURE Entity
11: ( x_return_status OUT VARCHAR2
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: )
16: IS
17: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
18: BEGIN
173:
174: -- Geresh Added to check dupliacates
175: Procedure Check_PLL_Duplicates
176: ( x_return_status OUT varchar2
177: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
178: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
179: )
180: IS
181: l_Count NUMBER := 0;
174: -- Geresh Added to check dupliacates
175: Procedure Check_PLL_Duplicates
176: ( x_return_status OUT varchar2
177: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
178: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
179: )
180: IS
181: l_Count NUMBER := 0;
182: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
246: -- Procedure Attributes
247:
248: PROCEDURE Attributes
249: ( x_return_status OUT VARCHAR2
250: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
251: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
252: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
253: )
254: IS
247:
248: PROCEDURE Attributes
249: ( x_return_status OUT VARCHAR2
250: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
251: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
252: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
253: )
254: IS
255: l_primary_exists BOOLEAN;
248: PROCEDURE Attributes
249: ( x_return_status OUT VARCHAR2
250: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
251: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
252: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
253: )
254: IS
255: l_primary_exists BOOLEAN;
256: BEGIN
1016: -- Procedure Entity_Delete
1017:
1018: PROCEDURE Entity_Delete
1019: ( x_return_status OUT VARCHAR2
1020: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
1021: )
1022: IS
1023: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1024: BEGIN