DBA Data[Home] [Help]

APPS.OE_HEADER_SCREDIT_UTIL dependencies on OE_ORDER_PUB

Line 88: ( p_HEADER_SCREDIT_rec IN OE_Order_PUB.HEADER_SCREDIT_Rec_Type

84: FUNCTION G_MISS_OE_AK_HSCREDIT_REC
85: RETURN OE_AK_HEADER_SCREDITS_V%ROWTYPE;
86:
87: PROCEDURE API_Rec_To_Rowtype_Rec
88: ( p_HEADER_SCREDIT_rec IN OE_Order_PUB.HEADER_SCREDIT_Rec_Type
89: , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_SCREDITS_V%ROWTYPE
90: );
91:
92: PROCEDURE Rowtype_Rec_To_API_Rec

Line 94: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_SCREDIT_Rec_Type

90: );
91:
92: PROCEDURE Rowtype_Rec_To_API_Rec
93: ( p_record IN OE_AK_HEADER_SCREDITS_V%ROWTYPE
94: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_SCREDIT_Rec_Type
95: );
96:
97: -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
98:

Line 110: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

106: -- Procedure Clear_Dependent_Attr
107:
108: PROCEDURE Clear_Dependent_Attr
109: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
110: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
111: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
113: );
114:

Line 111: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=

107:
108: PROCEDURE Clear_Dependent_Attr
109: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
110: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
111: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
113: );
114:
115: -- Procedure Apply_Attribute_Changes

Line 112: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

108: PROCEDURE Clear_Dependent_Attr
109: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
110: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
111: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
113: );
114:
115: -- Procedure Apply_Attribute_Changes
116:

Line 118: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

114:
115: -- Procedure Apply_Attribute_Changes
116:
117: PROCEDURE Apply_Attribute_Changes
118: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
119: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
120: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
121: );
122:

Line 119: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=

115: -- Procedure Apply_Attribute_Changes
116:
117: PROCEDURE Apply_Attribute_Changes
118: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
119: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
120: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
121: );
122:
123: -- Function Complete_Record

Line 120: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

116:
117: PROCEDURE Apply_Attribute_Changes
118: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
119: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
120: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
121: );
122:
123: -- Function Complete_Record
124:

Line 126: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

122:
123: -- Function Complete_Record
124:
125: PROCEDURE Complete_Record
126: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
127: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
128: ) ;
129:
130: -- Function Convert_Miss_To_Null

Line 127: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

123: -- Function Complete_Record
124:
125: PROCEDURE Complete_Record
126: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
127: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
128: ) ;
129:
130: -- Function Convert_Miss_To_Null
131:

Line 133: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

129:
130: -- Function Convert_Miss_To_Null
131:
132: PROCEDURE Convert_Miss_To_Null
133: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
134: ) ;
135:
136: -- Procedure Update_Row
137:

Line 139: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

135:
136: -- Procedure Update_Row
137:
138: PROCEDURE Update_Row
139: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
140: );
141:
142: -- Procedure Insert_Row
143:

Line 145: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

141:
142: -- Procedure Insert_Row
143:
144: PROCEDURE Insert_Row
145: ( p_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
146: );
147:
148: -- Procedure Delete_Row
149:

Line 161: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

157: -- Function Query_Row
158:
159: PROCEDURE Query_Row
160: ( p_sales_credit_id IN NUMBER,
161: x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
162: ) ;
163:
164: -- Function Query_Rows
165:

Line 173: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type

169: ( p_sales_credit_id IN NUMBER :=
170: FND_API.G_MISS_NUM
171: , p_header_id IN NUMBER :=
172: FND_API.G_MISS_NUM
173: , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
174:
175: );
176:
177: -- Procedure lock_Row

Line 182: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

178: --
179:
180: PROCEDURE Lock_Row
181: ( x_return_status OUT NOCOPY VARCHAR2
182: , p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
183: , p_sales_credit_id IN NUMBER
184: := FND_API.G_MISS_NUM
185: );
186:

Line 192: , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type

188: ( p_sales_credit_id IN NUMBER :=
189: FND_API.G_MISS_NUM
190: , p_header_id IN NUMBER :=
191: FND_API.G_MISS_NUM
192: , x_header_scredit_tbl OUT NOCOPY OE_Order_PUB.header_scredit_Tbl_Type
193: , x_return_status OUT NOCOPY VARCHAR2
194: );
195:
196: -- Function Get_Values

Line 199: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type

195:
196: -- Function Get_Values
197:
198: FUNCTION Get_Values
199: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
200: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
201: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
202: ) RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type;
203:

Line 200: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=

196: -- Function Get_Values
197:
198: FUNCTION Get_Values
199: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
200: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
201: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
202: ) RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type;
203:
204: -- Function Get_Ids

Line 201: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC

197:
198: FUNCTION Get_Values
199: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
200: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
201: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
202: ) RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type;
203:
204: -- Function Get_Ids
205:

Line 202: ) RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type;

198: FUNCTION Get_Values
199: ( p_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type
200: , p_old_Header_Scredit_rec IN OE_Order_PUB.Header_Scredit_Rec_Type :=
201: OE_Order_PUB.G_MISS_HEADER_SCREDIT_REC
202: ) RETURN OE_Order_PUB.Header_Scredit_Val_Rec_Type;
203:
204: -- Function Get_Ids
205:
206: PROCEDURE Get_Ids

Line 207: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type

203:
204: -- Function Get_Ids
205:
206: PROCEDURE Get_Ids
207: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
208: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
209: ) ;
210:
211: PROCEDURE Pre_Write_Process

Line 208: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type

204: -- Function Get_Ids
205:
206: PROCEDURE Get_Ids
207: ( p_x_Header_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
208: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
209: ) ;
210:
211: PROCEDURE Pre_Write_Process
212: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,

Line 212: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,

208: , p_Header_Scredit_val_rec IN OE_Order_PUB.Header_Scredit_Val_Rec_Type
209: ) ;
210:
211: PROCEDURE Pre_Write_Process
212: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,
213: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC );
214:
215: --SG{
216: Procedure Get_Sales_Group(p_date IN DATE:=NULL,

Line 213: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC );

209: ) ;
210:
211: PROCEDURE Pre_Write_Process
212: ( p_x_header_scredit_rec IN OUT NOCOPY OE_ORDER_PUB.header_scredit_rec_type,
213: p_old_header_scredit_rec IN OE_ORDER_PUB.header_scredit_rec_type := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_REC );
214:
215: --SG{
216: Procedure Get_Sales_Group(p_date IN DATE:=NULL,
217: p_sales_rep_id IN NUMBER,