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 CS_INCIDENTS_ALL_B

Line 8: G_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_B';

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_ServiceRequest_PVT';
5: G_INITIALIZED CONSTANT VARCHAR2(1) := 'R';
6: G_SR_SUBTYPE CONSTANT VARCHAR2(5) := 'INC';
7: G_API_REVISION CONSTANT NUMBER := 1.0;
8: G_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_B';
9: G_TL_TABLE_NAME CONSTANT VARCHAR2(40) := 'CS_INCIDENTS_ALL_TL';
10:
11: --
12: --This procedure checks if an attribute is g_miss_char, if no then it returns.

Line 375: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;

371: l_contract_defaulted VARCHAR2(1);
372: l_msg_count NUMBER;
373: l_msg_data VARCHAR2(2000);
374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
375: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
376: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
379: l_territory_id NUMBER;

Line 376: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;

372: l_msg_count NUMBER;
373: l_msg_data VARCHAR2(2000);
374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
375: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
376: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
379: l_territory_id NUMBER;
380: l_orig_group_type_null varchar2(1) := 'N';

Line 377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;

373: l_msg_data VARCHAR2(2000);
374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
375: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
376: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
379: l_territory_id NUMBER;
380: l_orig_group_type_null varchar2(1) := 'N';
381: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;

Line 378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;

374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
375: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
376: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
379: l_territory_id NUMBER;
380: l_orig_group_type_null varchar2(1) := 'N';
381: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
382: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;

Line 381: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;

377: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
378: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
379: l_territory_id NUMBER;
380: l_orig_group_type_null varchar2(1) := 'N';
381: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
382: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;
383: BEGIN
384: l_api_name := 'CS_SERVICEREQUEST_PVT.vldt_sr_rec';
385: l_log_module := 'cs.plsql.' || l_api_name || '.';

Line 809: UPDATE CS_INCIDENTS_ALL_B

805: -- update incidents table only if timezone is found
806: --
807: IF (l_timezone_id IS NOT NULL)
808: THEN
809: UPDATE CS_INCIDENTS_ALL_B
810: SET time_zone_id = l_timezone_id
811: WHERE incident_id = p_incident_id;
812: END IF;
813:

Line 1129: -- modified insert to cs_incidents_all_b and passed values for

1125: -- cs_srcontact_pkg.create_update to insert or update
1126: -- service request contact points
1127: -- 05/09/05 smisra Added defaulting of org_id before call to
1128: -- creat_sr_validation.
1129: -- modified insert to cs_incidents_all_b and passed values for
1130: -- columns org_id and maint_organization_id
1131: -- 05/27/05 smisra Bug 4227769
1132: -- Removed owner and group_owner columns from insert into
1133: -- cs_incidents_all_tl table.

Line 1503: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'

1499: ( 'API_NAME'
1500: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1501: );
1502: FND_MSG_PUB.ADD_DETAIL
1503: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
1504: );
1505: RAISE FND_API.G_EXC_ERROR;
1506: END IF;
1507:

Line 1562: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'

1558: ( 'API_NAME'
1559: , 'CS_SERVICEREQUEST_PVT.create_servicerequest'
1560: );
1561: FND_MSG_PUB.ADD_DETAIL
1562: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
1563: );
1564: RAISE FND_API.G_EXC_ERROR;
1565: END IF;
1566: ELSE -- maintenance flag is 'Y'

Line 2015: -- March 23 2000, customer_number is not to be stored in cs_incidents_all_b

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*/
2018:
2019:

Line 2024: INSERT INTO cs_incidents_all_b

