eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_PVT dependencies on DUAL

Line 661: IF ((l_auto_assign_level = 'INDIVIDUAL' AND NVL(p_sr_related_data.old_disallow_owner_update,'N') = 'N') OR

657: THEN
658: l_auto_assign_level := fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
659: -- For bug 3702091 - AM API should not be called even if the Auto Assignment is ON
660: -- and the Assignment level is Group and Owner is passed
661: IF ((l_auto_assign_level = 'INDIVIDUAL' AND NVL(p_sr_related_data.old_disallow_owner_update,'N') = 'N') OR
662: (l_auto_assign_level = 'GROUP' AND p_sr_rec.owner_group_id is null))
663: THEN
664: p_sr_rec.load_balance := 'Y';
665: p_sr_rec.assign_owner := 'Y';

Line 1018: x_individual_owner OUT NOCOPY NUMBER,

1014: x_request_number OUT NOCOPY VARCHAR2,
1015: x_interaction_id OUT NOCOPY NUMBER,
1016: x_workflow_process_id OUT NOCOPY NUMBER,
1017: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1018: x_individual_owner OUT NOCOPY NUMBER,
1019: x_group_owner OUT NOCOPY NUMBER,
1020: x_individual_type OUT NOCOPY VARCHAR2
1021: )
1022: IS

Line 1020: x_individual_type OUT NOCOPY VARCHAR2

1016: x_workflow_process_id OUT NOCOPY NUMBER,
1017: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1018: x_individual_owner OUT NOCOPY NUMBER,
1019: x_group_owner OUT NOCOPY NUMBER,
1020: x_individual_type OUT NOCOPY VARCHAR2
1021: )
1022: IS
1023: l_api_version CONSTANT NUMBER := 3.0;
1024: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';

Line 1079: x_individual_owner := l_sr_create_out_rec.individual_owner;

1075: x_request_id := l_sr_create_out_rec.request_id;
1076: x_request_number := l_sr_create_out_rec.request_number;
1077: x_interaction_id := l_sr_create_out_rec.interaction_id;
1078: x_workflow_process_id := l_sr_create_out_rec.workflow_process_id;
1079: x_individual_owner := l_sr_create_out_rec.individual_owner;
1080: x_group_owner := l_sr_create_out_rec.group_owner;
1081: x_individual_type := l_sr_create_out_rec.individual_type;
1082:
1083: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1081: x_individual_type := l_sr_create_out_rec.individual_type;

1077: x_interaction_id := l_sr_create_out_rec.interaction_id;
1078: x_workflow_process_id := l_sr_create_out_rec.workflow_process_id;
1079: x_individual_owner := l_sr_create_out_rec.individual_owner;
1080: x_group_owner := l_sr_create_out_rec.group_owner;
1081: x_individual_type := l_sr_create_out_rec.individual_type;
1082:
1083: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1233: -- x_individual_owner OUT NOCOPY NUMBER,

1229: -- x_request_number OUT NOCOPY VARCHAR2,
1230: -- x_interaction_id OUT NOCOPY NUMBER,
1231: -- x_workflow_process_id OUT NOCOPY NUMBER,
1232: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1233: -- x_individual_owner OUT NOCOPY NUMBER,
1234: -- x_group_owner OUT NOCOPY NUMBER,
1235: -- x_individual_type OUT NOCOPY VARCHAR2
1236: )
1237: IS

Line 1235: -- x_individual_type OUT NOCOPY VARCHAR2

1231: -- x_workflow_process_id OUT NOCOPY NUMBER,
1232: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1233: -- x_individual_owner OUT NOCOPY NUMBER,
1234: -- x_group_owner OUT NOCOPY NUMBER,
1235: -- x_individual_type OUT NOCOPY VARCHAR2
1236: )
1237: IS
1238: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';
1239: -- changed the version from 3.0 to 4.0 anmukher aug 11 2003

Line 2012: x_sr_create_out_rec.individual_owner := l_service_request_rec.owner_id;

2008: l_service_request_rec.owner_assigned_time := SYSDATE;
2009: END IF;
2010: --- End of change , Sanjana Rao , bug 6955756
2011:
2012: x_sr_create_out_rec.individual_owner := l_service_request_rec.owner_id;
2013: x_sr_create_out_rec.individual_type := l_service_request_rec.resource_type;
2014: x_sr_create_out_rec.group_owner := l_service_request_rec.owner_group_id;
2015: -- March 23 2000, customer_number is not to be stored in cs_incidents_all_b
2016: -- If passed to teh api, it is used to retrieve the id from customer table

Line 2013: x_sr_create_out_rec.individual_type := l_service_request_rec.resource_type;

2009: END IF;
2010: --- End of change , Sanjana Rao , bug 6955756
2011:
2012: x_sr_create_out_rec.individual_owner := l_service_request_rec.owner_id;
2013: x_sr_create_out_rec.individual_type := l_service_request_rec.resource_type;
2014: x_sr_create_out_rec.group_owner := l_service_request_rec.owner_group_id;
2015: -- March 23 2000, customer_number is not to be stored in cs_incidents_all_b
2016: -- If passed to teh api, it is used to retrieve the id from customer table
2017: -- l_service_request_rec.customer_number, /*CUSTOMER_NUMBER*/

Line 2822: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;

2818: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'PROBLEM_CODE', l_service_request_rec.problem_code, 'W', 'T');
2819: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
2820:
2821: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
2822: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
2823:
2824: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
2825: p_wf_item_process_name => 'CALL_SUPPORT',
2826: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),

Line 5109: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;

5105: l_audit_vals_rec.old_inventory_item_id := l_old_servicerequest_rec.inventory_item_id;
5106:
5107:
5108: -- Assign owner, group to output record
5109: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5110: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5111: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5112:
5113: -- end of changes by aneemuch, 16-Oct-2003

