APPS.CS_SERVICEREQUEST_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 382: l_owner_name jtf_rs_resource_extns_tl.resource_name % 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 || '.';
386: l_contract_service_id_valid := 'Y';

Line 10859: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;

10855: l_contract_number VARCHAR2(120) ;
10856: l_contract_id NUMBER;
10857: l_group_name VARCHAR2(60);
10858: l_owner_name VARCHAR2(360);
10859: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;
10860: l_operation VARCHAR2(300):='created';
10861: l_bill_to_site_id NUMBER;
10862: l_ship_to_site_id NUMBER;
10863: l_bill_to_site_use_id NUMBER;

Line 11129: FROM jtf_rs_resource_extns_tl

11125: l_service_request_rec.owner_id <> FND_API.G_MISS_NUM) THEN
11126:
11127: SELECT resource_name
11128: INTO l_service_request_rec.owner
11129: FROM jtf_rs_resource_extns_tl
11130: WHERE resource_id = l_service_request_rec.owner_id
11131: AND LANGUAGE = USERENV('LANG');
11132: END IF;
11133:

Line 14092: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;

14088: l_contract_number VARCHAR2(120) ;
14089:
14090: l_group_name VARCHAR2(60);
14091: l_owner_name VARCHAR2(360);
14092: l_owner_id jtf_rs_resource_extns.resource_id % TYPE;
14093: l_operation VARCHAR2(300):= 'updated' ;
14094: l_temp_close_flag VARCHAR2(1);
14095:
14096: OnlyUpdStatus EXCEPTION;

Line 15239: FROM jtf_rs_resource_extns_tl

15235: -- for bug 2770831 added Begin End and Exception to handle NO_DATA_FOUND.
15236:
15237: BEGIN
15238: SELECT resource_name INTO l_service_request_rec.owner
15239: FROM jtf_rs_resource_extns_tl
15240: WHERE resource_id = l_service_request_rec.owner_id
15241: AND LANGUAGE = USERENV('LANG');
15242: EXCEPTION
15243: WHEN NO_DATA_FOUND THEN