[Home] [Help]
71:
72: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
73: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
74:
75: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
76: l_msg_count NUMBER := 0;
77: l_msg_data VARCHAR2(2000);
78: l_index NUMBER := 1;
79:
92: -- Standard Start of API savepoint
93: SAVEPOINT Create_ServiceRequest_Wrap;
94:
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
97: p_api_version,
98: l_api_name,
99: G_PKG_NAME)
100: THEN
98: l_api_name,
99: G_PKG_NAME)
100: THEN
101:
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105:
106: -- Initialize message list if p_init_msg_list is set to TRUE.
103: END IF;
104:
105:
106: -- Initialize message list if p_init_msg_list is set to TRUE.
107: IF FND_API.to_Boolean( p_init_msg_list )
108: THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111:
305: x_group_owner => l_group_owner,
306: x_individual_type => l_individual_type
307: );
308:
309: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
310: raise IEM_SERVICEREQUEST_NOT_CREATE;
311: end if;
312:
313: x_return_status := l_return_status ;
312:
313: x_return_status := l_return_status ;
314:
315: --Standard check of p_commit
316: IF FND_API.to_Boolean(p_commit) THEN
317: COMMIT WORK;
318: END IF;
319:
320: EXCEPTION
322: ROLLBACK TO Create_ServiceRequest_Wrap;
323: x_return_status := l_return_status ;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325:
326: WHEN FND_API.G_EXC_ERROR THEN
327: ROLLBACK TO Create_ServiceRequest_Wrap;
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,p_data => x_msg_data);
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325:
326: WHEN FND_API.G_EXC_ERROR THEN
327: ROLLBACK TO Create_ServiceRequest_Wrap;
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,p_data => x_msg_data);
331:
332:
329: FND_MSG_PUB.Count_And_Get
330: ( p_count => x_msg_count,p_data => x_msg_data);
331:
332:
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: ROLLBACK TO Create_ServiceRequest_Wrap;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
337:
331:
332:
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: ROLLBACK TO Create_ServiceRequest_Wrap;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
337:
338: WHEN OTHERS THEN
339: ROLLBACK TO Create_ServiceRequest_Wrap;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
337:
338: WHEN OTHERS THEN
339: ROLLBACK TO Create_ServiceRequest_Wrap;
340: x_return_status := FND_API.G_RET_STS_ERROR;
341:
342: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
344: END IF;
364: p_last_update_date IN DATE,
365: p_service_request_rec IN service_request_rec_type,
366: p_notes IN notes_table,
367: p_contacts IN contacts_table,
368: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
369: p_workflow_process_id IN NUMBER := NULL,
370: x_workflow_process_id OUT NOCOPY NUMBER,
371: x_interaction_id OUT NOCOPY NUMBER
372: )
383:
384: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
385: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
386:
387: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
388: l_msg_count NUMBER := 0;
389: l_msg_data VARCHAR2(2000);
390: l_index NUMBER := 1;
391:
398: BEGIN
399: -- Standard Start of API savepoint
400: SAVEPOINT Update_ServiceRequest_Wrap;
401: -- Standard call to check for call compatibility.
402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
403: p_api_version,
404: l_api_name,
405: G_PKG_NAME)
406: THEN
404: l_api_name,
405: G_PKG_NAME)
406: THEN
407:
408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
409: END IF;
410:
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
409: END IF;
410:
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF FND_API.to_Boolean( p_init_msg_list )
414: THEN
415: FND_MSG_PUB.initialize;
416: END IF;
417:
607: x_workflow_process_id => x_workflow_process_id,
608: x_interaction_id => x_interaction_id );
609:
610:
611: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
612: raise IEM_SERVICEREQUEST_NOT_UPDATED;
613: end if;
614:
615: x_return_status := l_return_status ;
613: end if;
614:
615: x_return_status := l_return_status ;
616: --Standard check of p_commit
617: IF FND_API.to_Boolean(p_commit) THEN
618: COMMIT WORK;
619: END IF;
620:
621: EXCEPTION
623: ROLLBACK TO Update_ServiceRequest_Wrap;
624: x_return_status := l_return_status ;
625: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
626:
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO Update_ServiceRequest_Wrap;
629: x_return_status := FND_API.G_RET_STS_ERROR ;
630: FND_MSG_PUB.Count_And_Get
631: ( p_count => x_msg_count,p_data => x_msg_data);
625: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
626:
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO Update_ServiceRequest_Wrap;
629: x_return_status := FND_API.G_RET_STS_ERROR ;
630: FND_MSG_PUB.Count_And_Get
631: ( p_count => x_msg_count,p_data => x_msg_data);
632:
633:
630: FND_MSG_PUB.Count_And_Get
631: ( p_count => x_msg_count,p_data => x_msg_data);
632:
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: ROLLBACK TO Update_ServiceRequest_Wrap;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
638:
632:
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: ROLLBACK TO Update_ServiceRequest_Wrap;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
638:
639: WHEN OTHERS THEN
640: ROLLBACK TO Update_ServiceRequest_Wrap;
637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
638:
639: WHEN OTHERS THEN
640: ROLLBACK TO Update_ServiceRequest_Wrap;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642:
643: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
644: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
645: END IF;
651: PROCEDURE initialize_rec(
652: p_sr_record IN OUT NOCOPY service_request_rec_type
653: ) AS
654: BEGIN
655: p_sr_record.request_date := FND_API.G_MISS_DATE;
656: p_sr_record.type_id := FND_API.G_MISS_NUM;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
652: p_sr_record IN OUT NOCOPY service_request_rec_type
653: ) AS
654: BEGIN
655: p_sr_record.request_date := FND_API.G_MISS_DATE;
656: p_sr_record.type_id := FND_API.G_MISS_NUM;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
653: ) AS
654: BEGIN
655: p_sr_record.request_date := FND_API.G_MISS_DATE;
656: p_sr_record.type_id := FND_API.G_MISS_NUM;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
654: BEGIN
655: p_sr_record.request_date := FND_API.G_MISS_DATE;
656: p_sr_record.type_id := FND_API.G_MISS_NUM;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
655: p_sr_record.request_date := FND_API.G_MISS_DATE;
656: p_sr_record.type_id := FND_API.G_MISS_NUM;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
656: p_sr_record.type_id := FND_API.G_MISS_NUM;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
657: p_sr_record.type_name := FND_API.G_MISS_CHAR;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
658: p_sr_record.status_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
659: p_sr_record.status_name := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
660: p_sr_record.severity_id := FND_API.G_MISS_NUM;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
661: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
662: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
663: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
664: p_sr_record.closed_date := FND_API.G_MISS_DATE;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
665: p_sr_record.owner_id := FND_API.G_MISS_NUM;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
666: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
667: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
668: p_sr_record.summary := FND_API.G_MISS_CHAR;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
669: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
670: p_sr_record.customer_id := FND_API.G_MISS_NUM;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
671: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
672: p_sr_record.employee_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
673: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
674: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
675: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
676: p_sr_record.platform_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
677: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
678: p_sr_record.db_version := FND_API.G_MISS_CHAR;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
679: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
680: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
681: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
682: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
683: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
684: p_sr_record.language_id := FND_API.G_MISS_NUM;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
685: p_sr_record.language := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
686: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
687: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
688: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
689: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
690: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
691: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
692: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
702: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
703: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
706: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
708: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
709: p_sr_record.inventory_item_vals_or_ids := 'V';
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
711: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
712: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
713: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
714: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
715: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
716: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
717: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
718: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
719: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
720: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
721: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
722: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
726: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
727: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
728: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
729: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
731: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
732: p_sr_record.request_context := FND_API.G_MISS_CHAR;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
733: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
734: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
735: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
736: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
737: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
738: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
739: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
740: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
741: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
742: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
743: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
744: --p_sr_record.account_id := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
745: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
746: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
747: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
748: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
749: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
750: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
751: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
752: p_sr_record.time_difference := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
753: p_sr_record.site_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
754: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
755: p_sr_record.territory_id := FND_API.G_MISS_NUM;
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
756: p_sr_record.initialize_flag := G_INITIALIZED;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
757: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
758: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
759: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
760: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
761: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
762: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
763: -- Fix for Bug# 2155981
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
764: p_sr_record.project_number := FND_API.G_MISS_CHAR;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
765: -----jngeorge-----enhancements-----11.5.6-----07/12/01
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
766: p_sr_record.tier := FND_API.G_MISS_CHAR;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
767: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
768: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
769: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
770: p_sr_record.database := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
771: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
772: p_sr_record.category_id := FND_API.G_MISS_NUM;
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
780: --- Added for Post 11.5.6 Enhancements
773: p_sr_record.group_type := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
780: --- Added for Post 11.5.6 Enhancements
781: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
774: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
780: --- Added for Post 11.5.6 Enhancements
781: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
782: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
775: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
776: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
780: --- Added for Post 11.5.6 Enhancements
781: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
782: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
783: -------jngeorge----07/12/01
777: p_sr_record.component_version := FND_API.G_MISS_CHAR;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
780: --- Added for Post 11.5.6 Enhancements
781: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
782: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
783: -------jngeorge----07/12/01
784:
785: END initialize_rec;
778: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
779: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
780: --- Added for Post 11.5.6 Enhancements
781: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
782: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
783: -------jngeorge----07/12/01
784:
785: END initialize_rec;
786:
785: END initialize_rec;
786:
787: PROCEDURE Update_Status_Wrap
788: ( p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
791: x_return_status OUT NOCOPY VARCHAR2,
792: x_msg_count OUT NOCOPY NUMBER,
793: x_msg_data OUT NOCOPY VARCHAR2,
786:
787: PROCEDURE Update_Status_Wrap
788: ( p_api_version IN NUMBER,
789: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
790: p_commit IN VARCHAR2 := FND_API.G_FALSE,
791: x_return_status OUT NOCOPY VARCHAR2,
792: x_msg_count OUT NOCOPY NUMBER,
793: x_msg_data OUT NOCOPY VARCHAR2,
794: p_resp_appl_id IN NUMBER := NULL,
793: x_msg_data OUT NOCOPY VARCHAR2,
794: p_resp_appl_id IN NUMBER := NULL,
795: p_resp_id IN NUMBER := NULL,
796: p_user_id IN NUMBER := NULL,
797: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
798: p_request_id IN NUMBER := NULL,
799: p_request_number IN VARCHAR2 := NULL,
800: p_object_version_number IN NUMBER,
801: p_status_id IN NUMBER := NULL,
799: p_request_number IN VARCHAR2 := NULL,
800: p_object_version_number IN NUMBER,
801: p_status_id IN NUMBER := NULL,
802: p_status IN VARCHAR2 := NULL,
803: p_closed_date IN DATE := FND_API.G_MISS_DATE,
804: p_audit_comments IN VARCHAR2 := NULL,
805: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
806: p_workflow_process_id IN NUMBER := NULL,
807: p_comments IN VARCHAR2 := NULL,
801: p_status_id IN NUMBER := NULL,
802: p_status IN VARCHAR2 := NULL,
803: p_closed_date IN DATE := FND_API.G_MISS_DATE,
804: p_audit_comments IN VARCHAR2 := NULL,
805: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
806: p_workflow_process_id IN NUMBER := NULL,
807: p_comments IN VARCHAR2 := NULL,
808: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
809: x_interaction_id OUT NOCOPY NUMBER
804: p_audit_comments IN VARCHAR2 := NULL,
805: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
806: p_workflow_process_id IN NUMBER := NULL,
807: p_comments IN VARCHAR2 := NULL,
808: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
809: x_interaction_id OUT NOCOPY NUMBER
810: )
811: IS
812:
813: l_api_name VARCHAR2(255):='Update_Status_Wrap';
814: l_api_version_number NUMBER:= 2.0;
815: l_cs_version_number NUMBER:= 2.0;
816:
817: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
818: l_msg_count NUMBER := 0;
819: l_msg_data VARCHAR2(2000);
820: l_index NUMBER := 1;
821:
821:
822: l_resp_appl_id NUMBER := NULL;
823: l_resp_id NUMBER := NULL;
824: l_user_id NUMBER := NULL;
825: l_login_id NUMBER := FND_API.G_MISS_NUM;
826: l_request_id NUMBER := NULL;
827: l_request_number VARCHAR2(256) := null;
828: l_object_version_number NUMBER;
829: l_status_id NUMBER := NULL;
827: l_request_number VARCHAR2(256) := null;
828: l_object_version_number NUMBER;
829: l_status_id NUMBER := NULL;
830: l_status VARCHAR2(30) := NULL;
831: l_closed_date DATE := FND_API.G_MISS_DATE;
832: l_audit_comments VARCHAR2(2000) := NULL;
833: l_called_by_workflow VARCHAR2(1):= FND_API.G_FALSE;
834: l_workflow_process_id NUMBER := NULL;
835: l_comments VARCHAR2(2000) := NULL;
829: l_status_id NUMBER := NULL;
830: l_status VARCHAR2(30) := NULL;
831: l_closed_date DATE := FND_API.G_MISS_DATE;
832: l_audit_comments VARCHAR2(2000) := NULL;
833: l_called_by_workflow VARCHAR2(1):= FND_API.G_FALSE;
834: l_workflow_process_id NUMBER := NULL;
835: l_comments VARCHAR2(2000) := NULL;
836: l_public_comment_flag VARCHAR2(1):= FND_API.G_FALSE;
837: l_interaction_id NUMBER;
832: l_audit_comments VARCHAR2(2000) := NULL;
833: l_called_by_workflow VARCHAR2(1):= FND_API.G_FALSE;
834: l_workflow_process_id NUMBER := NULL;
835: l_comments VARCHAR2(2000) := NULL;
836: l_public_comment_flag VARCHAR2(1):= FND_API.G_FALSE;
837: l_interaction_id NUMBER;
838:
839: IEM_UPDATE_SR_STATUS_FAIL EXCEPTION;
840:
842: -- Standard Start of API savepoint
843: SAVEPOINT Update_Status_Wrap;
844:
845: -- Standard call to check for call compatibility.
846: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
847: p_api_version,
848: l_api_name,
849: G_PKG_NAME)
850: THEN
848: l_api_name,
849: G_PKG_NAME)
850: THEN
851:
852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
853: END IF;
854:
855:
856: -- Initialize message list if p_init_msg_list is set to TRUE.
853: END IF;
854:
855:
856: -- Initialize message list if p_init_msg_list is set to TRUE.
857: IF FND_API.to_Boolean( p_init_msg_list )
858: THEN
859: FND_MSG_PUB.initialize;
860: END IF;
861:
905: );
906:
907: l_interaction_id := x_interaction_id;
908:
909: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
910: raise IEM_UPDATE_SR_STATUS_FAIL;
911: end if;
912:
913: x_return_status := l_return_status ;
912:
913: x_return_status := l_return_status ;
914:
915: --Standard check of p_commit
916: IF FND_API.to_Boolean(p_commit) THEN
917: COMMIT WORK;
918: END IF;
919:
920: EXCEPTION
922: ROLLBACK TO Update_Status_Wrap;
923: x_return_status := l_return_status ;
924: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
925:
926: WHEN FND_API.G_EXC_ERROR THEN
927: ROLLBACK TO Update_Status_Wrap;
928: x_return_status := FND_API.G_RET_STS_ERROR ;
929: FND_MSG_PUB.Count_And_Get
930: ( p_count => x_msg_count,p_data => x_msg_data);
924: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
925:
926: WHEN FND_API.G_EXC_ERROR THEN
927: ROLLBACK TO Update_Status_Wrap;
928: x_return_status := FND_API.G_RET_STS_ERROR ;
929: FND_MSG_PUB.Count_And_Get
930: ( p_count => x_msg_count,p_data => x_msg_data);
931:
932:
929: FND_MSG_PUB.Count_And_Get
930: ( p_count => x_msg_count,p_data => x_msg_data);
931:
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: ROLLBACK TO Update_Status_Wrap;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
937:
931:
932:
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: ROLLBACK TO Update_Status_Wrap;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
937:
938: WHEN OTHERS THEN
939: ROLLBACK TO Update_Status_Wrap;
936: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
937:
938: WHEN OTHERS THEN
939: ROLLBACK TO Update_Status_Wrap;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941:
942: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
943: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
944: END IF;
952: -------------------------------------------------------------------------------
953:
954: PROCEDURE IEM_CREATE_SR
955: ( p_api_version IN NUMBER,
956: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
957: p_commit IN VARCHAR2 := FND_API.G_FALSE,
958: p_message_id IN NUMBER,
959: p_note IN VARCHAR2,
960: p_party_id IN NUMBER,
953:
954: PROCEDURE IEM_CREATE_SR
955: ( p_api_version IN NUMBER,
956: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
957: p_commit IN VARCHAR2 := FND_API.G_FALSE,
958: p_message_id IN NUMBER,
959: p_note IN VARCHAR2,
960: p_party_id IN NUMBER,
961: p_sr_type_id IN NUMBER,
974: l_api_name VARCHAR2(255):='IEM_CREATE_SR';
975: l_api_version_number NUMBER:=1.0;
976: l_cs_version_number NUMBER:=4.0;
977:
978: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
979: l_msg_count NUMBER := 0;
980: l_msg_data VARCHAR2(2000);
981: l_index NUMBER := 1;
982:
1013: -- Standard Start of API savepoint
1014: SAVEPOINT IEM_CREATE_SR;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1018: p_api_version,
1019: l_api_name,
1020: G_PKG_NAME)
1021: THEN
1018: p_api_version,
1019: l_api_name,
1020: G_PKG_NAME)
1021: THEN
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )
1027: THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:
1045: OPEN caller_type;
1046: FETCH caller_type INTO l_party_type;
1047:
1048: IF (caller_type%NOTFOUND) THEN
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: CLOSE caller_type;
1051: END IF;
1052:
1053: CLOSE caller_type;
1090:
1091:
1092: CS_ServiceRequest_PUB.Create_ServiceRequest (
1093: p_api_version => l_cs_version_number,
1094: p_init_msg_list => FND_API.G_FALSE,
1095: p_commit => FND_API.G_FALSE,
1096: x_return_status => l_return_status,
1097: x_msg_count => l_msg_count,
1098: x_msg_data => l_msg_data,
1091:
1092: CS_ServiceRequest_PUB.Create_ServiceRequest (
1093: p_api_version => l_cs_version_number,
1094: p_init_msg_list => FND_API.G_FALSE,
1095: p_commit => FND_API.G_FALSE,
1096: x_return_status => l_return_status,
1097: x_msg_count => l_msg_count,
1098: x_msg_data => l_msg_data,
1099: p_resp_appl_id => NULL,
1112: p_default_contract_sla_ind => 'Y',
1113: p_default_coverage_template_id => l_coverage_template_id
1114: );
1115:
1116: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1117: raise IEM_SR_NOT_CREATE;
1118: end if;
1119:
1120: x_return_status := l_return_status ;
1120: x_return_status := l_return_status ;
1121: x_request_id := l_sr_create_out_rec.request_id;
1122:
1123: --Standard check of p_commit
1124: IF FND_API.to_Boolean(p_commit) THEN
1125: COMMIT WORK;
1126: END IF;
1127:
1128: EXCEPTION
1130: ROLLBACK TO IEM_CREATE_SR;
1131: x_return_status := l_return_status ;
1132: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1133:
1134: WHEN FND_API.G_EXC_ERROR THEN
1135: ROLLBACK TO IEM_CREATE_SR;
1136: x_return_status := FND_API.G_RET_STS_ERROR ;
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_count => x_msg_count,p_data => x_msg_data);
1132: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1133:
1134: WHEN FND_API.G_EXC_ERROR THEN
1135: ROLLBACK TO IEM_CREATE_SR;
1136: x_return_status := FND_API.G_RET_STS_ERROR ;
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_count => x_msg_count,p_data => x_msg_data);
1139:
1140:
1137: FND_MSG_PUB.Count_And_Get
1138: ( p_count => x_msg_count,p_data => x_msg_data);
1139:
1140:
1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1142: ROLLBACK TO IEM_CREATE_SR;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1145:
1139:
1140:
1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1142: ROLLBACK TO IEM_CREATE_SR;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1145:
1146: WHEN OTHERS THEN
1147: ROLLBACK TO IEM_CREATE_SR;
1144: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1145:
1146: WHEN OTHERS THEN
1147: ROLLBACK TO IEM_CREATE_SR;
1148: x_return_status := FND_API.G_RET_STS_ERROR;
1149:
1150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1151: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1152: END IF;