64: FUNCTION G_MISS_OE_AK_HPAYMENT_REC
65: RETURN OE_AK_HEADER_PAYMENTS_V%ROWTYPE;
66:
67: PROCEDURE API_Rec_To_Rowtype_Rec
68: ( p_HEADER_PAYMENT_rec IN OE_Order_PUB.HEADER_PAYMENT_Rec_Type
69: , x_rowtype_rec IN OUT NOCOPY OE_AK_HEADER_PAYMENTS_V%ROWTYPE
70: );
71:
72: PROCEDURE Rowtype_Rec_To_API_Rec
70: );
71:
72: PROCEDURE Rowtype_Rec_To_API_Rec
73: ( p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
74: , x_api_rec IN OUT NOCOPY OE_Order_PUB.HEADER_PAYMENT_Rec_Type
75: );
76:
77: -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
78:
88: -- Procedure Clear_Dependent_Attr
89:
90: PROCEDURE Clear_Dependent_Attr
91: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
93: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
94: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
95: );
96:
89:
90: PROCEDURE Clear_Dependent_Attr
91: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
93: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
94: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
95: );
96:
97: -- Procedure Apply_Attribute_Changes
90: PROCEDURE Clear_Dependent_Attr
91: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
92: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
93: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
94: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
95: );
96:
97: -- Procedure Apply_Attribute_Changes
98:
96:
97: -- Procedure Apply_Attribute_Changes
98:
99: PROCEDURE Apply_Attribute_Changes
100: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
101: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
102: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
103: );
104:
97: -- Procedure Apply_Attribute_Changes
98:
99: PROCEDURE Apply_Attribute_Changes
100: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
101: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
102: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
103: );
104:
105: -- Function Complete_Record
98:
99: PROCEDURE Apply_Attribute_Changes
100: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
101: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
102: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
103: );
104:
105: -- Function Complete_Record
106:
104:
105: -- Function Complete_Record
106:
107: PROCEDURE Complete_Record
108: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
109: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
110: ) ;
111:
112: -- Function Convert_Miss_To_Null
105: -- Function Complete_Record
106:
107: PROCEDURE Complete_Record
108: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
109: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
110: ) ;
111:
112: -- Function Convert_Miss_To_Null
113:
111:
112: -- Function Convert_Miss_To_Null
113:
114: PROCEDURE Convert_Miss_To_Null
115: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
116: ) ;
117:
118: -- Procedure Update_Row
119:
117:
118: -- Procedure Update_Row
119:
120: PROCEDURE Update_Row
121: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
122: );
123:
124: -- Procedure Insert_Row
125:
123:
124: -- Procedure Insert_Row
125:
126: PROCEDURE Insert_Row
127: ( p_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
128: );
129:
130: -- Procedure Delete_Row
131:
140:
141: PROCEDURE Query_Row
142: ( p_payment_number IN NUMBER,
143: p_header_id IN NUMBER,
144: x_Header_Payment_Rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
145: ) ;
146:
147: -- Function Query_Rows
148:
152: ( p_payment_number IN NUMBER :=
153: FND_API.G_MISS_NUM
154: , p_header_id IN NUMBER :=
155: FND_API.G_MISS_NUM
156: , x_Header_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Header_Payment_tbl_Type
157:
158: );
159:
160: -- Procedure lock_Row
162:
163: PROCEDURE Lock_Row
164: ( x_return_status OUT NOCOPY VARCHAR2
165:
166: , p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
167: , p_payment_number IN NUMBER
168: := FND_API.G_MISS_NUM
169: , p_header_id IN NUMBER
170: := FND_API.G_MISS_NUM
174: ( p_payment_number IN NUMBER :=
175: FND_API.G_MISS_NUM
176: , p_header_id IN NUMBER :=
177: FND_API.G_MISS_NUM
178: , x_header_Payment_tbl OUT NOCOPY OE_Order_PUB.header_Payment_Tbl_Type
179: , x_return_status OUT NOCOPY VARCHAR2
180:
181: );
182:
182:
183: -- Function Get_Values
184:
185: FUNCTION Get_Values
186: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
187: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
188: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
189: ) RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type;
190:
183: -- Function Get_Values
184:
185: FUNCTION Get_Values
186: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
187: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
188: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
189: ) RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type;
190:
191: -- Function Get_Ids
184:
185: FUNCTION Get_Values
186: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
187: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
188: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
189: ) RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type;
190:
191: -- Function Get_Ids
192:
185: FUNCTION Get_Values
186: ( p_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type
187: , p_old_Header_Payment_rec IN OE_Order_PUB.Header_Payment_Rec_Type :=
188: OE_Order_PUB.G_MISS_HEADER_PAYMENT_REC
189: ) RETURN OE_Order_PUB.Header_Payment_Val_Rec_Type;
190:
191: -- Function Get_Ids
192:
193: PROCEDURE Get_Ids
190:
191: -- Function Get_Ids
192:
193: PROCEDURE Get_Ids
194: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
195: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
196: ) ;
197:
198: PROCEDURE Pre_Write_Process
191: -- Function Get_Ids
192:
193: PROCEDURE Get_Ids
194: ( p_x_Header_Payment_rec IN OUT NOCOPY OE_Order_PUB.Header_Payment_Rec_Type
195: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
196: ) ;
197:
198: PROCEDURE Pre_Write_Process
199: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
195: , p_Header_Payment_val_rec IN OE_Order_PUB.Header_Payment_Val_Rec_Type
196: ) ;
197:
198: PROCEDURE Pre_Write_Process
199: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
200: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC );
201:
202: END OE_Header_Payment_Util;
196: ) ;
197:
198: PROCEDURE Pre_Write_Process
199: ( p_x_header_Payment_rec IN OUT NOCOPY OE_ORDER_PUB.header_Payment_rec_type,
200: p_old_header_Payment_rec IN OE_ORDER_PUB.header_Payment_rec_type := OE_ORDER_PUB.G_MISS_HEADER_PAYMENT_REC );
201:
202: END OE_Header_Payment_Util;