2020:
2021: --
2022: -- Insert into _B table
2023: --
2024: INSERT INTO cs_incidents_all_b
2025: ( incident_id,
2026: last_update_date,
2027: last_updated_by,
2028: creation_date,

Line 2478: /* updating value of the primary_contact_id in the cs_incidents_all_b table

2474:
2475:
2476: -- This record creation should not take place if caller_type is CALLER_EMP
2477: -- For Caller type Employee, should not create any contacts
2478: /* updating value of the primary_contact_id in the cs_incidents_all_b table
2479: after we insert record in cs_hz_sr_contact_points, so that
2480: sr_contact_point_id can be inserted as primary_contact_id by shijain
2481: for enh. 2690787
2482:

Line 2487: UPDATE cs_incidents_all_b

2483: l_primary_contact:= get_primary_contact(l_request_id);
2484:
2485: IF l_primary_contact is not null THEN
2486:
2487: UPDATE cs_incidents_all_b
2488: SET primary_contact_id = l_primary_contact
2489: WHERE incident_id = l_request_id;
2490:
2491: END IF;

Line 3851: FROM cs_incidents_all_b

3847:
3848: BEGIN
3849:
3850: SELECT object_version_number INTO l_dummy
3851: FROM cs_incidents_all_b
3852: WHERE incident_id = p_request_id;
3853:
3854: EXCEPTION
3855: WHEN NO_DATA_FOUND THEN

Line 3981: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'

3977: ( 'API_NAME'
3978: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
3979: );
3980: FND_MSG_PUB.ADD_DETAIL
3981: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.ITEM_SERIAL_NUMBER'
3982: );
3983: RAISE FND_API.G_EXC_ERROR;
3984: END IF;
3985: --

Line 4133: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'

4129: ( 'API_NAME'
4130: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4131: );
4132: FND_MSG_PUB.ADD_DETAIL
4133: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.MAINT_ORGANIZATION_ID'
4134: );
4135: RAISE FND_API.G_EXC_ERROR;
4136: END IF;
4137: ELSE -- maintenance flag is 'Y'

Line 4278: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'

4274: , 'CS_SERVICEREQUEST_PVT.update_servicerequest'
4275: );
4276: FND_MESSAGE.set_token('STATUS_ID',l_sr_related_data.target_status_id);
4277: FND_MSG_PUB.ADD_DETAIL
4278: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
4279: );
4280: RAISE FND_API.G_EXC_ERROR;
4281: END IF; -- l_pending approval flag is Y
4282: ELSE -- status_id <> G_MISS and not equal to old value

Line 4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'

4300: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
4301: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
4302: FND_MSG_PUB.Add_Detail
4303: ( p_message_type => fnd_msg_pub.G_WARNING_MSG
4304: , p_same_associated_columns => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
4305: );
4306: IF l_old_servicerequest_rec.incident_status_id = l_service_request_rec.status_id
4307: THEN
4308: CS_ServiceRequest_UTIL.Add_Same_Val_Update_Msg

Line 4907: UPDATE cs_incidents_all_b

4903: --Update Sr then, if object version is incremented to 3 , then
4904: --cannot update any other attributes displayed on the Sr form, since
4905: --SR form had already locked the record with object version as 2.
4906:
4907: UPDATE cs_incidents_all_b
4908: SET workflow_process_id = p_workflow_process_id
4909: WHERE ROWID = l_old_ServiceRequest_rec.ROW_ID ;
4910:
4911: ELSE

Line 5145: UPDATE cs_incidents_all_b

5141:
5142: --End of change , Sanjana Rao, bug 6955756
5143:
5144: ---Update for all cases.
5145: UPDATE cs_incidents_all_b
5146: SET incident_status_id = l_service_request_rec.status_id,
5147: incident_type_id = l_service_request_rec.type_id,
5148: incident_urgency_id = l_service_request_rec.urgency_id,
5149: incident_severity_id = l_service_request_rec.severity_id,

Line 5392: These are already set before update to cs_incidents_all_b table

5388: -- Added these assignments here as these values are not available in Update_SR_Validation
5389:
5390: /* These are not correct. if old value is null then else condition will get executed and
5391: wrong value will go to new value col in audit rec
5392: These are already set before update to cs_incidents_all_b table
5393: smisra: 29th nov 2004
5394: l_audit_vals_rec.OLD_CONTRACT_ID := l_old_ServiceRequest_rec.CONTRACT_ID;
5395: IF (l_contra_id <> FND_API.G_MISS_NUM) AND
5396: (l_contra_id <> l_old_ServiceRequest_rec.CONTRACT_ID) THEN

Line 5897: UPDATE cs_incidents_all_b

5893: -- 2. incident responded date
5894: -- 3. incident resolved date
5895: -- 4. Close date
5896: l_service_request_rec.status_id := l_sr_related_data.target_status_id;
5897: UPDATE cs_incidents_all_b
5898: SET incident_status_id = l_service_request_rec.status_id
5899: , inc_responded_by_date = l_service_request_rec.inc_responded_by_date
5900: , incident_resolved_date = l_service_request_rec.incident_resolved_date
5901: , status_flag = l_service_request_rec.status_flag

Line 6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');

6800: FND_MSG_PUB.ADD;
6801: --FND_MESSAGE.set_name('CS','CS_SR_INTERMEDIATE_STATUS');
6802: --FND_MESSAGE.set_token('API_NAME','CS_SERVICEREQUEST_PVT.update_status');
6803: --FND_MESSAGE.set_token('STATUS_ID',l_servicerequest_rec.incident_status_id);
6804: --FND_MSG_PUB.ADD_DETAIL(p_associated_column1=>'CS_INCIDENTS_ALL_B.incident_status_id');
6805: RAISE FND_API.G_EXC_ERROR;
6806: END IF; -- l_pending approval flag is Y
6807: END IF; -- if after get_status_details call
6808:

Line 6833: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'

6829: , 'CS_SERVICEREQUEST_PVT.update_status'
6830: );
6831: FND_MESSAGE.set_token('STATUS_ID',p_status_id);
6832: FND_MSG_PUB.ADD_DETAIL
6833: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_status_id'
6834: );
6835: RAISE FND_API.G_EXC_ERROR;
6836: END IF; -- l_pending approval flag is Y
6837: */

Line 7092: UPDATE cs_incidents_all_b

7088: l_status_flag:= get_status_flag ( p_status_id);
7089:
7090: -- Update CS_INCIDENTS table
7091: -- for the bug 3027154 - wrong date in the SR Log
7092: UPDATE cs_incidents_all_b
7093: SET incident_status_id = p_status_id,
7094: close_date = l_closed_date,
7095: inc_responded_by_date = l_inc_responded_by_date,
7096: incident_resolved_date= l_incident_resolved_date,

Line 7405: l_resource_type cs_incidents_all_b.resource_type % TYPE;

7401: l_sr_related_data RELATED_DATA_TYPE;
7402: l_owner_group_id jtf_rs_groups_b.group_id % TYPE;
7403: l_workflow_process_id NUMBER;
7404: l_contacts contacts_table;
7405: l_resource_type cs_incidents_all_b.resource_type % TYPE;
7406: l_support_site_id cs_incidents_all_b.site_id % TYPE;
7407:
7408: BEGIN
7409:

Line 7406: l_support_site_id cs_incidents_all_b.site_id % TYPE;

7402: l_owner_group_id jtf_rs_groups_b.group_id % TYPE;
7403: l_workflow_process_id NUMBER;
7404: l_contacts contacts_table;
7405: l_resource_type cs_incidents_all_b.resource_type % TYPE;
7406: l_support_site_id cs_incidents_all_b.site_id % TYPE;
7407:
7408: BEGIN
7409:
7410: -- ---------------------------------------

Line 7656: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'

7652: THEN
7653: FND_MESSAGE.set_name('CS', 'CS_API_SR_ONLY_STATUS_UPDATED');
7654: FND_MESSAGE.set_token('API_NAME', l_api_name_full);
7655: FND_MSG_PUB.add_detail
7656: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_OWNER_ID'
7657: );
7658: RAISE FND_API.G_EXC_ERROR;
7659: END IF;
7660:

