DBA Data[Home] [Help]

APPS.CSD_SOO_PVT dependencies on FND_API

Line 81: p_status_code in VARCHAR2 := fnd_api.g_miss_char,

77: /*--------------------------------------------------*/
78: Function Get_Document_Status
79: (
80: p_document_type in VARCHAR2,
81: p_status_code in VARCHAR2 := fnd_api.g_miss_char,
82: p_status_id in NUMBER := fnd_api.g_miss_num
83: ) RETURN VARCHAR2;
84:
85: /*--------------------------------------------------*/

Line 82: p_status_id in NUMBER := fnd_api.g_miss_num

78: Function Get_Document_Status
79: (
80: p_document_type in VARCHAR2,
81: p_status_code in VARCHAR2 := fnd_api.g_miss_char,
82: p_status_id in NUMBER := fnd_api.g_miss_num
83: ) RETURN VARCHAR2;
84:
85: /*--------------------------------------------------*/
86: /* procedure name: Get_Document_Status */

Line 93: p_status_code in VARCHAR2 := FND_API.G_MISS_CHAR,

89: /* either a document_id or */
90: /* document_code */
91: /*--------------------------------------------------*/
92: Procedure Get_Document_Status(p_document_type in VARCHAR2,
93: p_status_code in VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_status_id in NUMBER := FND_API.G_MISS_NUM,
95: x_status_name out NOCOPY VARCHAR2,
96: p_api_version IN NUMBER,
97: p_commit IN VARCHAR2,

Line 94: p_status_id in NUMBER := FND_API.G_MISS_NUM,

90: /* document_code */
91: /*--------------------------------------------------*/
92: Procedure Get_Document_Status(p_document_type in VARCHAR2,
93: p_status_code in VARCHAR2 := FND_API.G_MISS_CHAR,
94: p_status_id in NUMBER := FND_API.G_MISS_NUM,
95: x_status_name out NOCOPY VARCHAR2,
96: p_api_version IN NUMBER,
97: p_commit IN VARCHAR2,
98: p_init_msg_list IN VARCHAR2,

Line 118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,

114: p_validation_level IN NUMBER,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

118: p_wip_entity_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

119: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

120: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:

Line 125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

121: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
129:

Line 126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

122: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
129:
130: /*--------------------------------------------------*/

Line 127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

123: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
124: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
125: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
126: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
127: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
128:
129:
130: /*--------------------------------------------------*/
131: /* procedure name: Refresh_SR */

Line 143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,

139: p_validation_level IN NUMBER,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

143: p_incident_id IN NUMBER := FND_API.G_MISS_NUM,
144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

144: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

145: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:

Line 150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

146: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
154: /*--------------------------------------------------*/

Line 151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

147: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
154: /*--------------------------------------------------*/
155: /* procedure name: Refresh_SR_Task */

Line 152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

148: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
149: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
150: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
152: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
153:
154: /*--------------------------------------------------*/
155: /* procedure name: Refresh_SR_Task */
156: /* description : procedure to load or update */

Line 168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,

164: p_validation_level IN NUMBER,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

168: p_task_id IN NUMBER := FND_API.G_MISS_NUM,
169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

169: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

170: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:

Line 175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

171: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
179: /*--------------------------------------------------*/

Line 176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

172: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
179: /*--------------------------------------------------*/
180: /* procedure name: Refresh_Purchase_Req */

Line 177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

173: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
174: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
175: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
176: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
177: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
178:
179: /*--------------------------------------------------*/
180: /* procedure name: Refresh_Purchase_Req */
181: /* description : procedure to load or update */

Line 193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,

189: p_validation_level IN NUMBER,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

193: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

194: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

195: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:

Line 200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

196: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
204: /*--------------------------------------------------*/

Line 201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

197: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
204: /*--------------------------------------------------*/
205: /* procedure name: Refresh_Internal_Req */

Line 202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

198: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
199: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
200: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
201: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
202: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
203:
204: /*--------------------------------------------------*/
205: /* procedure name: Refresh_Internal_Req */
206: /* description : procedure to load or update */

Line 218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,

214: p_validation_level IN NUMBER,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

218: p_req_header_id IN NUMBER := FND_API.G_MISS_NUM,
219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

219: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

220: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:

Line 225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

221: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
229: /*--------------------------------------------------*/

Line 226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

222: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
229: /*--------------------------------------------------*/
230: /* procedure name: Refresh_Int_Sales_Order */

Line 227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

223: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
224: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
225: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
226: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
227: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
228:
229: /*--------------------------------------------------*/
230: /* procedure name: Refresh_Int_Sales_Order */
231: /* description : procedure to load or update */

Line 243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,

239: p_validation_level IN NUMBER,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

243: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

244: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

245: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:

Line 250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

246: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
254: /*--------------------------------------------------*/

Line 251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

247: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
254: /*--------------------------------------------------*/
255: /* procedure name: Refresh_RMA */

Line 252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

248: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
249: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
252: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
253:
254: /*--------------------------------------------------*/
255: /* procedure name: Refresh_RMA */
256: /* description : procedure to load or update */

Line 268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,

264: p_validation_level IN NUMBER,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

268: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

269: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

270: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:

Line 275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

271: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
279: /*--------------------------------------------------*/

Line 276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

272: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
279: /*--------------------------------------------------*/
280: /* procedure name: Refresh_RMA_Third_Party */

Line 277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

273: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
274: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
275: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
277: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
278:
279: /*--------------------------------------------------*/
280: /* procedure name: Refresh_RMA_Third_Party */
281: /* description : procedure to load or update */

Line 293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,

289: p_validation_level IN NUMBER,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

293: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

294: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

295: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:

Line 300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

296: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
304: /*--------------------------------------------------*/

Line 301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

297: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
304: /*--------------------------------------------------*/
305: /* procedure name: Refresh_Ship */

Line 302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

298: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
299: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
300: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
302: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
303:
304: /*--------------------------------------------------*/
305: /* procedure name: Refresh_Ship */
306: /* description : procedure to load or update */

Line 318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,

314: p_validation_level IN NUMBER,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

318: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

319: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

320: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:

Line 325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

321: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
329: /*--------------------------------------------------*/

Line 326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

322: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
329: /*--------------------------------------------------*/
330: /* procedure name: Refresh_Ship_Third_Party */

Line 327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

323: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
324: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
327: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
328:
329: /*--------------------------------------------------*/
330: /* procedure name: Refresh_Ship_Third_Party */
331: /* description : procedure to load or update */

Line 343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,

339: p_validation_level IN NUMBER,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

343: p_order_line_id IN NUMBER := FND_API.G_MISS_NUM,
344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

344: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

345: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:

Line 350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

346: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
354: /*--------------------------------------------------*/

Line 351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

347: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
354: /*--------------------------------------------------*/
355: /* procedure name: Refresh_Delivery */

Line 352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

348: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
350: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
351: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
352: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
353:
354: /*--------------------------------------------------*/
355: /* procedure name: Refresh_Delivery */
356: /* description : procedure to load or update */

Line 368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,

364: p_validation_level IN NUMBER,
365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

365: x_return_status OUT NOCOPY VARCHAR2,
366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

366: x_msg_count OUT NOCOPY NUMBER,
367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

367: x_msg_data OUT NOCOPY VARCHAR2,
368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

368: p_delivery_id IN NUMBER := FND_API.G_MISS_NUM,
369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

369: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

370: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:

Line 375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

371: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
379: /*--------------------------------------------------------------------------*/

Line 376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

372: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
379: /*--------------------------------------------------------------------------*/
380: /* procedure name: Refresh */

Line 377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

373: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
374: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
375: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
376: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
377: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
378:
379: /*--------------------------------------------------------------------------*/
380: /* procedure name: Refresh */
381: /* description : procedure to load or update */

Line 419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

415: x_return_status OUT NOCOPY VARCHAR2,
416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

416: x_msg_count OUT NOCOPY NUMBER,
417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

417: x_msg_data OUT NOCOPY VARCHAR2,
418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

418: p_so_orchestration_key_tbl IN so_orchestration_key_tbl_type,
419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

419: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

420: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

421: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:

Line 426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

422: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
430: /*--------------------------------------------------------------------------*/

Line 427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

423: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
430: /*--------------------------------------------------------------------------*/
431: /* procedure name: Soo_Bi_Driver_Main */

Line 428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

424: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
425: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
426: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
427: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
428: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
429:
430: /*--------------------------------------------------------------------------*/
431: /* procedure name: Soo_Bi_Driver_Main */
432: /* description : main procedure of */

Line 463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,

459: /*--------------------------------------------------------------------------*/
460:
461: PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

Line 464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

460:
461: PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

Line 465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,

461: PROCEDURE Soo_Driver_Main (errbuf OUT NOCOPY VARCHAR2,
462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

Line 466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,

462: retcode OUT NOCOPY VARCHAR2,
463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,

463: p_repair_line_id IN NUMBER := FND_API.G_MISS_NUM,
464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

Line 468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,

464: p_document_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

Line 469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,

465: p_operating_unit_id IN NUMBER := FND_API.G_MISS_NUM,
466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:

Line 470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

466: p_inventory_org_id IN NUMBER := FND_API.G_MISS_NUM,
467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
474: END CSD_SOO_PVT;

Line 471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,

467: p_repair_owner_id IN NUMBER := FND_API.G_MISS_NUM,
468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
474: END CSD_SOO_PVT;

Line 472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);

468: p_ro_status_id IN NUMBER := FND_API.G_MISS_NUM,
469: p_repair_type_id IN NUMBER := FND_API.G_MISS_NUM,
470: p_ro_priority_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
471: p_ro_age IN NUMBER := FND_API.G_MISS_NUM,
472: p_ro_due_date_age IN NUMBER := FND_API.G_MISS_NUM);
473:
474: END CSD_SOO_PVT;