DBA Data[Home] [Help]

PACKAGE: APPS.OE_CONTRACT_UTIL

Source


1 PACKAGE OE_Contract_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUPCTS.pls 115.0 99/07/15 19:27:52 porting shi $ */
3 
4 --  Attributes global constants
5 
6 G_AGREEMENT                   CONSTANT NUMBER := 1;
7 G_ATTRIBUTE1                  CONSTANT NUMBER := 2;
8 G_ATTRIBUTE10                 CONSTANT NUMBER := 3;
9 G_ATTRIBUTE11                 CONSTANT NUMBER := 4;
10 G_ATTRIBUTE12                 CONSTANT NUMBER := 5;
11 G_ATTRIBUTE13                 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE14                 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE15                 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE2                  CONSTANT NUMBER := 9;
15 G_ATTRIBUTE3                  CONSTANT NUMBER := 10;
16 G_ATTRIBUTE4                  CONSTANT NUMBER := 11;
17 G_ATTRIBUTE5                  CONSTANT NUMBER := 12;
18 G_ATTRIBUTE6                  CONSTANT NUMBER := 13;
19 G_ATTRIBUTE7                  CONSTANT NUMBER := 14;
20 G_ATTRIBUTE8                  CONSTANT NUMBER := 15;
21 G_ATTRIBUTE9                  CONSTANT NUMBER := 16;
22 G_CONTEXT                     CONSTANT NUMBER := 17;
23 G_CREATED_BY                  CONSTANT NUMBER := 18;
24 G_CREATION_DATE               CONSTANT NUMBER := 19;
25 G_DISCOUNT                    CONSTANT NUMBER := 20;
26 G_LAST_UPDATED_BY             CONSTANT NUMBER := 21;
27 G_LAST_UPDATE_DATE            CONSTANT NUMBER := 22;
28 G_LAST_UPDATE_LOGIN           CONSTANT NUMBER := 23;
29 G_PRICE_LIST                  CONSTANT NUMBER := 24;
30 G_PRICING_CONTRACT            CONSTANT NUMBER := 25;
31 G_MAX_ATTR_ID                 CONSTANT NUMBER := 26;
32 
33 --  Procedure Clear_Dependent_Attr
34 
35 PROCEDURE Clear_Dependent_Attr
36 (   p_attr_id                       IN  NUMBER := FND_API.G_MISS_NUM
37 ,   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
38 ,   p_old_Contract_rec              IN  OE_Pricing_Cont_PUB.Contract_Rec_Type :=
39                                         OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
40 ,   x_Contract_rec                  OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
41 );
42 
43 --  Procedure Apply_Attribute_Changes
44 
45 PROCEDURE Apply_Attribute_Changes
46 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
47 ,   p_old_Contract_rec              IN  OE_Pricing_Cont_PUB.Contract_Rec_Type :=
48                                         OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
49 ,   x_Contract_rec                  OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
50 );
51 
52 --  Function Complete_Record
53 
54 FUNCTION Complete_Record
55 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
56 ,   p_old_Contract_rec              IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
57 ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
58 
59 --  Function Convert_Miss_To_Null
60 
61 FUNCTION Convert_Miss_To_Null
62 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
63 ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
64 
65 --  Procedure Update_Row
66 
67 PROCEDURE Update_Row
68 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
69 );
70 
71 --  Procedure Insert_Row
72 
73 PROCEDURE Insert_Row
74 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
75 );
76 
77 --  Procedure Delete_Row
78 
79 PROCEDURE Delete_Row
80 (   p_pricing_contract_id           IN  NUMBER
81 );
82 
83 --  Function Query_Row
84 
85 FUNCTION Query_Row
86 (   p_pricing_contract_id           IN  NUMBER
87 ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
88 
89 --  Procedure       lock_Row
90 --
91 
92 PROCEDURE Lock_Row
93 (   x_return_status                 OUT VARCHAR2
94 ,   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
95 ,   x_Contract_rec                  OUT OE_Pricing_Cont_PUB.Contract_Rec_Type
96 );
97 
98 --  Function Get_Values
99 
100 FUNCTION Get_Values
101 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
102 ,   p_old_Contract_rec              IN  OE_Pricing_Cont_PUB.Contract_Rec_Type :=
103                                         OE_Pricing_Cont_PUB.G_MISS_CONTRACT_REC
104 ) RETURN OE_Pricing_Cont_PUB.Contract_Val_Rec_Type;
105 
106 --  Function Get_Ids
107 
108 FUNCTION Get_Ids
109 (   p_Contract_rec                  IN  OE_Pricing_Cont_PUB.Contract_Rec_Type
110 ,   p_Contract_val_rec              IN  OE_Pricing_Cont_PUB.Contract_Val_Rec_Type
111 ) RETURN OE_Pricing_Cont_PUB.Contract_Rec_Type;
112 
113 END OE_Contract_Util;