191: ) RETURN VARCHAR2 IS
192:
193: CURSOR c_incident IS
194: SELECT 'Y'
195: FROM cs_incidents_all_b
196: WHERE incident_id = p_incident_id;
197:
198: lv_exists_flag VARCHAR2(1) := 'N';
199: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_incident_id_valid';
278: x_return_status OUT NOCOPY VARCHAR2) IS
279:
280: CURSOR c_val_ch_source(p_source_id IN NUMBER) IS
281: SELECT incident_id
282: FROM CS_INCIDENTS_ALL_B
283: WHERE incident_id =p_source_id;
284:
285: CURSOR c_val_dr_source(p_source_id IN NUMBER) IS
286: SELECT repair_line_id
1177: ) IS
1178:
1179: CURSOR c_get_sr_org(p_incident_id IN NUMBER) IS
1180: SELECT inv_organization_id, org_id
1181: FROM cs_incidents_all_b cia
1182: WHERE cia.incident_id = p_incident_id;
1183:
1184: lv_exists_flag VARCHAR2(1) := 'N';
1185: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'GET_SR_ORG_INFO';