APPS.CS_SERVICEREQUEST_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 374: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;

370: l_log_module VARCHAR2(255) ;
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;

Line 1376: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;

1372: -- local variable for validate owner
1373: lx_owner_name VARCHAR2(240);
1374: lx_owner_id NUMBER;
1375: x_msg_index_out NUMBER;
1376: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
1377:
1378: -- Local variable to store the request_id, to be passed to IEU procedure.
1379: q_request_id NUMBER;
1380: l_note_status VARCHAR2(3);

Line 10865: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;

10861: l_bill_to_site_id NUMBER;
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;

Line 14364: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=

14360: l_ship_to_site_id NUMBER;
14361: l_bill_to_site_use_id NUMBER;
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;