APPS.CS_SERVICEREQUEST_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 414: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;

410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;
411: l_territory_id NUMBER;
412: l_orig_group_type_null varchar2(1) := 'N';
413: l_owner_id CS_INCIDENTS_ALL_B.incident_owner_id % TYPE;
414: l_owner_name jtf_rs_resource_extns_tl.resource_name % TYPE;
415: --siahmed 12.1.2 project
416: l_request_date DATE;
417: -- end of addition by siahmed
418: BEGIN

Line 11890: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;

11886: l_contract_number VARCHAR2(120) ;
11887: l_contract_id NUMBER;
11888: l_group_name VARCHAR2(60);
11889: l_owner_name VARCHAR2(360);
11890: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;
11891: l_operation VARCHAR2(300):='created';
11892: l_bill_to_site_id NUMBER;
11893: l_ship_to_site_id NUMBER;
11894: l_bill_to_site_use_id NUMBER;

Line 12160: FROM jtf_rs_resource_extns_tl

12156: l_service_request_rec.owner_id <> FND_API.G_MISS_NUM) THEN
12157:
12158: SELECT resource_name
12159: INTO l_service_request_rec.owner
12160: FROM jtf_rs_resource_extns_tl
12161: WHERE resource_id = l_service_request_rec.owner_id
12162: AND LANGUAGE = USERENV('LANG');
12163: END IF;
12164:

Line 15287: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;

15283: l_contract_number VARCHAR2(120) ;
15284:
15285: l_group_name VARCHAR2(60);
15286: l_owner_name VARCHAR2(360);
15287: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;
15288: l_operation VARCHAR2(300):= 'updated' ;
15289: l_temp_close_flag VARCHAR2(1);
15290:
15291: OnlyUpdStatus EXCEPTION;

Line 16504: FROM jtf_rs_resource_extns_tl

16500: -- for bug 2770831 added Begin End and Exception to handle NO_DATA_FOUND.
16501:
16502: BEGIN
16503: SELECT resource_name INTO l_service_request_rec.owner
16504: FROM jtf_rs_resource_extns_tl
16505: WHERE resource_id = l_service_request_rec.owner_id
16506: AND LANGUAGE = USERENV('LANG');
16507: EXCEPTION
16508: WHEN NO_DATA_FOUND THEN