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 711: IF ((l_auto_assign_level = 'INDIVIDUAL' AND NVL(p_sr_related_data.old_disallow_owner_update,'N') = 'N') OR

707: THEN
708: l_auto_assign_level := fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
709: -- For bug 3702091 - AM API should not be called even if the Auto Assignment is ON
710: -- and the Assignment level is Group and Owner is passed
711: IF ((l_auto_assign_level = 'INDIVIDUAL' AND NVL(p_sr_related_data.old_disallow_owner_update,'N') = 'N') OR
712: (l_auto_assign_level = 'GROUP' AND p_sr_rec.owner_group_id is null))
713: THEN
714: p_sr_rec.load_balance := 'Y';
715: p_sr_rec.assign_owner := 'Y';

Line 1070: x_individual_owner OUT NOCOPY NUMBER,

1066: x_request_number OUT NOCOPY VARCHAR2,
1067: x_interaction_id OUT NOCOPY NUMBER,
1068: x_workflow_process_id OUT NOCOPY NUMBER,
1069: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1070: x_individual_owner OUT NOCOPY NUMBER,
1071: x_group_owner OUT NOCOPY NUMBER,
1072: x_individual_type OUT NOCOPY VARCHAR2
1073: )
1074: IS

Line 1072: x_individual_type OUT NOCOPY VARCHAR2

1068: x_workflow_process_id OUT NOCOPY NUMBER,
1069: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1070: x_individual_owner OUT NOCOPY NUMBER,
1071: x_group_owner OUT NOCOPY NUMBER,
1072: x_individual_type OUT NOCOPY VARCHAR2
1073: )
1074: IS
1075: l_api_version CONSTANT NUMBER := 3.0;
1076: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';

Line 1131: x_individual_owner := l_sr_create_out_rec.individual_owner;

1127: x_request_id := l_sr_create_out_rec.request_id;
1128: x_request_number := l_sr_create_out_rec.request_number;
1129: x_interaction_id := l_sr_create_out_rec.interaction_id;
1130: x_workflow_process_id := l_sr_create_out_rec.workflow_process_id;
1131: x_individual_owner := l_sr_create_out_rec.individual_owner;
1132: x_group_owner := l_sr_create_out_rec.group_owner;
1133: x_individual_type := l_sr_create_out_rec.individual_type;
1134:
1135: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1133: x_individual_type := l_sr_create_out_rec.individual_type;

1129: x_interaction_id := l_sr_create_out_rec.interaction_id;
1130: x_workflow_process_id := l_sr_create_out_rec.workflow_process_id;
1131: x_individual_owner := l_sr_create_out_rec.individual_owner;
1132: x_group_owner := l_sr_create_out_rec.group_owner;
1133: x_individual_type := l_sr_create_out_rec.individual_type;
1134:
1135: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1285: -- x_individual_owner OUT NOCOPY NUMBER,

1281: -- x_request_number OUT NOCOPY VARCHAR2,
1282: -- x_interaction_id OUT NOCOPY NUMBER,
1283: -- x_workflow_process_id OUT NOCOPY NUMBER,
1284: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1285: -- x_individual_owner OUT NOCOPY NUMBER,
1286: -- x_group_owner OUT NOCOPY NUMBER,
1287: -- x_individual_type OUT NOCOPY VARCHAR2
1288: )
1289: IS

Line 1287: -- x_individual_type OUT NOCOPY VARCHAR2

1283: -- x_workflow_process_id OUT NOCOPY NUMBER,
1284: -- These 3 parameters are added for Assignment Manager 115.9 changes.
1285: -- x_individual_owner OUT NOCOPY NUMBER,
1286: -- x_group_owner OUT NOCOPY NUMBER,
1287: -- x_individual_type OUT NOCOPY VARCHAR2
1288: )
1289: IS
1290: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';
1291: -- changed the version from 3.0 to 4.0 anmukher aug 11 2003

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

