PACKAGE: APPS.QP_VALIDATE_PRICING_ATTR

Source

1 PACKAGE QP_Validate_Pricing_Attr AUTHID CURRENT_USER AS
2 /* $Header: QPXLPRAS.pls 120.1 2005/06/08 23:55:38 appldev  $ */
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_Modifiers_PUB.Pricing_Attr_Rec_Type
9 ,   p_old_PRICING_ATTR_rec          IN  QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
10                                         QP_Modifiers_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_Modifiers_PUB.Pricing_Attr_Rec_Type
18 ,   p_old_PRICING_ATTR_rec          IN  QP_Modifiers_PUB.Pricing_Attr_Rec_Type :=
19                                         QP_Modifiers_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_Modifiers_PUB.Pricing_Attr_Rec_Type
27 );
28 
29 -- start bug2091362
30 /* Function to check duplicates in Modifier Lines */
31 
32 FUNCTION MOD_DUP(p_Start_Date_Active IN DATE
33                                    , p_End_Date_Active IN DATE
34                                            , p_List_Line_ID IN NUMBER
35                                            , p_List_Header_ID IN NUMBER
36                                            , p_product_attribute_context IN VARCHAR2
37                                            , p_product_attribute IN VARCHAR2
38                                            , p_product_attr_value IN VARCHAR2
39                                            , p_x_rows OUT NOCOPY /* file.sql.39 change */ NUMBER
40                                            , p_x_effdates OUT NOCOPY /* file.sql.39 change */ BOOLEAN
41                                            )RETURN BOOLEAN;
42 -- end 2091362
43 
44 
45 END QP_Validate_Pricing_Attr;