[Home] [Help]
PACKAGE: APPS.OE_AGREEMENT_UTIL
Source
1 PACKAGE OE_Agreement_Util AUTHID CURRENT_USER AS
2 /* $Header: OEXUAGRS.pls 120.2 2005/12/14 16:15:04 shulin noship $ */
3
4 -- Attributes global constants
5
6 G_ACCOUNTING_RULE CONSTANT NUMBER := 1;
7 G_AGREEMENT_CONTACT CONSTANT NUMBER := 2;
8 G_AGREEMENT CONSTANT NUMBER := 3;
9 G_AGREEMENT_NUM CONSTANT NUMBER := 4;
10 G_AGREEMENT_TYPE CONSTANT NUMBER := 5;
11 G_ATTRIBUTE1 CONSTANT NUMBER := 6;
12 G_ATTRIBUTE10 CONSTANT NUMBER := 7;
13 G_ATTRIBUTE11 CONSTANT NUMBER := 8;
14 G_ATTRIBUTE12 CONSTANT NUMBER := 9;
15 G_ATTRIBUTE13 CONSTANT NUMBER := 10;
16 G_ATTRIBUTE14 CONSTANT NUMBER := 11;
17 G_ATTRIBUTE15 CONSTANT NUMBER := 12;
18 G_ATTRIBUTE2 CONSTANT NUMBER := 13;
19 G_ATTRIBUTE3 CONSTANT NUMBER := 14;
20 G_ATTRIBUTE4 CONSTANT NUMBER := 15;
21 G_ATTRIBUTE5 CONSTANT NUMBER := 16;
22 G_ATTRIBUTE6 CONSTANT NUMBER := 17;
23 G_ATTRIBUTE7 CONSTANT NUMBER := 18;
24 G_ATTRIBUTE8 CONSTANT NUMBER := 19;
25 G_ATTRIBUTE9 CONSTANT NUMBER := 20;
26 G_CONTEXT CONSTANT NUMBER := 21;
27 G_CREATED_BY CONSTANT NUMBER := 22;
28 G_CREATION_DATE CONSTANT NUMBER := 23;
29 G_CUSTOMER CONSTANT NUMBER := 24;
30 G_END_DATE_ACTIVE CONSTANT NUMBER := 25;
31 G_FREIGHT_TERMS CONSTANT NUMBER := 26;
32 G_INVOICE_CONTACT CONSTANT NUMBER := 27;
33 G_INVOICE_TO_SITE_USE CONSTANT NUMBER := 28;
34 G_INVOICING_RULE CONSTANT NUMBER := 29;
35 G_LAST_UPDATED_BY CONSTANT NUMBER := 30;
36 G_LAST_UPDATE_DATE CONSTANT NUMBER := 31;
37 G_LAST_UPDATE_LOGIN CONSTANT NUMBER := 32;
38 G_NAME CONSTANT NUMBER := 33;
39 G_OVERRIDE_ARULE CONSTANT NUMBER := 34;
40 G_OVERRIDE_IRULE CONSTANT NUMBER := 35;
41 G_PRICE_LIST CONSTANT NUMBER := 36;
42 G_PURCHASE_ORDER_NUM CONSTANT NUMBER := 37;
43 G_REVISION CONSTANT NUMBER := 38;
44 G_REVISION_DATE CONSTANT NUMBER := 39;
45 G_REVISION_REASON CONSTANT NUMBER := 40;
46 G_SALESREP CONSTANT NUMBER := 41;
47 G_SHIP_METHOD CONSTANT NUMBER := 42;
48 G_SIGNATURE_DATE CONSTANT NUMBER := 43;
49 G_START_DATE_ACTIVE CONSTANT NUMBER := 44;
50 G_TERM CONSTANT NUMBER := 45;
51 G_AGREEMENT_SOURCE CONSTANT NUMBER := 46; --added by rchellam for OKC
52 G_ORIG_SYSTEM_AGR CONSTANT NUMBER := 47; --added by rchellam for OKC
53 G_MAX_ATTR_ID CONSTANT NUMBER := 48;
54 G_INVOICE_TO_CUSTOMER_ID CONSTANT NUMBER := 49; -- Added for bug#4029589
55
56 -- Procedure Clear_Dependent_Attr
57
58 PROCEDURE Clear_Dependent_Attr
59 ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
60 , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
61 , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
62 OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
63 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
64 );
65
66 -- Procedure Apply_Attribute_Changes
67
68 PROCEDURE Apply_Attribute_Changes
69 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
70 , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
71 OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
72 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
73 );
74
75 -- Function Complete_Record
76
77 FUNCTION Complete_Record
78 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
79 , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
80 ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;
81
82 -- Function Convert_Miss_To_Null
83
84 FUNCTION Convert_Miss_To_Null
85 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
86 ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;
87
88 -- Procedure Update_Row
89
90 PROCEDURE Update_Row
91 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
92 );
93
94 -- Procedure Insert_Row
95
96 PROCEDURE Insert_Row
97 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
98 );
99
100 -- Procedure Delete_Row
101
102 -- Added x_return_status for bug 2321498
103 PROCEDURE Delete_Row
104 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , p_agreement_id IN NUMBER
106 , p_Price_List_Exists_Flag IN BOOLEAN
107 , p_Agreement_Delete_Flag IN BOOLEAN
108 , p_Agreement_Lines_Delete_Flag IN BOOLEAN
109 );
110
111 -- Function Query_Row
112
113 FUNCTION Query_Row
114 ( p_agreement_id IN NUMBER
115 ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;
116
117 -- Function Query_Rows
118
119 --
120
121 FUNCTION Query_Rows
122 ( p_agreement_id IN NUMBER :=
123 FND_API.G_MISS_NUM
124 , p_pricing_contract_id IN NUMBER :=
125 FND_API.G_MISS_NUM
126 ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type;
127
128 -- Procedure lock_Row
129 --
130
131 PROCEDURE Lock_Row
132 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
134 , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type
135 );
136
137 -- Function Get_Values
138
139 FUNCTION Get_Values
140 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
141 , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=
142 OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC
143 ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;
144
145 -- Function Get_Ids
146
147 FUNCTION Get_Ids
148 ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type
149 , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type
150 ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;
151
152 END OE_Agreement_Util;