2139: l_service_request_rec.owner_assigned_time := SYSDATE;
2140: END IF;
2141: --- End of change , Sanjana Rao , bug 6955756
2142:
2143: x_sr_create_out_rec.individual_owner := l_service_request_rec.owner_id;
2144: x_sr_create_out_rec.individual_type := l_service_request_rec.resource_type;
2145: x_sr_create_out_rec.group_owner := l_service_request_rec.owner_group_id;
2146: -- March 23 2000, customer_number is not to be stored in cs_incidents_all_b
2147: -- If passed to teh api, it is used to retrieve the id from customer table

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

2140: END IF;
2141: --- End of change , Sanjana Rao , bug 6955756
2142:
2143: x_sr_create_out_rec.individual_owner := l_service_request_rec.owner_id;
2144: x_sr_create_out_rec.individual_type := l_service_request_rec.resource_type;
2145: x_sr_create_out_rec.group_owner := l_service_request_rec.owner_group_id;
2146: -- March 23 2000, customer_number is not to be stored in cs_incidents_all_b
2147: -- If passed to teh api, it is used to retrieve the id from customer table
2148: -- l_service_request_rec.customer_number, /*CUSTOMER_NUMBER*/

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

3158: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'PROBLEM_CODE', l_service_request_rec.problem_code, 'W', 'T');
3159: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
3160:
3161: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
3162: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
3163:
3164: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
3165: p_wf_item_process_name => 'CALL_SUPPORT',
3166: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),

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

5526: l_audit_vals_rec.old_inventory_item_id := l_old_servicerequest_rec.inventory_item_id;
5527:
5528:
5529: -- Assign owner, group to output record
5530: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5531: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5532: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5533:
5534: -- end of changes by aneemuch, 16-Oct-2003

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

5528:
5529: -- Assign owner, group to output record
5530: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5531: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5532: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5533:
5534: -- end of changes by aneemuch, 16-Oct-2003
5535: -- Assign owner, group to output record
5536: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;

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

5532: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5533:
5534: -- end of changes by aneemuch, 16-Oct-2003
5535: -- Assign owner, group to output record
5536: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5537: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5538: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5539:
5540: -- Start of change , Sanjana Rao , bug 6955756

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

5534: -- end of changes by aneemuch, 16-Oct-2003
5535: -- Assign owner, group to output record
5536: x_sr_update_out_rec.individual_owner := l_service_request_rec.owner_id;
5537: x_sr_update_out_rec.group_owner := l_service_request_rec.owner_group_id;
5538: x_sr_update_out_rec.individual_type := l_service_request_rec.resource_type;
5539:
5540: -- Start of change , Sanjana Rao , bug 6955756
5541: IF (l_service_request_rec.owner_id = FND_API.G_MISS_NUM) OR
5542: NVL(l_service_request_rec.owner_id,-99) = NVL(l_old_ServiceRequest_rec.incident_owner_id,-99)

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