Line 7811: UPDATE cs_incidents_all_b

7807: -- Update the owner and insert the audit record
7808: -- ----------------------------------------------
7809: -- Update CS_INCIDENTS table
7810:
7811: UPDATE cs_incidents_all_b
7812: SET incident_owner_id = p_owner_id,
7813: owner_group_id = l_owner_group_id,
7814: resource_type = l_resource_type,
7815: last_updated_by = p_last_updated_by,

Line 9107: l_maint_organization_id cs_incidents_all_b.maint_organization_id % TYPE;

9103: l_busi_proc_id NUMBER;
9104: lx_return_status VARCHAR2(3);
9105: l_old_type_id NUMBER;
9106:
9107: l_maint_organization_id cs_incidents_all_b.maint_organization_id % TYPE;
9108: l_inv_org_master_org_flag VARCHAR2(1);
9109: l_serial_controlled_flag VARCHAR2(3);
9110:
9111: BEGIN

Line 10866: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;

10862: l_ship_to_site_id NUMBER;
10863: l_bill_to_site_use_id NUMBER;
10864: l_ship_to_site_use_id NUMBER;
10865: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
10866: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
10867: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
10868: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
10869: l_territory_id number;
10870: l_orig_group_type_null varchar2(1) := 'N';

Line 10867: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;

