APPS.AHL_COMPLEX_MX_RWSC_PVT dependencies on AHL_VISIT_INST_ROUTINGS

Line 355: -- Function : This procedure will update the table AHL_VISIT_INST_ROUTINGS

351: ------------------------------------------------------------------------------------------------------
352: -- Start of Comments
353: -- Procedure name : Process_instance_routings
354: -- Type : Public
355: -- Function : This procedure will update the table AHL_VISIT_INST_ROUTINGS
356: -- OLD_INST_ROUTING_CODE params is old INST_ROUTING_CODE, used for update/delete case
357: -- Pre-reqs :
358: -- Parameters :
359: --

Line 663: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC

659: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);
660:
661: CURSOR get_inst_routings_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
662: SELECT VIR.inst_routing_id, VIR.object_version_number, VIR.inst_routing_code, IRC.meaning
663: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC
664: WHERE VIR.instance_id = c_instance_id
665: AND VIR.visit_id = c_visit_id
666: AND IRC.lookup_code (+) = VIR.inst_routing_code
667: AND IRC.lookup_type (+) = 'AHL_INSTANCE_ROUTING';

Line 1025: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC

1021: AND CSI.inv_master_organization_id = MTL.organization_id;
1022:
1023: CURSOR get_inst_routings_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
1024: SELECT VIR.inst_routing_id, VIR.object_version_number, VIR.inst_routing_code, IRC.meaning
1025: FROM AHL_VISIT_INST_ROUTINGS VIR, FND_LOOKUP_VALUES_VL IRC
1026: WHERE VIR.instance_id = c_instance_id
1027: AND VIR.visit_id = c_visit_id
1028: AND IRC.lookup_code (+) = VIR.inst_routing_code
1029: AND IRC.lookup_type (+) = 'AHL_INSTANCE_ROUTING';

Line 1221: l_inst_routing_id := AHL_VISIT_INST_ROUTINGS_S.NEXTVAL;

1217: END IF;
1218: CLOSE validate_instance_csr;
1219:
1220: -- fetch the next value from the sequence
1221: l_inst_routing_id := AHL_VISIT_INST_ROUTINGS_S.NEXTVAL;
1222:
1223: -- insert a record in the AHL_VISIT_INST_ROUTINGS table
1224: INSERT INTO AHL_VISIT_INST_ROUTINGS
1225: (

Line 1223: -- insert a record in the AHL_VISIT_INST_ROUTINGS table

1219:
1220: -- fetch the next value from the sequence
1221: l_inst_routing_id := AHL_VISIT_INST_ROUTINGS_S.NEXTVAL;
1222:
1223: -- insert a record in the AHL_VISIT_INST_ROUTINGS table
1224: INSERT INTO AHL_VISIT_INST_ROUTINGS
1225: (
1226: INST_ROUTING_ID,
1227: VISIT_ID,

Line 1224: INSERT INTO AHL_VISIT_INST_ROUTINGS

1220: -- fetch the next value from the sequence
1221: l_inst_routing_id := AHL_VISIT_INST_ROUTINGS_S.NEXTVAL;
1222:
1223: -- insert a record in the AHL_VISIT_INST_ROUTINGS table
1224: INSERT INTO AHL_VISIT_INST_ROUTINGS
1225: (
1226: INST_ROUTING_ID,
1227: VISIT_ID,
1228: INSTANCE_ID,

Line 1287: FROM AHL_VISIT_INST_ROUTINGS

1283:
1284: -- cursor to validate the given routing id
1285: CURSOR validate_routing_csr (c_inst_routing_id NUMBER) IS
1286: SELECT *
1287: FROM AHL_VISIT_INST_ROUTINGS
1288: WHERE inst_routing_id = c_inst_routing_id;
1289:
1290: l_api_name CONSTANT VARCHAR2(30) := 'Update_Instance_Routing';
1291: l_inst_routings_rec validate_routing_csr%ROWTYPE;

Line 1331: -- update a record in the AHL_VISIT_INST_ROUTINGS table

1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: RETURN;
1329: END IF;
1330:
1331: -- update a record in the AHL_VISIT_INST_ROUTINGS table
1332: UPDATE AHL_VISIT_INST_ROUTINGS SET
1333: inst_routing_code = p_inst_routing_code,
1334: object_version_number = object_version_number + 1,
1335: security_group_id = NULL,

Line 1332: UPDATE AHL_VISIT_INST_ROUTINGS SET

1328: RETURN;
1329: END IF;
1330:
1331: -- update a record in the AHL_VISIT_INST_ROUTINGS table
1332: UPDATE AHL_VISIT_INST_ROUTINGS SET
1333: inst_routing_code = p_inst_routing_code,
1334: object_version_number = object_version_number + 1,
1335: security_group_id = NULL,
1336: last_update_date = SYSDATE,

Line 1368: FROM AHL_VISIT_INST_ROUTINGS

1364: l_dummy VARCHAR2(1);
1365: -- cursor to validate the given routing id
1366: CURSOR validate_routing_csr (c_inst_routing_id NUMBER) IS
1367: SELECT 'X'
1368: FROM AHL_VISIT_INST_ROUTINGS
1369: WHERE inst_routing_id = c_inst_routing_id;
1370: l_inst_routings_rec validate_routing_csr%ROWTYPE;
1371:
1372: BEGIN

Line 1395: DELETE FROM AHL_VISIT_INST_ROUTINGS

1391: END IF;
1392: CLOSE validate_routing_csr;
1393:
1394: -- delete row
1395: DELETE FROM AHL_VISIT_INST_ROUTINGS
1396: WHERE inst_routing_id = p_inst_routing_id;
1397:
1398: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1399: FND_LOG.string(FND_LOG.level_procedure, 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||'.end',