6317: JTF_USR_HKS.Load_bind_data(l_bind_data_id, 'EXPECTED_RESOLUTION_DATE', l_service_request_rec.exp_resolution_date, 'W', 'T');
6318:
6319:
6320: -- Before the call to WorkFlow Hook, generate a unique item key using the workflow sequence
6321: SELECT cs_wf_process_id_s.NEXTVAL INTO l_workflow_item_key FROM dual;
6322:
6323: JTF_USR_HKS.WrkflowLaunch(p_wf_item_name => 'SERVEREQ',
6324: p_wf_item_process_name => 'CALL_SUPPORT',
6325: p_wf_item_key => 'SR' || TO_CHAR(l_workflow_item_key),

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

9049: IF (p_audit_id IS NOT NULL AND
9050: p_audit_id <> FND_API.G_MISS_NUM) THEN
9051: l_audit_id := p_audit_id;
9052: ELSE
9053: SELECT cs_incidents_audit_s1.NEXTVAL INTO l_audit_id FROM dual;
9054: x_audit_id := l_audit_id;
9055: END IF;
9056:
9057: INSERT INTO cs_incidents_audit_b (

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

13034: -- The request_id needs to be generated here because it is needed when
13035: -- inserting records into CS_HZ_SR_CONTACT_POINTS
13036: -- This generation is done here because the earlier check to see if
13037: -- request id is unique is done only if validation level is set.
13038: --Commenting this because , selecting from dual is not supported anymore
13039: --because of performance reasons.
13040:
13041: --CS_ServiceRequest_UTIL.Add_Null_Parameter_Msg(l_api_name_full, 'step #4');
13042:

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

14900: *******/
14901:
14902: IF l_request_id IS NULL THEN
14903: LOOP
14904: SELECT cs_incidents_s.NEXTVAL INTO x_req_id FROM dual;
14905: BEGIN
14906: SELECT incident_id INTO l_temp_id FROM cs_incidents_all_b
14907: WHERE incident_id = x_req_id;
14908: EXCEPTION

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

14917: END IF;
14918:
14919: IF l_request_number IS NULL THEN
14920: LOOP
14921: SELECT cs_incidents_number_s.NEXTVAL INTO x_req_num FROM dual;
14922: BEGIN
14923: SELECT incident_number INTO l_temp_num FROM cs_incidents_all_b
14924: WHERE incident_number = x_req_num;
14925: EXCEPTION

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

15175: -- owner (_tl table columns)
15176: -- 06/07/05 smisra Bug 4381751
15177: -- Modified condition for auto assignment call and called it
15178: -- only if disallow owner update is 'N' for assignment level
15179: -- 'INDIVIDUAL'. Disallow owner update flag value will not
15180: -- have any impact for assignment level 'GROUP'
15181: -- 07/11/05 smisra ERES changes. Changed processing related to disallow
15182: -- request update as follows
15183: -- if status passed to this procedure has pending approval

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

15189: -- 07/15/05 smisra Bug 4489746
15190: -- removed start and end active dates from query on
15191: -- cs_incident_types. Validate type will take care of
15192: -- date effectivity check.
15193: -- 07/20/05 smisra replaced individual vars from get_status_details call with
15194: -- structure l_sr_related_data members
15195: --
15196: -- Removed queries on cs_incident_statuses_b table that were
15197: -- present inside comments. These queries are replaced with

Line 20889: x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.

20885:
20886: /* This is a overloaded procedure for create service request which is mainly
20887: created for making the changes for 1159 backward compatiable. This does not
20888: contain the following parameters:-
20889: x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.
20890: and will call the above procedure with all these parameters and version
20891: as 3.0*/
20892:
20893: PROCEDURE Create_ServiceRequest(

Line 20922: l_individual_owner NUMBER;

20918: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';
20919: l_api_version CONSTANT NUMBER := 2.0;
20920: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
20921: l_return_status VARCHAR2(1);
20922: l_individual_owner NUMBER;
20923: l_group_owner NUMBER;
20924: l_individual_type VARCHAR2(30);
20925:
20926:

Line 20924: l_individual_type VARCHAR2(30);

20920: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
20921: l_return_status VARCHAR2(1);
20922: l_individual_owner NUMBER;
20923: l_group_owner NUMBER;
20924: l_individual_type VARCHAR2(30);
20925:
20926:
20927: BEGIN
20928: -- Standard start of API savepoint

Line 20964: x_individual_owner => l_individual_owner,

20960: x_request_id => x_request_id,
20961: x_request_number => x_request_number,
20962: x_interaction_id => x_interaction_id,
20963: x_workflow_process_id => x_workflow_process_id,
20964: x_individual_owner => l_individual_owner,
20965: x_group_owner => l_group_owner,
20966: x_individual_type => l_individual_type
20967: );
20968:

Line 20966: x_individual_type => l_individual_type

20962: x_interaction_id => x_interaction_id,
20963: x_workflow_process_id => x_workflow_process_id,
20964: x_individual_owner => l_individual_owner,
20965: x_group_owner => l_group_owner,
20966: x_individual_type => l_individual_type
20967: );
20968:
20969: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
20970: RAISE FND_API.G_EXC_ERROR;