APPS.OE_AGREEMENT_UTIL dependencies on OE_PRICING_CONT_PUB

Line 60: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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: );

Line 61: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

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:

Line 62: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

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

Line 63: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

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:

Line 69: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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: );

Line 70: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

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:

Line 71: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

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

Line 72: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

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:

Line 78: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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

Line 79: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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:

Line 80: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;

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

Line 85: ( p_Agreement_rec IN 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:

Line 86: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;

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

Line 91: ( p_Agreement_rec IN 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:

Line 97: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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:

Line 115: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;

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: --

Line 126: ) RETURN OE_Pricing_Cont_PUB.Agreement_Tbl_Type;

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:

Line 133: , p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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

Line 134: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ OE_Pricing_Cont_PUB.Agreement_Rec_Type

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:

Line 140: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type

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:

Line 141: , p_old_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_Rec_Type :=

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

Line 142: OE_Pricing_Cont_PUB.G_MISS_AGREEMENT_REC

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:

Line 143: ) RETURN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type;

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

Line 148: ( p_Agreement_rec IN OE_Pricing_Cont_PUB.Agreement_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;

Line 149: , p_Agreement_val_rec IN OE_Pricing_Cont_PUB.Agreement_Val_Rec_Type

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;

Line 150: ) RETURN OE_Pricing_Cont_PUB.Agreement_Rec_Type;

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;