[Home] [Help]
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.
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;
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
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
1687: l_Task_id NUMBER;
1688:
1689: CURSOR SR_Cur is
1690: Select Inc.Incident_number
1691: from Jtf_tasks_b Tsk, CS_incidents_all_b Inc
1692: where Tsk.Task_id=l_Task_id
1693: and Inc.Incident_Id=Tsk.source_object_id;
1694:
1695: