APPS.SR_UWQ_INTEG dependencies on CS_INCIDENTS_ALL_B

Line 1151: cs_incidents_all_b where incident_number = p_parameter_value;

1147: v_cust_number_temp varchar2(60);
1148:
1149: -- Validate the Incident number.
1150: cursor inc_cursor is select incident_id from
1151: cs_incidents_all_b where incident_number = p_parameter_value;
1152:
1153: -- Validate the RMA Number
1154: -- This cursor will get the Inc. Number associated to
1155: -- the RMA Number. If not found it just passes the RMA Number.

Line 1160: cs_incidents_all_b inc

1156: cursor rma_cursor is
1157: select inc.incident_id,inc.incident_number
1158: from oe_order_headers_all oe,
1159: cs_estimate_details chg,
1160: cs_incidents_all_b inc
1161: where oe.order_number = p_parameter_value
1162: and oe.order_category_code in ('RETURN','MIXED')
1163: and oe.header_id = chg.order_header_id
1164: and chg.incident_id = inc.incident_id;

Line 1168: -- non-validated Tag number in CS_INCIDENTS_ALL_B cannot

1164: and chg.incident_id = inc.incident_id;
1165:
1166: -- Validate the Tag Number
1167: -- The validation is done against CSI Schema only. The
1168: -- non-validated Tag number in CS_INCIDENTS_ALL_B cannot
1169: -- be passed as parameter.
1170: cursor tag_cursor is
1171: select item.instance_id, item.owner_party_id,
1172: hzp.party_type

Line 1511: cs_incidents_all_b where incident_number = p_ivr_data_value;

1507: cursor sec_value is select sr_agent_security
1508: from cs_system_options where rownum = 1;
1509:
1510: cursor sr_cursor is select incident_id from
1511: cs_incidents_all_b where incident_number = p_ivr_data_value;
1512:
1513: cursor sr_type_sec_chk is select 'Y' from
1514: cs_sr_type_mapping where incident_type_id = n_incident_id
1515: and responsibility_id= n_resp_id

Line 1699: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc

1695: l_cs_html VARCHAR2(1000);
1696:
1697: CURSOR SR_Cur is
1698: Select Inc.Incident_number,Inc.Incident_id
1699: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc
1700: where Tsk.Task_id=l_Task_id
1701: and Inc.Incident_Id=Tsk.source_object_id;
1702:
1703:

Line 3483: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc

3479: l_Req_id number;
3480: l_Task_id NUMBER;
3481: CURSOR SR_Cur is
3482: Select Inc.Incident_id
3483: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc
3484: where Tsk.Task_id=l_Task_id
3485: and Inc.Incident_Id=Tsk.source_object_id;
3486: BEGIN
3487: FOR i IN p_ieu_action_data.first.. p_ieu_action_data.last