eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENT_STATUSES_B

Line 10871: l_responded_flag cs_incident_statuses_b.responded_flag % 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;
10870: l_orig_group_type_null varchar2(1) := 'N';
10871: l_responded_flag cs_incident_statuses_b.responded_flag % type;
10872: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;
10873: BEGIN
10874:
10875: -- Initialize the New Auit Record

Line 10872: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;

10868: l_asgn_owner_type cs_incidents_all_b.resource_type % type;
10869: l_territory_id number;
10870: l_orig_group_type_null varchar2(1) := 'N';
10871: l_responded_flag cs_incident_statuses_b.responded_flag % type;
10872: l_resolved_flag cs_incident_statuses_b.resolved_flag % type;
10873: BEGIN
10874:
10875: -- Initialize the New Auit Record
10876: Initialize_audit_rec(

Line 14001: -- Removed queries on cs_incident_statuses_b table that were

13997: -- date effectivity check.
13998: -- 07/20/05 smisra replaced individual vars from get_status_details call with
13999: -- structure l_sr_related_data members
14000: --
14001: -- Removed queries on cs_incident_statuses_b table that were
14002: -- present inside comments. These queries are replaced with
14003: -- cs_servicerequest_util.get_status_details call
14004: --
14005: -- Modified condition for calling auto assignment and added

Line 14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;

14377: l_dummy0 cs_incidents_all_b.product_revision % type;
14378: l_dummy1 cs_incidents_all_b.component_version % type;
14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
14383: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
14384: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
14385:

Line 14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;

14378: l_dummy1 cs_incidents_all_b.component_version % type;
14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
14383: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
14384: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
14385:
14386: l_sr_related_data RELATED_DATA_TYPE;

Line 14383: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;

14379: l_dummy2 cs_incidents_all_b.subcomponent_version % type;
14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
14383: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
14384: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
14385:
14386: l_sr_related_data RELATED_DATA_TYPE;
14387: BEGIN

Line 14384: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;

14380:
14381: l_pending_approval_flag cs_incident_statuses_b.pending_approval_flag % TYPE;
14382: l_intermediate_status_id cs_incident_statuses_b.intermediate_status_id % TYPE;
14383: l_approval_status_id cs_incident_statuses_b.approval_action_status_id % TYPE;
14384: l_rejection_status_id cs_incident_statuses_b.rejection_action_status_id % TYPE;
14385:
14386: l_sr_related_data RELATED_DATA_TYPE;
14387: BEGIN
14388:

Line 19323: FROM cs_incident_statuses_b

19319: FUNCTION GET_STATUS_FLAG( p_incident_status_id IN NUMBER)
19320: RETURN VARCHAR2 IS
19321: CURSOR get_close_flag IS
19322: SELECT close_flag
19323: FROM cs_incident_statuses_b
19324: WHERE incident_status_id = p_incident_status_id;
19325:
19326: l_closed_flag VARCHAR2(1);
19327: l_status_flag VARCHAR2(1):='O';