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.

[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB dependencies on DUAL

Line 600: x_individual_owner OUT NOCOPY NUMBER,

596: x_request_number OUT NOCOPY VARCHAR2,
597: x_interaction_id OUT NOCOPY NUMBER,
598: x_workflow_process_id OUT NOCOPY NUMBER,
599: -- These 3 parameters are added for Assignment Manager 115.9 changes.
600: x_individual_owner OUT NOCOPY NUMBER,
601: x_group_owner OUT NOCOPY NUMBER,
602: x_individual_type OUT NOCOPY VARCHAR2
603: )
604: IS

Line 602: x_individual_type OUT NOCOPY VARCHAR2

598: x_workflow_process_id OUT NOCOPY NUMBER,
599: -- These 3 parameters are added for Assignment Manager 115.9 changes.
600: x_individual_owner OUT NOCOPY NUMBER,
601: x_group_owner OUT NOCOPY NUMBER,
602: x_individual_type OUT NOCOPY VARCHAR2
603: )
604: IS
605: l_api_version CONSTANT NUMBER := 3.0;
606: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';

Line 663: x_individual_owner := l_sr_create_out_rec.individual_owner;

659: x_request_id := l_sr_create_out_rec.request_id;
660: x_request_number := l_sr_create_out_rec.request_number;
661: x_interaction_id := l_sr_create_out_rec.interaction_id;
662: x_workflow_process_id := l_sr_create_out_rec.workflow_process_id;
663: x_individual_owner := l_sr_create_out_rec.individual_owner;
664: x_group_owner := l_sr_create_out_rec.group_owner;
665: x_individual_type := l_sr_create_out_rec.individual_type;
666:
667: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 665: x_individual_type := l_sr_create_out_rec.individual_type;

661: x_interaction_id := l_sr_create_out_rec.interaction_id;
662: x_workflow_process_id := l_sr_create_out_rec.workflow_process_id;
663: x_individual_owner := l_sr_create_out_rec.individual_owner;
664: x_group_owner := l_sr_create_out_rec.group_owner;
665: x_individual_type := l_sr_create_out_rec.individual_type;
666:
667: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
668: RAISE FND_API.G_EXC_ERROR;
669: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 748: -- x_individual_owner OUT NOCOPY NUMBER,

744: -- x_request_number OUT NOCOPY VARCHAR2,
745: -- x_interaction_id OUT NOCOPY NUMBER,
746: -- x_workflow_process_id OUT NOCOPY NUMBER,
747: -- Added for assignment manager changes for 11.5.9
748: -- x_individual_owner OUT NOCOPY NUMBER,
749: -- x_group_owner OUT NOCOPY NUMBER,
750: -- x_individual_type OUT NOCOPY VARCHAR2
751: )
752: IS

Line 750: -- x_individual_type OUT NOCOPY VARCHAR2

746: -- x_workflow_process_id OUT NOCOPY NUMBER,
747: -- Added for assignment manager changes for 11.5.9
748: -- x_individual_owner OUT NOCOPY NUMBER,
749: -- x_group_owner OUT NOCOPY NUMBER,
750: -- x_individual_type OUT NOCOPY VARCHAR2
751: )
752: IS
753:
754: -- changed the version from 3.0 to 4.0 anmukher aug 08 2003

Line 2123: -- OUT rec type to be used instead of individual OUT params

2119: -- Added for 11.5.10 projects
2120: p_auto_generate_tasks => p_auto_generate_tasks,
2121: p_default_contract_sla_ind => p_default_contract_sla_ind,
2122: p_default_coverage_template_id => p_default_coverage_template_id,
2123: -- OUT rec type to be used instead of individual OUT params
2124: x_sr_create_out_rec => l_sr_create_out_rec
2125: -- The following OUT params are now part of the OUT rec type
2126: -- x_request_id => x_request_id,
2127: -- x_request_number => x_request_number,

Line 2131: -- x_individual_owner => x_individual_owner,