Line 5111: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;

5107:
5108: -- Assign owner, group to output record
5109: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5110: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5111: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5112:
5113: -- end of changes by aneemuch, 16-Oct-2003
5114: -- Assign owner, group to output record
5115: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;

Line 5115: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;

5111: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5112:
5113: -- end of changes by aneemuch, 16-Oct-2003
5114: -- Assign owner, group to output record
5115: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5116: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5117: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5118:
5119: -- Start of change , Sanjana Rao , bug 6955756

Line 5117: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;

5113: -- end of changes by aneemuch, 16-Oct-2003
5114: -- Assign owner, group to output record
5115: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5116: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5117: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5118:
5119: -- Start of change , Sanjana Rao , bug 6955756
5120: IF (l_service_request_rec.owner_id = FND_API.G_MISS_NUM) OR
5121: NVL(l_service_request_rec.owner_id,-99) = NVL(l_old_ServiceRequest_rec.incident_owner_id,-99)

Line 5640: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;

5636: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
5637:
5638:
5639: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
5640: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
5641:
5642: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
5643: p_wf_item_process_name => 'CALL_SUPPORT',
5644: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),

Line 8111: SELECT cs_incidents_audit_s1.NEXTVAL INTO l_audit_id FROM dual;

8107: IF (p_audit_id IS NOT NULL AND
8108: p_audit_id <> FND_API.G_MISS_NUM) THEN
8109: l_audit_id := p_audit_id;
8110: ELSE
8111: SELECT cs_incidents_audit_s1.NEXTVAL INTO l_audit_id FROM dual;
8112: x_audit_id := l_audit_id;
8113: END IF;
8114:
8115: INSERT INTO cs_incidents_audit_b (

Line 11996: --Commenting this because , selecting from dual is not supported anymore

11992: -- The request_id needs to be generated here because it is needed when
11993: -- inserting records into CS_HZ_SR_CONTACT_POINTS
11994: -- This generation is done here because the earlier check to see if
11995: -- request id is unique is done only if validation level is set.
11996: --Commenting this because , selecting from dual is not supported anymore
11997: --because of performance reasons.
11998:
11999: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #4');
12000:

Line 13768: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;

13764: *******/
13765:
13766: IF l_request_id IS NULL THEN
13767: LOOP
13768: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;
13769: BEGIN
13770: SELECT incident_id INTO l_temp_id FROM cs_incidents_all_b
13771: WHERE incident_id = x_req_id;
13772: EXCEPTION

Line 13785: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;

13781: END IF;
13782:
13783: IF l_request_number IS NULL THEN
13784: LOOP
13785: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;
13786: BEGIN
13787: SELECT incident_number INTO l_temp_num FROM cs_incidents_all_b
13788: WHERE incident_number = x_req_num;
13789: EXCEPTION

Line 13984: -- 'INDIVIDUAL'. Disallow owner update flag value will not

13980: -- owner (_tl table columns)
13981: -- 06/07/05 smisra Bug 4381751
13982: -- Modified condition for auto assignment call and called it
13983: -- only if disallow owner update is 'N' for assignment level
13984: -- 'INDIVIDUAL'. Disallow owner update flag value will not
13985: -- have any impact for assignment level 'GROUP'
13986: -- 07/11/05 smisra ERES changes. Changed processing related to disallow
13987: -- request update as follows
13988: -- if status passed to this procedure has pending approval

Line 13998: -- 07/20/05 smisra replaced individual vars from get_status_details call with

13994: -- 07/15/05 smisra Bug 4489746
13995: -- removed start and end active dates from query on
13996: -- cs_incident_types. Validate type will take care of
13997: -- date effectivity check.
13998: -- 07/20/05 smisra replaced individual vars from get_status_details call with
13999: -- structure l_sr_related_data members
14000: --
14001: -- Removed queries on cs_incident_statuses_b table that were
14002: -- present inside comments. These queries are replaced with

Line 19373: x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.

19369:
19370: /* This is a overloaded procedure for create service request which is mainly
19371: created for making the changes for 1159 backward compatiable. This does not
19372: contain the following parameters:-
19373: x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.
19374: and will call the above procedure with all these parameters and version
19375: as 3.0*/
19376:
19377: PROCEDURE Create_ServiceRequest(

Line 19406: l_individual_owner NUMBER;

19402: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';
19403: l_api_version CONSTANT NUMBER := 2.0;
19404: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
19405: l_return_status VARCHAR2(1);
19406: l_individual_owner NUMBER;
19407: l_group_owner NUMBER;
19408: l_individual_type VARCHAR2(30);
19409:
19410:

Line 19408: l_individual_type VARCHAR2(30);

19404: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
19405: l_return_status VARCHAR2(1);
19406: l_individual_owner NUMBER;
19407: l_group_owner NUMBER;
19408: l_individual_type VARCHAR2(30);
19409:
19410:
19411: BEGIN
19412: -- Standard start of API savepoint

Line 19448: x_individual_owner => l_individual_owner,

19444: x_request_id => x_request_id,
19445: x_request_number => x_request_number,
19446: x_interaction_id => x_interaction_id,
19447: x_workflow_process_id => x_workflow_process_id,
19448: x_individual_owner => l_individual_owner,
19449: x_group_owner => l_group_owner,
19450: x_individual_type => l_individual_type
19451: );
19452:

Line 19450: x_individual_type => l_individual_type

19446: x_interaction_id => x_interaction_id,
19447: x_workflow_process_id => x_workflow_process_id,
19448: x_individual_owner => l_individual_owner,
19449: x_group_owner => l_group_owner,
19450: x_individual_type => l_individual_type
19451: );
19452:
19453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
19454: RAISE FND_API.G_EXC_ERROR;