APPS.CS_SERVICEREQUEST_PVT dependencies on FND_PROFILE_OPTION_VALUES

Line 406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;

402: l_log_module VARCHAR2(255) ;
403: l_contract_defaulted VARCHAR2(1);
404: l_msg_count NUMBER;
405: l_msg_data VARCHAR2(2000);
406: l_auto_assign_level fnd_profile_option_values.profile_option_value % TYPE;
407: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % TYPE;
408: l_asgn_resource_type cs_incidents_all_b.resource_type % TYPE;
409: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % TYPE;
410: l_asgn_owner_type cs_incidents_all_b.resource_type % TYPE;

Line 1428: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;

1424: -- local variable for validate owner
1425: lx_owner_name VARCHAR2(240);
1426: lx_owner_id NUMBER;
1427: x_msg_index_out NUMBER;
1428: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
1429:
1430: -- Local variable to store the request_id, to be passed to IEU procedure.
1431: q_request_id NUMBER;
1432: l_note_status VARCHAR2(3);

Line 11896: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;

11892: l_bill_to_site_id NUMBER;
11893: l_ship_to_site_id NUMBER;
11894: l_bill_to_site_use_id NUMBER;
11895: l_ship_to_site_use_id NUMBER;
11896: l_auto_assign_level fnd_profile_option_values.profile_option_value % type;
11897: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
11898: l_asgn_group_id cs_incidents_all_b.owner_group_id % type;
11899: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
11900: l_territory_id number;

Line 15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=

15567: l_ship_to_site_id NUMBER;
15568: l_bill_to_site_use_id NUMBER;
15569: l_ship_to_site_use_id NUMBER;
15570:
15571: l_auto_assign_level fnd_profile_option_values.profile_option_value % type :=
15572: fnd_profile.value('CS_SR_OWNER_AUTO_ASSIGN_LEVEL');
15573: l_asgn_owner_id cs_incidents_all_b.incident_owner_id % type;
15574: l_asgn_resource_type cs_incidents_all_b.resource_type % type;
15575: l_asgn_owner_group_id cs_incidents_all_b.owner_group_id % type;