2127: -- x_request_number => x_request_number,
2128: -- x_interaction_id => x_interaction_id,
2129: -- x_workflow_process_id => x_workflow_process_id,
2130: -- These 3 parameters are added for Assignment Manager 115.9 changes.
2131: -- x_individual_owner => x_individual_owner,
2132: -- x_group_owner => x_group_owner,
2133: -- x_individual_type => x_individual_type
2134: );
2135:

Line 2133: -- x_individual_type => x_individual_type

2129: -- x_workflow_process_id => x_workflow_process_id,
2130: -- These 3 parameters are added for Assignment Manager 115.9 changes.
2131: -- x_individual_owner => x_individual_owner,
2132: -- x_group_owner => x_group_owner,
2133: -- x_individual_type => x_individual_type
2134: );
2135:
2136:
2137: -- Assign the returned values to the OUT rec --anmukher -- 08/13/03

Line 2142: x_sr_create_out_rec.individual_owner := l_sr_create_out_rec.individual_owner;

2138: x_sr_create_out_rec.request_id := l_sr_create_out_rec.request_id;
2139: x_sr_create_out_rec.request_number := l_sr_create_out_rec.request_number;
2140: x_sr_create_out_rec.interaction_id := l_sr_create_out_rec.interaction_id;
2141: x_sr_create_out_rec.workflow_process_id := l_sr_create_out_rec.workflow_process_id;
2142: x_sr_create_out_rec.individual_owner := l_sr_create_out_rec.individual_owner;
2143: x_sr_create_out_rec.group_owner := l_sr_create_out_rec.group_owner;
2144: x_sr_create_out_rec.individual_type := l_sr_create_out_rec.individual_type;
2145: x_sr_create_out_rec.auto_task_gen_status := l_sr_create_out_rec.auto_task_gen_status;
2146: x_sr_create_out_rec.auto_task_gen_attempted := l_sr_create_out_rec.auto_task_gen_attempted;

Line 2144: x_sr_create_out_rec.individual_type := l_sr_create_out_rec.individual_type;

2140: x_sr_create_out_rec.interaction_id := l_sr_create_out_rec.interaction_id;
2141: x_sr_create_out_rec.workflow_process_id := l_sr_create_out_rec.workflow_process_id;
2142: x_sr_create_out_rec.individual_owner := l_sr_create_out_rec.individual_owner;
2143: x_sr_create_out_rec.group_owner := l_sr_create_out_rec.group_owner;
2144: x_sr_create_out_rec.individual_type := l_sr_create_out_rec.individual_type;
2145: x_sr_create_out_rec.auto_task_gen_status := l_sr_create_out_rec.auto_task_gen_status;
2146: x_sr_create_out_rec.auto_task_gen_attempted := l_sr_create_out_rec.auto_task_gen_attempted;
2147: x_sr_create_out_rec.field_service_task_created := l_sr_create_out_rec.field_service_task_created;
2148: x_sr_create_out_rec.contract_service_id := l_sr_create_out_rec.contract_service_id;

Line 3370: x_sr_update_out_rec.individual_owner := l_sr_update_out_rec.individual_owner;

3366:
3367: -- Assign returned values to OUT rec
3368: x_sr_update_out_rec.interaction_id := l_sr_update_out_rec.interaction_id;
3369: x_sr_update_out_rec.workflow_process_id := l_sr_update_out_rec.workflow_process_id;
3370: x_sr_update_out_rec.individual_owner := l_sr_update_out_rec.individual_owner;
3371: x_sr_update_out_rec.group_owner := l_sr_update_out_rec.group_owner;
3372: x_sr_update_out_rec.individual_type := l_sr_update_out_rec.individual_type;
3373: x_sr_update_out_rec.resolved_on_date := l_sr_update_out_rec.resolved_on_date;
3374: x_sr_update_out_rec.responded_on_date := l_sr_update_out_rec.responded_on_date;

Line 3372: x_sr_update_out_rec.individual_type := l_sr_update_out_rec.individual_type;

