[Home] [Help]
77:
78: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
79: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
80:
81: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
82: l_msg_count NUMBER := 0;
83: l_msg_data VARCHAR2(2000);
84: l_index NUMBER := 1;
85:
98: -- Standard Start of API savepoint
99: SAVEPOINT Create_ServiceRequest_Wrap;
100:
101: -- Standard call to check for call compatibility.
102: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
103: p_api_version,
104: l_api_name,
105: G_PKG_NAME)
106: THEN
104: l_api_name,
105: G_PKG_NAME)
106: THEN
107:
108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
109: END IF;
110:
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list )
114: THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
311: x_group_owner => l_group_owner,
312: x_individual_type => l_individual_type
313: );
314:
315: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
316: raise IEM_SERVICEREQUEST_NOT_CREATE;
317: end if;
318:
319: x_return_status := l_return_status ;
318:
319: x_return_status := l_return_status ;
320:
321: --Standard check of p_commit
322: IF FND_API.to_Boolean(p_commit) THEN
323: COMMIT WORK;
324: END IF;
325:
326: EXCEPTION
328: ROLLBACK TO Create_ServiceRequest_Wrap;
329: x_return_status := l_return_status ;
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO Create_ServiceRequest_Wrap;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,p_data => x_msg_data);
330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
331:
332: WHEN FND_API.G_EXC_ERROR THEN
333: ROLLBACK TO Create_ServiceRequest_Wrap;
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,p_data => x_msg_data);
337:
338:
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,p_data => x_msg_data);
337:
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO Create_ServiceRequest_Wrap;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
343:
337:
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO Create_ServiceRequest_Wrap;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
343:
344: WHEN OTHERS THEN
345: ROLLBACK TO Create_ServiceRequest_Wrap;
342: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
343:
344: WHEN OTHERS THEN
345: ROLLBACK TO Create_ServiceRequest_Wrap;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347:
348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
350: END IF;
370: p_last_update_date IN DATE,
371: p_service_request_rec IN service_request_rec_type,
372: p_notes IN notes_table,
373: p_contacts IN contacts_table,
374: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
375: p_workflow_process_id IN NUMBER := NULL,
376: x_workflow_process_id OUT NOCOPY NUMBER,
377: x_interaction_id OUT NOCOPY NUMBER
378: )
389:
390: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
391: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
392:
393: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
394: l_msg_count NUMBER := 0;
395: l_msg_data VARCHAR2(2000);
396: l_index NUMBER := 1;
397:
404: BEGIN
405: -- Standard Start of API savepoint
406: SAVEPOINT Update_ServiceRequest_Wrap;
407: -- Standard call to check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
409: p_api_version,
410: l_api_name,
411: G_PKG_NAME)
412: THEN
410: l_api_name,
411: G_PKG_NAME)
412: THEN
413:
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
415: END IF;
416:
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list )
420: THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:
613: x_workflow_process_id => x_workflow_process_id,
614: x_interaction_id => x_interaction_id );
615:
616:
617: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
618: raise IEM_SERVICEREQUEST_NOT_UPDATED;
619: end if;
620:
621: x_return_status := l_return_status ;
619: end if;
620:
621: x_return_status := l_return_status ;
622: --Standard check of p_commit
623: IF FND_API.to_Boolean(p_commit) THEN
624: COMMIT WORK;
625: END IF;
626:
627: EXCEPTION
629: ROLLBACK TO Update_ServiceRequest_Wrap;
630: x_return_status := l_return_status ;
631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
632:
633: WHEN FND_API.G_EXC_ERROR THEN
634: ROLLBACK TO Update_ServiceRequest_Wrap;
635: x_return_status := FND_API.G_RET_STS_ERROR ;
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,p_data => x_msg_data);
631: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
632:
633: WHEN FND_API.G_EXC_ERROR THEN
634: ROLLBACK TO Update_ServiceRequest_Wrap;
635: x_return_status := FND_API.G_RET_STS_ERROR ;
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,p_data => x_msg_data);
638:
639:
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,p_data => x_msg_data);
638:
639:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641: ROLLBACK TO Update_ServiceRequest_Wrap;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
643: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
644:
638:
639:
640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
641: ROLLBACK TO Update_ServiceRequest_Wrap;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
643: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
644:
645: WHEN OTHERS THEN
646: ROLLBACK TO Update_ServiceRequest_Wrap;
643: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
644:
645: WHEN OTHERS THEN
646: ROLLBACK TO Update_ServiceRequest_Wrap;
647: x_return_status := FND_API.G_RET_STS_ERROR;
648:
649: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
651: END IF;
657: PROCEDURE initialize_rec(
658: p_sr_record IN OUT NOCOPY service_request_rec_type
659: ) AS
660: BEGIN
661: p_sr_record.request_date := FND_API.G_MISS_DATE;
662: p_sr_record.type_id := FND_API.G_MISS_NUM;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
658: p_sr_record IN OUT NOCOPY service_request_rec_type
659: ) AS
660: BEGIN
661: p_sr_record.request_date := FND_API.G_MISS_DATE;
662: p_sr_record.type_id := FND_API.G_MISS_NUM;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
659: ) AS
660: BEGIN
661: p_sr_record.request_date := FND_API.G_MISS_DATE;
662: p_sr_record.type_id := FND_API.G_MISS_NUM;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
660: BEGIN
661: p_sr_record.request_date := FND_API.G_MISS_DATE;
662: p_sr_record.type_id := FND_API.G_MISS_NUM;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
661: p_sr_record.request_date := FND_API.G_MISS_DATE;
662: p_sr_record.type_id := FND_API.G_MISS_NUM;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
662: p_sr_record.type_id := FND_API.G_MISS_NUM;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
663: p_sr_record.type_name := FND_API.G_MISS_CHAR;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
664: p_sr_record.status_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
665: p_sr_record.status_name := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
666: p_sr_record.severity_id := FND_API.G_MISS_NUM;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
667: p_sr_record.severity_name := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
668: p_sr_record.urgency_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
669: p_sr_record.urgency_name := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
670: p_sr_record.closed_date := FND_API.G_MISS_DATE;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
671: p_sr_record.owner_id := FND_API.G_MISS_NUM;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
672: p_sr_record.owner_group_id := FND_API.G_MISS_NUM;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
673: p_sr_record.publish_flag := FND_API.G_MISS_CHAR;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
674: p_sr_record.summary := FND_API.G_MISS_CHAR;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
675: p_sr_record.caller_type := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
676: p_sr_record.customer_id := FND_API.G_MISS_NUM;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
677: p_sr_record.customer_number := FND_API.G_MISS_CHAR;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
678: p_sr_record.employee_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
679: p_sr_record.employee_number := FND_API.G_MISS_CHAR;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
680: p_sr_record.verify_cp_flag := FND_API.G_MISS_CHAR;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
681: p_sr_record.customer_product_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
682: p_sr_record.platform_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
683: p_sr_record.platform_version := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
684: p_sr_record.db_version := FND_API.G_MISS_CHAR;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
685: p_sr_record.platform_version_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
686: p_sr_record.cp_component_id := FND_API.G_MISS_NUM;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
687: p_sr_record.cp_component_version_id := FND_API.G_MISS_NUM;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
688: p_sr_record.cp_subcomponent_id := FND_API.G_MISS_NUM;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
689: p_sr_record.cp_subcomponent_version_id := FND_API.G_MISS_NUM;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
690: p_sr_record.language_id := FND_API.G_MISS_NUM;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
691: p_sr_record.language := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
692: p_sr_record.cp_ref_number := FND_API.G_MISS_NUM;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
693: p_sr_record.inventory_item_id := FND_API.G_MISS_NUM;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
694: p_sr_record.inventory_item_conc_segs := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
695: p_sr_record.inventory_item_segment1 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
696: p_sr_record.inventory_item_segment2 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
697: p_sr_record.inventory_item_segment3 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
698: p_sr_record.inventory_item_segment4 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
699: p_sr_record.inventory_item_segment5 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
700: p_sr_record.inventory_item_segment6 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
701: p_sr_record.inventory_item_segment7 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
702: p_sr_record.inventory_item_segment8 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
703: p_sr_record.inventory_item_segment9 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
704: p_sr_record.inventory_item_segment10 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
705: p_sr_record.inventory_item_segment11 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
706: p_sr_record.inventory_item_segment12 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
707: p_sr_record.inventory_item_segment13 := FND_API.G_MISS_CHAR;
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
708: p_sr_record.inventory_item_segment14 := FND_API.G_MISS_CHAR;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
709: p_sr_record.inventory_item_segment15 := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
710: p_sr_record.inventory_item_segment16 := FND_API.G_MISS_CHAR;
711: p_sr_record.inventory_item_segment17 := FND_API.G_MISS_CHAR;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
712: p_sr_record.inventory_item_segment18 := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
713: p_sr_record.inventory_item_segment19 := FND_API.G_MISS_CHAR;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
714: p_sr_record.inventory_item_segment20 := FND_API.G_MISS_CHAR;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
715: p_sr_record.inventory_item_vals_or_ids := 'V';
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
716: p_sr_record.inventory_org_id := FND_API.G_MISS_NUM;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
717: p_sr_record.current_serial_number := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
718: p_sr_record.original_order_number := FND_API.G_MISS_NUM;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
719: p_sr_record.purchase_order_num := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
720: p_sr_record.problem_code := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
721: p_sr_record.exp_resolution_date := FND_API.G_MISS_DATE;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
722: p_sr_record.install_site_use_id := FND_API.G_MISS_NUM;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
723: p_sr_record.request_attribute_1 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
724: p_sr_record.request_attribute_2 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
725: p_sr_record.request_attribute_3 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
726: p_sr_record.request_attribute_4 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
727: p_sr_record.request_attribute_5 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
728: p_sr_record.request_attribute_6 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
729: p_sr_record.request_attribute_7 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
730: p_sr_record.request_attribute_8 := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
731: p_sr_record.request_attribute_9 := FND_API.G_MISS_CHAR;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
732: p_sr_record.request_attribute_10 := FND_API.G_MISS_CHAR;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
733: p_sr_record.request_attribute_11 := FND_API.G_MISS_CHAR;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
734: p_sr_record.request_attribute_12 := FND_API.G_MISS_CHAR;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
735: p_sr_record.request_attribute_13 := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
736: p_sr_record.request_attribute_14 := FND_API.G_MISS_CHAR;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
737: p_sr_record.request_attribute_15 := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
738: p_sr_record.request_context := FND_API.G_MISS_CHAR;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
739: p_sr_record.bill_to_site_use_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
740: p_sr_record.bill_to_contact_id := FND_API.G_MISS_NUM;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
741: p_sr_record.ship_to_site_use_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
742: p_sr_record.ship_to_contact_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
743: p_sr_record.resolution_code := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
744: p_sr_record.act_resolution_date := FND_API.G_MISS_DATE;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
745: p_sr_record.public_comment_flag := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
746: p_sr_record.parent_interaction_id := FND_API.G_MISS_NUM;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
747: p_sr_record.contract_service_id := FND_API.G_MISS_NUM;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
748: p_sr_record.contract_service_number := FND_API.G_MISS_CHAR;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
749: p_sr_record.qa_collection_plan_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
750: --p_sr_record.account_id := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
751: p_sr_record.resource_type := FND_API.G_MISS_CHAR;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
752: p_sr_record.resource_subtype_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
753: p_sr_record.cust_po_number := FND_API.G_MISS_CHAR;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
754: p_sr_record.cust_ticket_number := FND_API.G_MISS_CHAR;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
755: p_sr_record.sr_creation_channel := FND_API.G_MISS_CHAR;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
756: p_sr_record.obligation_date := FND_API.G_MISS_DATE;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
757: p_sr_record.time_zone_id := FND_API.G_MISS_NUM;
758: p_sr_record.time_difference := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
759: p_sr_record.site_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
760: p_sr_record.customer_site_id := FND_API.G_MISS_NUM;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
761: p_sr_record.territory_id := FND_API.G_MISS_NUM;
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
762: p_sr_record.initialize_flag := G_INITIALIZED;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
763: p_sr_record.cp_revision_id := FND_API.G_MISS_NUM;
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
764: p_sr_record.inv_item_revision := FND_API.G_MISS_CHAR;
765: p_sr_record.inv_component_id := FND_API.G_MISS_NUM;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
766: p_sr_record.inv_component_version := FND_API.G_MISS_CHAR;
767: p_sr_record.inv_subcomponent_id := FND_API.G_MISS_NUM;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
768: p_sr_record.inv_subcomponent_version := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
769: -- Fix for Bug# 2155981
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
770: p_sr_record.project_number := FND_API.G_MISS_CHAR;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
771: -----jngeorge-----enhancements-----11.5.6-----07/12/01
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
772: p_sr_record.tier := FND_API.G_MISS_CHAR;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
773: p_sr_record.tier_version := FND_API.G_MISS_CHAR;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
774: p_sr_record.operating_system := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
775: p_sr_record.operating_system_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
776: p_sr_record.database := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
777: p_sr_record.cust_pref_lang_id := FND_API.G_MISS_NUM;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
778: p_sr_record.category_id := FND_API.G_MISS_NUM;
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
786: --- Added for Post 11.5.6 Enhancements
779: p_sr_record.group_type := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
786: --- Added for Post 11.5.6 Enhancements
787: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
780: p_sr_record.group_territory_id := FND_API.G_MISS_NUM;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
786: --- Added for Post 11.5.6 Enhancements
787: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
788: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
781: p_sr_record.inv_platform_org_id := FND_API.G_MISS_NUM;
782: p_sr_record.product_revision := FND_API.G_MISS_CHAR;
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
786: --- Added for Post 11.5.6 Enhancements
787: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
788: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
789: -------jngeorge----07/12/01
783: p_sr_record.component_version := FND_API.G_MISS_CHAR;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
786: --- Added for Post 11.5.6 Enhancements
787: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
788: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
789: -------jngeorge----07/12/01
790:
791: END initialize_rec;
784: p_sr_record.subcomponent_version := FND_API.G_MISS_CHAR;
785: p_sr_record.comm_pref_code := FND_API.G_MISS_CHAR;
786: --- Added for Post 11.5.6 Enhancements
787: p_sr_record.cust_pref_lang_code := FND_API.G_MISS_CHAR;
788: p_sr_record.last_update_channel := 'EMAIL'; --FND_API.G_MISS_CHAR;
789: -------jngeorge----07/12/01
790:
791: END initialize_rec;
792:
791: END initialize_rec;
792:
793: PROCEDURE Update_Status_Wrap
794: ( p_api_version IN NUMBER,
795: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
796: p_commit IN VARCHAR2 := FND_API.G_FALSE,
797: x_return_status OUT NOCOPY VARCHAR2,
798: x_msg_count OUT NOCOPY NUMBER,
799: x_msg_data OUT NOCOPY VARCHAR2,
792:
793: PROCEDURE Update_Status_Wrap
794: ( p_api_version IN NUMBER,
795: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
796: p_commit IN VARCHAR2 := FND_API.G_FALSE,
797: x_return_status OUT NOCOPY VARCHAR2,
798: x_msg_count OUT NOCOPY NUMBER,
799: x_msg_data OUT NOCOPY VARCHAR2,
800: p_resp_appl_id IN NUMBER := NULL,
799: x_msg_data OUT NOCOPY VARCHAR2,
800: p_resp_appl_id IN NUMBER := NULL,
801: p_resp_id IN NUMBER := NULL,
802: p_user_id IN NUMBER := NULL,
803: p_login_id IN NUMBER := FND_API.G_MISS_NUM,
804: p_request_id IN NUMBER := NULL,
805: p_request_number IN VARCHAR2 := NULL,
806: p_object_version_number IN NUMBER,
807: p_status_id IN NUMBER := NULL,
805: p_request_number IN VARCHAR2 := NULL,
806: p_object_version_number IN NUMBER,
807: p_status_id IN NUMBER := NULL,
808: p_status IN VARCHAR2 := NULL,
809: p_closed_date IN DATE := FND_API.G_MISS_DATE,
810: p_audit_comments IN VARCHAR2 := NULL,
811: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
812: p_workflow_process_id IN NUMBER := NULL,
813: p_comments IN VARCHAR2 := NULL,
807: p_status_id IN NUMBER := NULL,
808: p_status IN VARCHAR2 := NULL,
809: p_closed_date IN DATE := FND_API.G_MISS_DATE,
810: p_audit_comments IN VARCHAR2 := NULL,
811: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
812: p_workflow_process_id IN NUMBER := NULL,
813: p_comments IN VARCHAR2 := NULL,
814: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
815: x_interaction_id OUT NOCOPY NUMBER
810: p_audit_comments IN VARCHAR2 := NULL,
811: p_called_by_workflow IN VARCHAR2 := FND_API.G_FALSE,
812: p_workflow_process_id IN NUMBER := NULL,
813: p_comments IN VARCHAR2 := NULL,
814: p_public_comment_flag IN VARCHAR2 := FND_API.G_FALSE,
815: x_interaction_id OUT NOCOPY NUMBER
816: )
817: IS
818:
819: l_api_name VARCHAR2(255):='Update_Status_Wrap';
820: l_api_version_number NUMBER:= 2.0;
821: l_cs_version_number NUMBER:= 2.0;
822:
823: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
824: l_msg_count NUMBER := 0;
825: l_msg_data VARCHAR2(2000);
826: l_index NUMBER := 1;
827:
827:
828: l_resp_appl_id NUMBER := NULL;
829: l_resp_id NUMBER := NULL;
830: l_user_id NUMBER := NULL;
831: l_login_id NUMBER := FND_API.G_MISS_NUM;
832: l_request_id NUMBER := NULL;
833: l_request_number VARCHAR2(256) := null;
834: l_object_version_number NUMBER;
835: l_status_id NUMBER := NULL;
833: l_request_number VARCHAR2(256) := null;
834: l_object_version_number NUMBER;
835: l_status_id NUMBER := NULL;
836: l_status VARCHAR2(30) := NULL;
837: l_closed_date DATE := FND_API.G_MISS_DATE;
838: l_audit_comments VARCHAR2(2000) := NULL;
839: l_called_by_workflow VARCHAR2(1):= FND_API.G_FALSE;
840: l_workflow_process_id NUMBER := NULL;
841: l_comments VARCHAR2(2000) := NULL;
835: l_status_id NUMBER := NULL;
836: l_status VARCHAR2(30) := NULL;
837: l_closed_date DATE := FND_API.G_MISS_DATE;
838: l_audit_comments VARCHAR2(2000) := NULL;
839: l_called_by_workflow VARCHAR2(1):= FND_API.G_FALSE;
840: l_workflow_process_id NUMBER := NULL;
841: l_comments VARCHAR2(2000) := NULL;
842: l_public_comment_flag VARCHAR2(1):= FND_API.G_FALSE;
843: l_interaction_id NUMBER;
838: l_audit_comments VARCHAR2(2000) := NULL;
839: l_called_by_workflow VARCHAR2(1):= FND_API.G_FALSE;
840: l_workflow_process_id NUMBER := NULL;
841: l_comments VARCHAR2(2000) := NULL;
842: l_public_comment_flag VARCHAR2(1):= FND_API.G_FALSE;
843: l_interaction_id NUMBER;
844:
845: IEM_UPDATE_SR_STATUS_FAIL EXCEPTION;
846:
848: -- Standard Start of API savepoint
849: SAVEPOINT Update_Status_Wrap;
850:
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
853: p_api_version,
854: l_api_name,
855: G_PKG_NAME)
856: THEN
854: l_api_name,
855: G_PKG_NAME)
856: THEN
857:
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860:
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
859: END IF;
860:
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list )
864: THEN
865: FND_MSG_PUB.initialize;
866: END IF;
867:
911: );
912:
913: l_interaction_id := x_interaction_id;
914:
915: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
916: raise IEM_UPDATE_SR_STATUS_FAIL;
917: end if;
918:
919: x_return_status := l_return_status ;
918:
919: x_return_status := l_return_status ;
920:
921: --Standard check of p_commit
922: IF FND_API.to_Boolean(p_commit) THEN
923: COMMIT WORK;
924: END IF;
925:
926: EXCEPTION
928: ROLLBACK TO Update_Status_Wrap;
929: x_return_status := l_return_status ;
930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
931:
932: WHEN FND_API.G_EXC_ERROR THEN
933: ROLLBACK TO Update_Status_Wrap;
934: x_return_status := FND_API.G_RET_STS_ERROR ;
935: FND_MSG_PUB.Count_And_Get
936: ( p_count => x_msg_count,p_data => x_msg_data);
930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
931:
932: WHEN FND_API.G_EXC_ERROR THEN
933: ROLLBACK TO Update_Status_Wrap;
934: x_return_status := FND_API.G_RET_STS_ERROR ;
935: FND_MSG_PUB.Count_And_Get
936: ( p_count => x_msg_count,p_data => x_msg_data);
937:
938:
935: FND_MSG_PUB.Count_And_Get
936: ( p_count => x_msg_count,p_data => x_msg_data);
937:
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ROLLBACK TO Update_Status_Wrap;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
943:
937:
938:
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ROLLBACK TO Update_Status_Wrap;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
943:
944: WHEN OTHERS THEN
945: ROLLBACK TO Update_Status_Wrap;
942: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
943:
944: WHEN OTHERS THEN
945: ROLLBACK TO Update_Status_Wrap;
946: x_return_status := FND_API.G_RET_STS_ERROR;
947:
948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
949: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
950: END IF;
958: -------------------------------------------------------------------------------
959:
960: PROCEDURE IEM_CREATE_SR
961: ( p_api_version IN NUMBER,
962: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
963: p_commit IN VARCHAR2 := FND_API.G_FALSE,
964: p_message_id IN NUMBER,
965: p_note IN VARCHAR2,
966: p_party_id IN NUMBER,
959:
960: PROCEDURE IEM_CREATE_SR
961: ( p_api_version IN NUMBER,
962: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
963: p_commit IN VARCHAR2 := FND_API.G_FALSE,
964: p_message_id IN NUMBER,
965: p_note IN VARCHAR2,
966: p_party_id IN NUMBER,
967: p_sr_type_id IN NUMBER,
980: l_api_name VARCHAR2(255):='IEM_CREATE_SR';
981: l_api_version_number NUMBER:=1.0;
982: l_cs_version_number NUMBER:=4.0;
983:
984: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
985: l_msg_count NUMBER := 0;
986: l_msg_data VARCHAR2(2000);
987: l_index NUMBER := 1;
988:
1027: -- Standard Start of API savepoint
1028: SAVEPOINT IEM_CREATE_SR;
1029:
1030: -- Standard call to check for call compatibility.
1031: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1032: p_api_version,
1033: l_api_name,
1034: G_PKG_NAME)
1035: THEN
1032: p_api_version,
1033: l_api_name,
1034: G_PKG_NAME)
1035: THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:
1039: -- Initialize message list if p_init_msg_list is set to TRUE.
1040: IF FND_API.to_Boolean( p_init_msg_list )
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;
1038:
1039: -- Initialize message list if p_init_msg_list is set to TRUE.
1040: IF FND_API.to_Boolean( p_init_msg_list )
1041: THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044:
1059: OPEN caller_type;
1060: FETCH caller_type INTO l_party_type;
1061:
1062: IF (caller_type%NOTFOUND) THEN
1063: x_return_status := FND_API.G_RET_STS_ERROR;
1064: CLOSE caller_type;
1065: END IF;
1066:
1067: CLOSE caller_type;
1141:
1142:
1143: CS_ServiceRequest_PUB.Create_ServiceRequest (
1144: p_api_version => l_cs_version_number,
1145: p_init_msg_list => FND_API.G_FALSE,
1146: p_commit => FND_API.G_FALSE,
1147: x_return_status => l_return_status,
1148: x_msg_count => l_msg_count,
1149: x_msg_data => l_msg_data,
1142:
1143: CS_ServiceRequest_PUB.Create_ServiceRequest (
1144: p_api_version => l_cs_version_number,
1145: p_init_msg_list => FND_API.G_FALSE,
1146: p_commit => FND_API.G_FALSE,
1147: x_return_status => l_return_status,
1148: x_msg_count => l_msg_count,
1149: x_msg_data => l_msg_data,
1150: p_resp_appl_id => NULL,
1163: p_default_contract_sla_ind => 'Y',
1164: p_default_coverage_template_id => l_coverage_template_id
1165: );
1166:
1167: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1168: raise IEM_SR_NOT_CREATE;
1169: end if;
1170:
1171: x_return_status := l_return_status ;
1171: x_return_status := l_return_status ;
1172: x_request_id := l_sr_create_out_rec.request_id;
1173:
1174: --Standard check of p_commit
1175: IF FND_API.to_Boolean(p_commit) THEN
1176: COMMIT WORK;
1177: END IF;
1178:
1179: EXCEPTION
1181: ROLLBACK TO IEM_CREATE_SR;
1182: x_return_status := l_return_status ;
1183: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO IEM_CREATE_SR;
1187: x_return_status := FND_API.G_RET_STS_ERROR ;
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_count => x_msg_count,p_data => x_msg_data);
1183: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: ROLLBACK TO IEM_CREATE_SR;
1187: x_return_status := FND_API.G_RET_STS_ERROR ;
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_count => x_msg_count,p_data => x_msg_data);
1190:
1191:
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_count => x_msg_count,p_data => x_msg_data);
1190:
1191:
1192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1193: ROLLBACK TO IEM_CREATE_SR;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1195: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1196:
1190:
1191:
1192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1193: ROLLBACK TO IEM_CREATE_SR;
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1195: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1196:
1197: WHEN OTHERS THEN
1198: ROLLBACK TO IEM_CREATE_SR;
1195: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1196:
1197: WHEN OTHERS THEN
1198: ROLLBACK TO IEM_CREATE_SR;
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200:
1201: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1202: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1203: END IF;