47: FUNCTION G_MISS_OE_AK_LINE_SCREDIT_REC
48: RETURN OE_AK_LINE_SCREDITS_V%ROWTYPE;
49:
50: PROCEDURE API_Rec_To_Rowtype_Rec
51: ( p_LINE_SCREDIT_rec IN OE_Order_PUB.LINE_SCREDIT_Rec_Type
52: , x_rowtype_rec IN OUT NOCOPY OE_AK_LINE_SCREDITS_V%ROWTYPE
53: );
54:
55: PROCEDURE Rowtype_Rec_To_API_Rec
53: );
54:
55: PROCEDURE Rowtype_Rec_To_API_Rec
56: ( p_record IN OE_AK_LINE_SCREDITS_V%ROWTYPE
57: , x_api_rec IN OUT NOCOPY OE_Order_PUB.LINE_SCREDIT_Rec_Type
58: );
59:
60: -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters
61:
69: -- Procedure Clear_Dependent_Attr
70:
71: PROCEDURE Clear_Dependent_Attr
72: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
73: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
74: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
75: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
76: );
77:
70:
71: PROCEDURE Clear_Dependent_Attr
72: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
73: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
74: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
75: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
76: );
77:
78: -- Procedure Apply_Attribute_Changes
71: PROCEDURE Clear_Dependent_Attr
72: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
73: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
74: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
75: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
76: );
77:
78: -- Procedure Apply_Attribute_Changes
79:
77:
78: -- Procedure Apply_Attribute_Changes
79:
80: PROCEDURE Apply_Attribute_Changes
81: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
82: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
83: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
84: );
85:
78: -- Procedure Apply_Attribute_Changes
79:
80: PROCEDURE Apply_Attribute_Changes
81: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
82: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
83: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
84: );
85:
86: -- Procedure Complete_Record
79:
80: PROCEDURE Apply_Attribute_Changes
81: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
82: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
83: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
84: );
85:
86: -- Procedure Complete_Record
87:
85:
86: -- Procedure Complete_Record
87:
88: PROCEDURE Complete_Record
89: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
90: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
91: );
92:
93: -- Procedure Convert_Miss_To_Null
86: -- Procedure Complete_Record
87:
88: PROCEDURE Complete_Record
89: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
90: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
91: );
92:
93: -- Procedure Convert_Miss_To_Null
94:
92:
93: -- Procedure Convert_Miss_To_Null
94:
95: PROCEDURE Convert_Miss_To_Null
96: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
97: );
98:
99: -- Procedure Update_Row
100:
98:
99: -- Procedure Update_Row
100:
101: PROCEDURE Update_Row
102: ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
103: );
104:
105: -- Procedure Insert_Row
106:
104:
105: -- Procedure Insert_Row
106:
107: PROCEDURE Insert_Row
108: ( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
109: );
110:
111: -- Procedure Delete_Row
112:
120: -- Procedure Query_Row
121:
122: PROCEDURE Query_Row
123: ( p_sales_credit_id IN NUMBER
124: , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
125: );
126:
127: -- Procedure Query_Rows
128:
134: , p_line_id IN NUMBER :=
135: FND_API.G_MISS_NUM
136: , p_header_id IN NUMBER :=
137: FND_API.G_MISS_NUM
138: , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
139: );
140:
141: -- Procedure lock_Row
142: --
143:
144: PROCEDURE Lock_Row
145: ( x_return_status OUT NOCOPY VARCHAR2
146:
147: , p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
148: , p_sales_credit_id IN NUMBER
149: := FND_API.G_MISS_NUM
150: );
151:
153: ( p_sales_credit_id IN NUMBER :=
154: FND_API.G_MISS_NUM
155: , p_line_id IN NUMBER :=
156: FND_API.G_MISS_NUM
157: , x_line_scredit_tbl OUT NOCOPY OE_Order_PUB.Line_scredit_Tbl_Type
158: , x_return_status OUT NOCOPY VARCHAR2
159:
160: );
161:
161:
162: -- Function Get_Values
163:
164: FUNCTION Get_Values
165: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
166: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
167: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
168: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type;
169:
162: -- Function Get_Values
163:
164: FUNCTION Get_Values
165: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
166: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
167: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
168: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type;
169:
170: -- PROCEDURE Get_Ids
163:
164: FUNCTION Get_Values
165: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
166: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
167: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
168: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type;
169:
170: -- PROCEDURE Get_Ids
171:
164: FUNCTION Get_Values
165: ( p_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type
166: , p_old_Line_Scredit_rec IN OE_Order_PUB.Line_Scredit_Rec_Type :=
167: OE_Order_PUB.G_MISS_LINE_SCREDIT_REC
168: ) RETURN OE_Order_PUB.Line_Scredit_Val_Rec_Type;
169:
170: -- PROCEDURE Get_Ids
171:
172: PROCEDURE Get_Ids
169:
170: -- PROCEDURE Get_Ids
171:
172: PROCEDURE Get_Ids
173: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
174: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
175: );
176:
177: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
170: -- PROCEDURE Get_Ids
171:
172: PROCEDURE Get_Ids
173: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
174: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
175: );
176:
177: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
178: p_old_line_rec IN oe_order_pub.line_rec_type);
173: ( p_x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
174: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
175: );
176:
177: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
178: p_old_line_rec IN oe_order_pub.line_rec_type);
179:
180: PROCEDURE Pre_Write_Process
181: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
174: , p_Line_Scredit_val_rec IN OE_Order_PUB.Line_Scredit_Val_Rec_Type
175: );
176:
177: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
178: p_old_line_rec IN oe_order_pub.line_rec_type);
179:
180: PROCEDURE Pre_Write_Process
181: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
182: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
177: Procedure Create_credit(p_line_rec IN oe_order_pub.line_rec_type,
178: p_old_line_rec IN oe_order_pub.line_rec_type);
179:
180: PROCEDURE Pre_Write_Process
181: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
182: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
183: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC);
184:
185: END OE_Line_Scredit_Util;
178: p_old_line_rec IN oe_order_pub.line_rec_type);
179:
180: PROCEDURE Pre_Write_Process
181: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
182: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
183: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC);
184:
185: END OE_Line_Scredit_Util;
179:
180: PROCEDURE Pre_Write_Process
181: (p_x_line_scredit_rec IN OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_scredit_rec_type,
182: p_old_line_scredit_rec IN OE_ORDER_PUB.line_scredit_rec_type :=
183: OE_ORDER_PUB.G_MISS_LINE_SCREDIT_REC);
184:
185: END OE_Line_Scredit_Util;