58: -- Pre-Req : None
59: -- Parameters:
60: -- IN
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
66: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
59: -- Parameters:
60: -- IN
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
66: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
67: -- OUT
60: -- IN
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
66: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
67: -- OUT
68: -- x_REPAIR_LINE_ID OUT NOCOPY NUMBER
61: -- p_api_version_number IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
64: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
65: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
66: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
67: -- OUT
68: -- x_REPAIR_LINE_ID OUT NOCOPY NUMBER
69: -- x_REPAIR_NUMBER OUT NOCOPY VARCHAR2
81: -- for uniqueness and if valid, the same NUMBER will be returned.
82: --
83: PROCEDURE Create_Repair_Order(
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
86: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
87: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
88: p_REPAIR_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
89: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
82: --
83: PROCEDURE Create_Repair_Order(
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
86: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
87: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
88: p_REPAIR_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
89: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
90: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
83: PROCEDURE Create_Repair_Order(
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
86: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
87: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
88: p_REPAIR_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
89: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
90: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
91: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,
84: P_Api_Version_Number IN NUMBER,
85: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
86: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
87: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
88: p_REPAIR_LINE_ID IN NUMBER := Fnd_Api.G_MISS_NUM,
89: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
90: X_REPAIR_LINE_ID OUT NOCOPY NUMBER,
91: X_REPAIR_NUMBER OUT NOCOPY VARCHAR2,
92: X_Return_Status OUT NOCOPY VARCHAR2,
100: -- Pre-Req :
101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- p_REPAIR_LINE_ID IN NUMBER Required
108: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
101: -- Parameters:
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- p_REPAIR_LINE_ID IN NUMBER Required
108: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
109: --
102: -- IN
103: -- p_api_version_number IN NUMBER Required
104: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
105: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
107: -- p_REPAIR_LINE_ID IN NUMBER Required
108: -- P_REPLN_Rec IN CSD_REPAIRS_PUB.REPLN_Rec_Type Required
109: --
110: -- OUT
116: -- Initial Verision 1.0
117: --
118: PROCEDURE Update_Repair_Order(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
121: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
122: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
123: p_REPAIR_LINE_ID IN NUMBER,
124: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,
117: --
118: PROCEDURE Update_Repair_Order(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
121: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
122: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
123: p_REPAIR_LINE_ID IN NUMBER,
124: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,
125: X_Return_Status OUT NOCOPY VARCHAR2,
118: PROCEDURE Update_Repair_Order(
119: P_Api_Version_Number IN NUMBER,
120: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
121: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
122: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
123: p_REPAIR_LINE_ID IN NUMBER,
124: P_REPLN_Rec IN OUT NOCOPY Csd_Repairs_Pub.REPLN_Rec_Type,
125: X_Return_Status OUT NOCOPY VARCHAR2,
126: X_Msg_Count OUT NOCOPY NUMBER,
133: -- Pre-Req :
134: -- Parameters:
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_REPAIR_LINE_ID IN NUMBER Required
141: --
134: -- Parameters:
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_REPAIR_LINE_ID IN NUMBER Required
141: --
142: -- OUT
135: -- IN
136: -- p_api_version_number IN NUMBER Required
137: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
138: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
140: -- p_REPAIR_LINE_ID IN NUMBER Required
141: --
142: -- OUT
143: -- x_return_status OUT NOCOPY VARCHAR2
148: -- Initial Version 1.0
149: --
150: PROCEDURE Delete_Repair_Order(
151: P_Api_Version_Number IN NUMBER,
152: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
153: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
154: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
155: p_REPAIR_LINE_ID IN NUMBER,
156: X_Return_Status OUT NOCOPY VARCHAR2,
149: --
150: PROCEDURE Delete_Repair_Order(
151: P_Api_Version_Number IN NUMBER,
152: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
153: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
154: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
155: p_REPAIR_LINE_ID IN NUMBER,
156: X_Return_Status OUT NOCOPY VARCHAR2,
157: X_Msg_Count OUT NOCOPY NUMBER,
150: PROCEDURE Delete_Repair_Order(
151: P_Api_Version_Number IN NUMBER,
152: P_Init_Msg_List IN VARCHAR2 := Fnd_Api.G_FALSE,
153: P_Commit IN VARCHAR2 := Fnd_Api.G_FALSE,
154: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
155: p_REPAIR_LINE_ID IN NUMBER,
156: X_Return_Status OUT NOCOPY VARCHAR2,
157: X_Msg_Count OUT NOCOPY NUMBER,
158: X_Msg_Data OUT NOCOPY VARCHAR2
164: -- Pre-Req : None
165: -- Parameters:
166: -- IN
167: -- p_api_version_number IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170: -- P_Validation_mode IN VARCHAR2 Required
171: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
172: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
165: -- Parameters:
166: -- IN
167: -- p_api_version_number IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170: -- P_Validation_mode IN VARCHAR2 Required
171: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
172: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
173: -- OUT
167: -- p_api_version_number IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170: -- P_Validation_mode IN VARCHAR2 Required
171: -- p_REPAIR_LINE_ID IN NUMBER Optional Default = FND_API.G_MISS_NUM
172: -- p_REPLN_rec IN CSD_REPAIRS_PUB.REPLN_rec_type Required
173: -- OUT
174: -- x_return_status OUT NOCOPY VARCHAR2
175: -- x_msg_count OUT NOCOPY NUMBER
182: --
183: PROCEDURE Validate_Repairs
184: (
185: P_Api_Version_Number IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
187: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
188: P_Validation_mode IN VARCHAR2,
189: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
190: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
183: PROCEDURE Validate_Repairs
184: (
185: P_Api_Version_Number IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
187: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
188: P_Validation_mode IN VARCHAR2,
189: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
190: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
191: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,
185: P_Api_Version_Number IN NUMBER,
186: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
187: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
188: P_Validation_mode IN VARCHAR2,
189: p_repair_line_id IN NUMBER := Fnd_Api.G_MISS_NUM,
190: P_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type,
191: P_OLD_REPLN_Rec IN Csd_Repairs_Pub.REPLN_Rec_Type := Csd_Repairs_Pub.G_MISS_REPLN_Rec,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,