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