3368: x_sr_update_out_rec.interaction_id := l_sr_update_out_rec.interaction_id;
3369: x_sr_update_out_rec.workflow_process_id := l_sr_update_out_rec.workflow_process_id;
3370: x_sr_update_out_rec.individual_owner := l_sr_update_out_rec.individual_owner;
3371: x_sr_update_out_rec.group_owner := l_sr_update_out_rec.group_owner;
3372: x_sr_update_out_rec.individual_type := l_sr_update_out_rec.individual_type;
3373: x_sr_update_out_rec.resolved_on_date := l_sr_update_out_rec.resolved_on_date;
3374: x_sr_update_out_rec.responded_on_date := l_sr_update_out_rec.responded_on_date;
3375: x_sr_update_out_rec.status_id := l_sr_update_out_rec.status_id;
3376: x_sr_update_out_rec.close_date := l_sr_update_out_rec.close_date;

Line 4455: -- individual segments instead, need to first convert them into a string

4451: p_attribute_id_out := FND_FLEX_KEYVAL.Combination_ID;
4452: END IF;
4453: ELSIF (p_attribute_n_segments <> 0) THEN
4454: -- If caller did not pass in the concatenated segments but passed in the
4455: -- individual segments instead, need to first convert them into a string
4456: -- of concatenated segments before finding the combination ID.
4457: l_delimiter := FND_FLEX_EXT.Get_Delimiter
4458: ( application_short_name => p_application_short_name,
4459: key_flex_code => p_key_flex_code,

Line 5171: x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.

5167:
5168: /* This is a overloaded procedure for create service request which is mainly
5169: created for making the changes for 1159 backward compatiable. This does not
5170: contain the following parameters:-
5171: x_individual_owner, x_group_owner, x_individual_type and p_auto_assign.
5172: and will call the above procedure with all these parameters and version
5173: as 3.0*/
5174:
5175: PROCEDURE Create_ServiceRequest

Line 5202: l_individual_owner NUMBER;

5198: IS
5199: l_api_version CONSTANT NUMBER := 2.0;
5200: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';
5201: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
5202: l_individual_owner NUMBER;
5203: l_group_owner NUMBER;
5204: l_individual_type VARCHAR2(30);
5205: l_return_status VARCHAR2(1);
5206:

Line 5204: l_individual_type VARCHAR2(30);

5200: l_api_name CONSTANT VARCHAR2(30) := 'Create_ServiceRequest';
5201: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
5202: l_individual_owner NUMBER;
5203: l_group_owner NUMBER;
5204: l_individual_type VARCHAR2(30);
5205: l_return_status VARCHAR2(1);
5206:
5207: BEGIN
5208: -- Standard start of API savepoint

Line 5251: x_individual_owner => l_individual_owner,

5247: x_request_id => x_request_id,
5248: x_request_number => x_request_number,
5249: x_interaction_id => x_interaction_id,
5250: x_workflow_process_id => x_workflow_process_id,
5251: x_individual_owner => l_individual_owner,
5252: x_group_owner => l_group_owner,
5253: x_individual_type => l_individual_type
5254: );
5255:

Line 5253: x_individual_type => l_individual_type

5249: x_interaction_id => x_interaction_id,
5250: x_workflow_process_id => x_workflow_process_id,
5251: x_individual_owner => l_individual_owner,
5252: x_group_owner => l_group_owner,
5253: x_individual_type => l_individual_type
5254: );
5255:
5256: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5257: RAISE FND_API.G_EXC_ERROR;

Line 6538: ELSE hzcp.email_address END AS ContactEmail from dual) ContactEmail

6534: AND Asmt.EFFECTIVE_START_DATE= (SELECT MAX(b.EFFECTIVE_START_DATE)
6535: FROM PER_ALL_ASSIGNMENTS_F b
6536: WHERE b.person_id = Asmt.person_id
6537: AND b.assignment_id = Asmt.assignment_id) and rownum=1)
6538: ELSE hzcp.email_address END AS ContactEmail from dual) ContactEmail
6539: ,(SELECT cat.concatenated_segments
6540: FROM mtl_categories_b_kfv cat
6541: WHERE cat.category_id = inc.category_id )ItemCategory
6542: ,( select csi.instance_number