[Home] [Help]
7709: -- doesn't have 'Disallow Request Update Checked'. - lkullamb
7710: -- ------------------------------------------------------------------
7711: SELECT disallow_request_update
7712: INTO l_new_disallow_request_update
7713: FROM cs_incident_statuses_b
7714: WHERE incident_status_id = p_status_id
7715: AND incident_subtype = G_SR_SUBTYPE;
7716:
7717:
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;
11901: l_orig_group_type_null varchar2(1) := 'N';
11902: l_responded_flag cs_incident_statuses_b.responded_flag % type;
11903: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;
11904: BEGIN
11905:
11906: -- Initialize the New Auit Record
11899: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
11900: l_territory_id number;
11901: l_orig_group_type_null varchar2(1) := 'N';
11902: l_responded_flag cs_incident_statuses_b.responded_flag % type;
11903: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;
11904: BEGIN
11905:
11906: -- Initialize the New Auit Record
11907: Initialize_audit_rec(
15192: -- date effectivity check.
15193: -- 07/20/05 smisra replaced individual vars from get_status_details call with
15194: -- structure l_sr_related_data members
15195: --
15196: -- Removed queries on cs_incident_statuses_b table that were
15197: -- present inside comments. These queries are replaced with
15198: -- cs_servicerequest_util.get_status_details call
15199: --
15200: -- Modified condition for calling auto assignment and added
15584: l_dummy0 cs_incidents_all_b.product_revision % type;
15585: l_dummy1 cs_incidents_all_b.component_version % type;
15586: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15589: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
15590: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
15591: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
15592:
15585: l_dummy1 cs_incidents_all_b.component_version % type;
15586: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15589: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
15590: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
15591: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
15592:
15593: l_sr_related_data RELATED_DATA_TYPE;
15586: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15589: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
15590: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
15591: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
15592:
15593: l_sr_related_data RELATED_DATA_TYPE;
15594:
15587:
15588: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
15589: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
15590: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
15591: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
15592:
15593: l_sr_related_data RELATED_DATA_TYPE;
15594:
15595: --Added variable for bug 14242503
20835: FUNCTION GET_STATUS_FLAG( p_incident_status_id IN NUMBER)
20836: RETURN VARCHAR2 IS
20837: CURSOR get_close_flag IS
20838: SELECT close_flag
20839: FROM cs_incident_statuses_b
20840: WHERE incident_status_id = p_incident_status_id;
20841:
20842: l_closed_flag VARCHAR2(1);
20843: l_status_flag VARCHAR2(1):='O';