[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;