PACKAGE: APPS.QP_VALIDATE_PLL_PRICING_ATTR

Source

1 PACKAGE QP_Validate_pll_pricing_attr AUTHID CURRENT_USER AS
2 /* $Header: QPXLPLAS.pls 120.1.12010000.1 2008/07/28 11:54:10 appldev ship $ */
3 
4 --  Procedure Entity
5 
6 PROCEDURE Entity
7 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8 ,   p_PRICING_ATTR_rec              IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type
9 ,   p_old_PRICING_ATTR_rec          IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
10                                         QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
11 );
12 
13 --  Procedure Attributes
14 
15 PROCEDURE Attributes
16 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 ,   p_PRICING_ATTR_rec              IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type
18 ,   p_old_PRICING_ATTR_rec          IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
19                                         QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
20 );
21 
22 --  Procedure Entity_Delete
23 
24 PROCEDURE Entity_Delete
25 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 ,   p_PRICING_ATTR_rec              IN  QP_Price_List_PUB.Pricing_Attr_Rec_Type
27 );
28 
29 /* New Procedure to check duplicates in Lines */
30 
31 FUNCTION Check_Dup_Pra (   p_Start_Date_Active IN DATE
32   					   , p_End_Date_Active IN DATE
33 					   , p_Revision IN VARCHAR2
34 					   , p_List_Line_ID IN NUMBER
35 					   , p_List_Header_ID IN NUMBER
36 					   , p_x_rows OUT NOCOPY NUMBER
37 					   , p_x_revision OUT NOCOPY BOOLEAN
38 					   , p_x_effdates OUT NOCOPY BOOLEAN
39 					   , p_x_dup_sdate OUT NOCOPY DATE
40 					   , p_x_dup_edate OUT NOCOPY DATE
41 					 )
42 RETURN BOOLEAN;
43 
44 
45 /* Added new From Jan18 */
46 FUNCTION Check_Line_Revision(   p_Revision IN VARCHAR2
47 					   , p_List_Line_ID IN NUMBER
48 					   , p_List_Header_ID IN NUMBER
49 					   , p_x_rows OUT NOCOPY /* file.sql.39 change */ NUMBER
50 					 )
51 RETURN BOOLEAN;
52 
53 FUNCTION Check_Line_EffDates(    p_Start_Date_Active IN DATE
54   					   , p_End_Date_Active IN DATE
55 					   , p_Revision IN VARCHAR2
56 					   , p_List_Line_ID IN NUMBER
57 					   , p_List_Header_ID IN NUMBER
58 					   , p_x_rows OUT NOCOPY /* file.sql.39 change */ NUMBER
59 					 )
60 RETURN BOOLEAN;
61 
62 END QP_Validate_pll_pricing_attr;