10863: l_bill_to_site_use_id NUMBER;
10864: l_ship_to_site_use_id NUMBER;
10865: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
10866: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
10867: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
10868: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
10869: l_territory_id number;
10870: l_orig_group_type_null varchar2(1) := 'N';
10871: l_responded_flag cs_incident_statuses_b.responded_flag % type;

Line 10868: l_asgn_owner_type cs_incidents_all_b.resource_type % type;

10864: l_ship_to_site_use_id NUMBER;
10865: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
10866: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
10867: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
10868: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
10869: l_territory_id number;
10870: l_orig_group_type_null varchar2(1) := 'N';
10871: l_responded_flag cs_incident_statuses_b.responded_flag % type;
10872: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;

Line 11309: FROM cs_incidents_all_b

11305: l_test NUMBER;
11306: BEGIN
11307: SELECT incident_id
11308: INTO l_test
11309: FROM cs_incidents_all_b
11310: WHERE incident_id = p_request_id;
11311:
11312: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11313: ( p_token_an => l_api_name_full,

Line 11338: FROM cs_incidents_all_b

11334: l_test VARCHAR2(250);
11335: BEGIN
11336: SELECT incident_number
11337: INTO l_test
11338: FROM cs_incidents_all_b
11339: WHERE incident_number = p_request_number;
11340:
11341: CS_ServiceRequest_UTIL.Add_Invalid_Argument_Msg
11342: ( p_token_an => l_api_name_full,

Line 13770: SELECT incident_id INTO l_temp_id FROM cs_incidents_all_b

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
13773: WHEN NO_DATA_FOUND THEN
13774: EXIT;

Line 13787: SELECT incident_number INTO l_temp_num FROM cs_incidents_all_b

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
13790: WHEN NO_DATA_FOUND THEN
13791: EXIT;

Line 14302: FROM cs_incidents_all_b b, cs_incidents_all_tl tl

14298: -- Added for Misc ERs project (11.5.10) --anmukher --08/26/03
14299: B.INCIDENT_LOCATION_TYPE ,
14300: --B.PRIMARY_CONTACT_ID
14301: B.maint_organization_id
14302: FROM cs_incidents_all_b b, cs_incidents_all_tl tl
14303: WHERE b.incident_id = p_request_id
14304: AND b.incident_id = tl.incident_id
14305: AND tl.LANGUAGE = DECODE(l_service_request_rec.LANGUAGE,
14306: FND_API.G_MISS_CHAR, USERENV('LANG'),

Line 14366: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;

14362: l_ship_to_site_use_id NUMBER;
14363:
14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
14365: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
14366: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
14367: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
14368: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
14369: l_territory_id number;
14370: l_call_asgn_resource varchar2(1) := 'n';

Line 14367: l_asgn_resource_type cs_incidents_all_b.resource_type % type;

14363:
14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
14365: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
14366: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
14367: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
14368: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
14369: l_territory_id number;
14370: l_call_asgn_resource varchar2(1) := 'n';
14371:

Line 14368: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;

14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
14365: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
14366: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
14367: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
14368: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;
14369: l_territory_id number;
14370: l_call_asgn_resource varchar2(1) := 'n';
14371:
14372: -- For bug 3333340

Line 14377: l_dummy0 cs_incidents_all_b.product_revision % type;

14373: p_passed_value VARCHAR2(3);
14374: l_update_desc_flex_int varchar2(1) := FND_API.G_FALSE;
14375: l_update_desc_flex_ext varchar2(1) := FND_API.G_FALSE;
14376: l_ff_name varchar2(30);
14377: l_dummy0 cs_incidents_all_b.product_revision % type;
14378: l_dummy1 cs_incidents_all_b.component_version % type;
14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;

Line 14378: l_dummy1 cs_incidents_all_b.component_version % type;

14374: l_update_desc_flex_int varchar2(1) := FND_API.G_FALSE;
14375: l_update_desc_flex_ext varchar2(1) := FND_API.G_FALSE;
14376: l_ff_name varchar2(30);
14377: l_dummy0 cs_incidents_all_b.product_revision % type;
14378: l_dummy1 cs_incidents_all_b.component_version % type;
14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;

Line 14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;

14375: l_update_desc_flex_ext varchar2(1) := FND_API.G_FALSE;
14376: l_ff_name varchar2(30);
14377: l_dummy0 cs_incidents_all_b.product_revision % type;
14378: l_dummy1 cs_incidents_all_b.component_version % type;
14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
14383: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;

Line 14471: l_ff_name := 'CS_INCIDENTS_ALL_B';

14467: handle_missing_value(l_service_request_rec.request_attribute_14,l_old_servicerequest_rec.incident_attribute_14);
14468: handle_missing_value(l_service_request_rec.request_attribute_15,l_old_servicerequest_rec.incident_attribute_15);
14469: else
14470: -- incident context is changed. so set all g_miss_char to null except global data segments
14471: l_ff_name := 'CS_INCIDENTS_ALL_B';
14472: set_attribute_value(l_service_request_rec.request_attribute_1,l_old_servicerequest_rec.incident_attribute_1,
14473: l_ff_name,'INCIDENT_ATTRIBUTE_1');
14474:
14475: set_attribute_value(l_service_request_rec.request_attribute_2,l_old_servicerequest_rec.incident_attribute_2,

Line 14523: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',

14519: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
14520: Cs_Servicerequest_Util.Validate_Desc_Flex(
14521: p_api_name => l_api_name_full,
14522: p_application_short_name => 'CS',
14523: p_desc_flex_name => 'CS_INCIDENTS_ALL_B',
14524: p_desc_segment1 => l_service_request_rec.request_attribute_1,
14525: p_desc_segment2 => l_service_request_rec.request_attribute_2,
14526: p_desc_segment3 => l_service_request_rec.request_attribute_3,
14527: p_desc_segment4 => l_service_request_rec.request_attribute_4,

Line 14623: l_ff_name := 'CS_INCIDENTS_ALL_B_EXT';

14619: handle_missing_value(l_service_request_rec.external_attribute_15,l_old_servicerequest_rec.external_attribute_15);
14620: else
14621:
14622: -- context is changed. so set all g_miss_char to null except global data segments
14623: l_ff_name := 'CS_INCIDENTS_ALL_B_EXT';
14624: set_attribute_value(l_service_request_rec.external_attribute_1,l_old_servicerequest_rec.external_attribute_1,
14625: l_ff_name,'EXTERNAL_ATTRIBUTE_1');
14626:
14627: set_attribute_value(l_service_request_rec.external_attribute_2,l_old_servicerequest_rec.external_attribute_2,

Line 14675: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',

14671: p_validation_level > FND_API.G_VALID_LEVEL_NONE) THEN
14672: Cs_ServiceRequest_Util.Validate_external_Desc_Flex
14673: ( p_api_name => l_api_name_full,
14674: p_application_short_name => 'CS',
14675: p_ext_desc_flex_name => 'CS_INCIDENTS_ALL_B_EXT',
14676: p_ext_desc_segment1 => l_service_request_rec.external_attribute_1,
14677: p_ext_desc_segment2 => l_service_request_rec.external_attribute_2,
14678: p_ext_desc_segment3 => l_service_request_rec.external_attribute_3,
14679: p_ext_desc_segment4 => l_service_request_rec.external_attribute_4,

Line 15014: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'

15010: THEN
15011: FND_MESSAGE.Set_Name('CS', 'CS_SR_APPROVAL_NEEDED');
15012: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15013: FND_MSG_PUB.ADD_DETAIL
15014: ( p_associated_column1 => 'CS_INCIDENTS_ALL_B.INCIDENT_STATUS_ID'
15015: );
15016: RAISE FND_API.G_EXC_ERROR;
15017: END IF;
15018: -- if new status has pending approval flag then it means ERES update is in

Line 15042: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'

15038: FND_MESSAGE.Set_Name('CS', 'CS_API_SR_OWNER_NOT_UPDATED');
15039: FND_MESSAGE.Set_Token('API_NAME', l_api_name_full);
15040: FND_MSG_PUB.ADD_DETAIL
15041: ( p_message_type=>FND_MSG_PUB.G_INFORMATION_MSG
15042: , p_associated_column1 => 'CS_INCIDENTS_ALL_B.incident_owner_id'
15043: );
15044: --END IF;
15045: END IF;
15046: l_service_request_rec.owner_id := l_old_ServiceRequest_rec.incident_owner_id;

Line 19060: FROM CS_INCIDENTS_ALL_B B

19056: BEGIN
19057: DELETE FROM CS_INCIDENTS_ALL_TL T
19058: WHERE NOT EXISTS
19059: (SELECT NULL
19060: FROM CS_INCIDENTS_ALL_B B
19061: WHERE B.INCIDENT_ID = T.INCIDENT_ID
19062: );
19063:
19064: UPDATE CS_INCIDENTS_ALL_TL T SET (

Line 19199: FROM CS_INCIDENTS_ALL_B

19195: )
19196: IS
19197: CURSOR C IS
19198: SELECT OBJECT_VERSION_NUMBER
19199: FROM CS_INCIDENTS_ALL_B
19200: WHERE INCIDENT_ID = X_INCIDENT_ID
19201: FOR UPDATE OF INCIDENT_ID NOWAIT;
19202:
19203: RECINFO C%ROWTYPE;

Line 19256: FROM CS_INCIDENTS_ALL_B

19252: CURSOR c_imp_old_csr IS
19253: SELECT importance_level
19254: FROM cs_incident_severities_b
19255: WHERE incident_severity_id =( SELECT incident_severity_id
19256: FROM CS_INCIDENTS_ALL_B
19257: WHERE incident_id = p_incident_id);
19258: l_old_imp_level NUMBER;
19259: BEGIN
19260: OPEN c_imp_old_csr;

Line 19270: FROM cs_incidents_all_b

19266: FUNCTION Get_Owner_id(p_incident_id IN NUMBER)
19267: RETURN NUMBER IS
19268: CURSOR c_owner_id IS
19269: SELECT incident_owner_id
19270: FROM cs_incidents_all_b
19271: WHERE incident_id = p_incident_id;
19272: l_owner_id NUMBER;
19273: BEGIN
19274: OPEN c_owner_id;

Line 19316: inserting into cs_incidents_all_b table. If the closed flag is Y then

19312: RETURN(l_uwq_message);
19313: END Get_Message;
19314:
19315: /* Added for enh.2655115, procedure to get the value of status_flag for
19316: inserting into cs_incidents_all_b table. If the closed flag is Y then
19317: the status is closed, else its open.created by shijain dated nov 27th 2002*/
19318:
19319: FUNCTION GET_STATUS_FLAG( p_incident_status_id IN NUMBER)
19320: RETURN VARCHAR2 IS

Line 19346: inserting into cs_incidents_all_b table based on the incident_id and the

19342:
19343:
19344:
19345: /* Added for enh.2690787, procedure to get the value of primary_contact_id for
19346: inserting into cs_incidents_all_b table based on the incident_id and the
19347: primary flag from the cs_hz_sr_contact_points table by shijain
19348:
19349: FUNCTION GET_PRIMARY_CONTACT( p_incident_id IN NUMBER)
19350: RETURN NUMBER IS