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.EAM_SCHED_BOTTOM_UP_PVT dependencies on WIP_OPERATION_RESOURCE_USAGE

Line 168: UPDATE wip_operation_resource_usage

164: AND resource_seq_num = l_res_seq_num;
165:
166: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating WORU start date for resource') ; END IF ;
167:
168: UPDATE wip_operation_resource_usage
169: SET start_date = l_res_start_date ,
170: last_update_date = sysdate ,
171: last_updated_by = FND_GLOBAL.user_id ,
172: creation_date = sysdate ,

Line 179: FROM wip_operation_resource_usage

175: WHERE wip_entity_id = l_wip_id
176: AND operation_seq_num = l_op_seq_num
177: AND resource_seq_num = l_res_seq_num
178: AND start_date = ( SELECT MIN(start_date)
179: FROM wip_operation_resource_usage
180: WHERE wip_entity_id = l_wip_id
181: AND operation_seq_num = l_op_seq_num
182: AND resource_seq_num = l_res_seq_num
183: AND instance_id IS NULL

Line 190: UPDATE wip_operation_resource_usage

186: AND serial_number IS NULL;
187:
188: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Updating WORU end date for resource') ; END IF ;
189:
190: UPDATE wip_operation_resource_usage
191: SET completion_date = l_res_end_date ,
192: last_update_date = sysdate ,
193: last_updated_by = FND_GLOBAL.user_id ,
194: creation_date = sysdate ,

Line 201: FROM wip_operation_resource_usage

197: WHERE wip_entity_id = l_wip_id
198: AND operation_seq_num = l_op_seq_num
199: AND resource_seq_num = l_res_seq_num
200: AND completion_date = ( SELECT MAX(completion_date)
201: FROM wip_operation_resource_usage
202: WHERE wip_entity_id = l_wip_id
203: AND operation_seq_num = l_op_seq_num
204: AND resource_seq_num = l_res_seq_num
205: AND instance_id IS NULL

Line 507: FROM wip_operation_resource_usage

503: WHERE wip_entity_id = c_wip_entity_id;
504:
505: CURSOR get_inst_usage_min_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
506: SELECT MIN(start_date) as min_inst_usg_date
507: FROM wip_operation_resource_usage
508: WHERE wip_entity_id = c_wip_entity_id
509: AND operation_seq_num = c_op_seq_num
510: AND resource_seq_num = c_res_seq_num
511: AND (instance_id IS NOT NULL OR serial_number IS not NULL) ;

Line 515: FROM wip_operation_resource_usage

511: AND (instance_id IS NOT NULL OR serial_number IS not NULL) ;
512:
513: CURSOR get_inst_usage_max_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
514: SELECT MAX(completion_date) as max_inst_usg_date
515: FROM wip_operation_resource_usage
516: WHERE wip_entity_id = c_wip_entity_id
517: AND operation_seq_num = c_op_seq_num
518: AND resource_seq_num = c_res_seq_num
519: AND (instance_id is not null OR serial_number IS not NULL) ;

Line 524: FROM wip_operation_resource_usage

520:
521: CURSOR get_woru_min_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ,
522: c_instance_id NUMBER , c_serial_num VARCHAR2 ) IS
523: SELECT MIN(start_date) as min_inst_usg_date
524: FROM wip_operation_resource_usage
525: WHERE wip_entity_id = c_wip_entity_id
526: AND operation_seq_num = c_op_seq_num
527: AND resource_seq_num = c_res_seq_num
528: AND instance_id = c_instance_id

Line 534: FROM wip_operation_resource_usage

530:
531: CURSOR get_woru_max_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ,
532: c_instance_id NUMBER , c_serial_num VARCHAR2 ) IS
533: SELECT MAX(completion_date) as max_inst_usg_date
534: FROM wip_operation_resource_usage
535: WHERE wip_entity_id = c_wip_entity_id
536: AND operation_seq_num = c_op_seq_num
537: AND resource_seq_num = c_res_seq_num
538: AND instance_id = c_instance_id

Line 543: FROM wip_operation_resource_usage

539: AND ( serial_number IS NULL OR serial_number = c_serial_num);
540:
541: CURSOR get_res_usage_min_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
542: SELECT MIN(start_date) as min_res_usg_date
543: FROM wip_operation_resource_usage
544: WHERE wip_entity_id = c_wip_entity_id
545: AND operation_seq_num = c_op_seq_num
546: AND resource_seq_num = c_res_seq_num
547: AND instance_id IS NULL

Line 552: FROM wip_operation_resource_usage

548: AND serial_number IS NULL ;
549:
550: CURSOR get_res_usage_max_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
551: SELECT MAX(completion_date) as max_inst_usg_date
552: FROM wip_operation_resource_usage
553: WHERE wip_entity_id = c_wip_entity_id
554: AND operation_seq_num = c_op_seq_num
555: AND resource_seq_num = c_res_seq_num
556: AND instance_id IS NULL

Line 561: FROM wip_operation_resource_usage

557: AND serial_number IS NULL ;
558:
559: CURSOR get_instdates( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
560: SELECT start_date, completion_date, instance_id, serial_number
561: FROM wip_operation_resource_usage
562: WHERE wip_entity_id = c_wip_entity_id
563: AND operation_seq_num = c_op_seq_num
564: AND resource_seq_num = c_res_seq_num;
565:

Line 629: UPDATE wip_operation_resource_usage

625: IF p_woru_modified = 'Y' THEN
626:
627: --/* Adjust WORU and WORU' dates
628: IF c_instusage_min_date < c_resusagemin_date THEN
629: UPDATE wip_operation_resource_usage
630: SET start_date = c_instusage_min_date
631: WHERE wip_entity_id = p_wip_entity_id
632: AND operation_seq_num = c_opresource_rec.operation_seq_num
633: AND resource_seq_num = c_opresource_rec.resource_seq_num

Line 643: UPDATE wip_operation_resource_usage

639: --l_resourcemin_expanded = 1;
640: END IF;
641:
642: IF c_instusage_max_date > c_resusagemax_date THEN
643: UPDATE wip_operation_resource_usage
644: SET completion_date = c_instusage_max_date
645: WHERE wip_entity_id = p_wip_entity_id
646: AND operation_seq_num = c_opresource_rec.operation_seq_num
647: AND resource_seq_num = c_opresource_rec.resource_seq_num

Line 833: * Purpose : Inserts a resource usage record in wip_operation_resource_usage table

829: /*************************************************************************************************************************
830: * Procedure : insert_into_woru
831: * Parameters IN : p_eam_res_usage_rec
832: * Parameters OUT : x_return_status
833: * Purpose : Inserts a resource usage record in wip_operation_resource_usage table
834: ************************************************************************************************************************/
835:
836: procedure insert_into_woru ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type,
837: x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 841: FROM WIP_OPERATION_RESOURCE_USAGE

837: x_return_status OUT NOCOPY VARCHAR2 ) IS
838:
839: CURSOR res_usage_rec_check_csr IS
840: SELECT 1
841: FROM WIP_OPERATION_RESOURCE_USAGE
842: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
843: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
844: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num
845: AND start_date = p_eam_res_usage_rec.start_date

Line 852: FROM WIP_OPERATION_RESOURCE_USAGE

848: AND serial_number IS NULL ;
849:
850: CURSOR inst_usage_rec_check_csr IS
851: SELECT 1
852: FROM WIP_OPERATION_RESOURCE_USAGE
853: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
854: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
855: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num
856: AND start_date = p_eam_res_usage_rec.start_date

Line 893: INSERT INTO WIP_OPERATION_RESOURCE_USAGE

889:
890: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Insert record in WORU ' ) ; END IF ;
891:
892: BEGIN
893: INSERT INTO WIP_OPERATION_RESOURCE_USAGE
894: ( wip_entity_id
895: , operation_seq_num
896: , resource_seq_num
897: , organization_id

Line 947: * Purpose : Table Handler :- Updates a resource usage record in wip_operation_resource_usage table

943:
944: /*************************************************************************************************************************
945: * Procedure : update_woru
946: * Parameters IN : p_eam_res_usage_rec
947: * Purpose : Table Handler :- Updates a resource usage record in wip_operation_resource_usage table
948: ************************************************************************************************************************/
949:
950:
951: procedure update_woru( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type) IS

Line 958: UPDATE WIP_OPERATION_RESOURCE_USAGE

954: IF p_eam_res_usage_rec.instance_id IS NULL THEN
955:
956: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Inside update_woru: Updating resource record ' ) ; END IF ;
957:
958: UPDATE WIP_OPERATION_RESOURCE_USAGE
959: SET start_date = p_eam_res_usage_rec.start_date ,
960: completion_date = p_eam_res_usage_rec.completion_date ,
961: last_update_date = sysdate ,
962: last_updated_by = FND_GLOBAL.user_id ,

Line 976: UPDATE WIP_OPERATION_RESOURCE_USAGE

972: AND instance_id IS NULL ;
973: ELSE
974: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Inside update_woru: Updating resource Instance record ' ) ; END IF ;
975:
976: UPDATE WIP_OPERATION_RESOURCE_USAGE
977: SET start_date = p_eam_res_usage_rec.start_date ,
978: completion_date = p_eam_res_usage_rec.completion_date ,
979: last_update_date = sysdate ,
980: last_updated_by = FND_GLOBAL.user_id ,

Line 1000: * Purpose : Table Handler :- Deletes a resource usage record in wip_operation_resource_usage table

996:
997: /*************************************************************************************************************************
998: * Procedure : delete_from_woru
999: * Parameters IN : p_eam_res_usage_rec
1000: * Purpose : Table Handler :- Deletes a resource usage record in wip_operation_resource_usage table
1001: ************************************************************************************************************************/
1002:
1003: procedure delete_from_woru( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type ) IS
1004: l_count NUMBER;

Line 1009: DELETE FROM WIP_OPERATION_RESOURCE_USAGE

1005: BEGIN
1006:
1007: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(' Inside delete_from_woru' ) ; END IF ;
1008:
1009: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
1010: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
1011: AND operation_seq_num = p_eam_res_usage_rec.operation_seq_num
1012: AND organization_id = p_eam_res_usage_rec.organization_id
1013: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num

Line 1022: FROM wip_operation_resource_usage

1018: --check if no records in woru
1019:
1020: SELECT count(*)
1021: INTO l_count
1022: FROM wip_operation_resource_usage
1023: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
1024: AND operation_seq_num =p_eam_res_usage_rec.operation_seq_num
1025: AND organization_id = p_eam_res_usage_rec.organization_id
1026: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num

Line 1102: FROM wip_operation_resource_usage

1098:
1099:
1100: SELECT count(*)
1101: INTO l_count
1102: FROM wip_operation_resource_usage
1103: WHERE wip_entity_id = p_eam_res_usage_rec.wip_entity_id
1104: AND operation_seq_num =p_eam_res_usage_rec.operation_seq_num
1105: AND organization_id = p_eam_res_usage_rec.organization_id
1106: AND resource_seq_num = p_eam_res_usage_rec.resource_seq_num

Line 1116: FROM wip_operation_resource_usage

1112: END IF;
1113:
1114: SELECT min(start_date), max(completion_date)
1115: INTO l_min_start_date,l_max_completion_date
1116: FROM wip_operation_resource_usage
1117: WHERE wip_entity_id = l_wip_entity_id
1118: AND operation_seq_num = l_operation_seq_num
1119: AND organization_id = l_org_id
1120: AND resource_seq_num = l_res_seq_num

Line 1259: FROM wip_operation_resource_usage

1255: BEGIN
1256:
1257: SELECT min(start_date), max(completion_date)
1258: INTO l_min_start_date,l_max_completion_date
1259: FROM wip_operation_resource_usage
1260: WHERE wip_entity_id = l_wip_entity_id
1261: AND operation_seq_num = l_operation_seq_num
1262: AND organization_id = l_org_id
1263: AND resource_seq_num = l_res_seq_num

Line 1376: FROM wip_operation_resource_usage

1372:
1373: CURSOR get_inst_usage_min_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ,
1374: c_instance_id NUMBER , c_serial_num VARCHAR2 ) IS
1375: SELECT MIN(start_date) as min_inst_usg_date
1376: FROM wip_operation_resource_usage
1377: WHERE wip_entity_id = c_wip_entity_id
1378: AND operation_seq_num = c_op_seq_num
1379: AND resource_seq_num = c_res_seq_num
1380: AND instance_id = c_instance_id

Line 1386: FROM wip_operation_resource_usage

1382:
1383: CURSOR get_inst_usage_max_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ,
1384: c_instance_id NUMBER , c_serial_num VARCHAR2 ) IS
1385: SELECT MAX(completion_date) as max_inst_usg_date
1386: FROM wip_operation_resource_usage
1387: WHERE wip_entity_id = c_wip_entity_id
1388: AND operation_seq_num = c_op_seq_num
1389: AND resource_seq_num = c_res_seq_num
1390: AND instance_id = c_instance_id

Line 1395: FROM wip_operation_resource_usage

1391: AND ( serial_number IS NULL OR serial_number = c_serial_num) ;
1392:
1393: CURSOR get_res_usage_min_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
1394: SELECT MIN(start_date) as min_res_usg_date
1395: FROM wip_operation_resource_usage
1396: WHERE wip_entity_id = c_wip_entity_id
1397: AND operation_seq_num = c_op_seq_num
1398: AND resource_seq_num = c_res_seq_num
1399: AND instance_id IS NULL

Line 1404: FROM wip_operation_resource_usage

1400: AND serial_number IS NULL ;
1401:
1402: CURSOR get_res_usage_max_date( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
1403: SELECT MAX(completion_date) as max_inst_usg_date
1404: FROM wip_operation_resource_usage
1405: WHERE wip_entity_id = c_wip_entity_id
1406: AND operation_seq_num = c_op_seq_num
1407: AND resource_seq_num = c_res_seq_num
1408: AND instance_id IS NULL

Line 1413: FROM wip_operation_resource_usage

1409: AND serial_number IS NULL ;
1410:
1411: CURSOR get_instdates( c_wip_entity_id NUMBER, c_op_seq_num NUMBER , c_res_seq_num NUMBER ) IS
1412: SELECT start_date, completion_date, instance_id, serial_number
1413: FROM wip_operation_resource_usage
1414: WHERE wip_entity_id = c_wip_entity_id
1415: AND operation_seq_num = c_op_seq_num
1416: AND resource_seq_num = c_res_seq_num;
1417:

Line 1544: UPDATE wip_operation_resource_usage

1540: END LOOP;
1541:
1542: IF ( l_min_found = 'N' ) THEN
1543:
1544: UPDATE wip_operation_resource_usage
1545: SET start_date = l_eam_res_inst_tbl(l_res_inst_tbl_index).start_date ,
1546: last_update_date = sysdate ,
1547: last_updated_by = FND_GLOBAL.user_id ,
1548: creation_date = sysdate ,

Line 1561: UPDATE wip_operation_resource_usage

1557: END IF ;
1558:
1559: IF ( l_max_found = 'N' ) THEN
1560:
1561: UPDATE wip_operation_resource_usage
1562: SET completion_date = l_eam_res_inst_tbl(l_res_inst_tbl_index).completion_date ,
1563: last_update_date = sysdate ,
1564: last_updated_by = FND_GLOBAL.user_id ,
1565: creation_date = sysdate ,

Line 1626: from wip_operation_resource_usage where

1622: l_op_seq_num := l_eam_res_tbl(l_res_tbl_index).operation_seq_num ;
1623: l_res_seq_num := l_eam_res_tbl(l_res_tbl_index).resource_seq_num ;
1624:
1625: select count(*) into l_woru_count
1626: from wip_operation_resource_usage where
1627: wip_entity_id = l_wip_entity_id
1628: AND operation_seq_num = l_op_seq_num
1629: AND resource_seq_num = l_res_seq_num
1630: AND instance_id IS NULL

Line 1649: UPDATE wip_operation_resource_usage

1645: l_res_usage_tbl_index := l_eam_res_usage_tbl.FIRST ;
1646:
1647: IF l_eam_res_usage_tbl.count =0 AND l_woru_count=1 THEN -- Added for Summary tab.Only for 24 hr resources.
1648:
1649: UPDATE wip_operation_resource_usage
1650: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1651: last_update_date = sysdate ,
1652: last_updated_by = FND_GLOBAL.user_id ,
1653: creation_date = sysdate ,

Line 1663: UPDATE wip_operation_resource_usage

1659: AND instance_id IS NULL
1660: AND serial_number IS NULL ;
1661:
1662:
1663: UPDATE wip_operation_resource_usage
1664: SET completion_date = l_eam_res_tbl(l_res_tbl_index).completion_date ,
1665: last_update_date = sysdate ,
1666: last_updated_by = FND_GLOBAL.user_id ,
1667: creation_date = sysdate ,

Line 1679: from wip_operation_resource_usage

1675:
1676: FOR c_instdates_rec IN get_instdates(l_wip_entity_id , l_op_seq_num, l_res_seq_num )
1677: LOOP
1678: select count(*) into l_woru_count
1679: from wip_operation_resource_usage
1680: where
1681: wip_entity_id = l_wip_entity_id
1682: AND operation_seq_num = l_op_seq_num
1683: AND resource_seq_num = l_res_seq_num

Line 1689: UPDATE wip_operation_resource_usage

1685: AND ( serial_number IS NULL OR serial_number = c_instdates_rec.serial_number);
1686:
1687: IF l_woru_count=1 THEN -- Update WORU rows for instances.Only for 24 hr resources
1688:
1689: UPDATE wip_operation_resource_usage
1690: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1691: last_update_date = sysdate ,
1692: last_updated_by = FND_GLOBAL.user_id ,
1693: creation_date = sysdate ,

Line 1702: UPDATE wip_operation_resource_usage

1698: AND resource_seq_num = l_res_seq_num
1699: AND instance_id = c_instdates_rec.instance_id
1700: AND ( serial_number IS NULL OR serial_number = c_instdates_rec.serial_number);
1701:
1702: UPDATE wip_operation_resource_usage
1703: SET completion_date =l_eam_res_tbl(l_res_tbl_index).completion_date ,
1704: last_update_date = sysdate ,
1705: last_updated_by = FND_GLOBAL.user_id ,
1706: creation_date = sysdate ,

Line 1750: UPDATE wip_operation_resource_usage

1746:
1747:
1748: IF ( l_min_found = 'N' ) THEN
1749:
1750: UPDATE wip_operation_resource_usage
1751: SET start_date = l_eam_res_tbl(l_res_tbl_index).start_date ,
1752: last_update_date = sysdate ,
1753: last_updated_by = FND_GLOBAL.user_id ,
1754: creation_date = sysdate ,

Line 1767: UPDATE wip_operation_resource_usage

1763: END IF ;
1764:
1765: IF ( l_max_found = 'N' ) THEN
1766:
1767: UPDATE wip_operation_resource_usage
1768: SET completion_date = l_eam_res_tbl(l_res_tbl_index).completion_date ,
1769: last_update_date = sysdate ,
1770: last_updated_by = FND_GLOBAL.user_id ,
1771: creation_date = sysdate ,

Line 1800: DELETE FROM wip_operation_resource_usage

1796: IF ( l_eam_res_usage_tbl.count > 0 ) THEN
1797: FOR i IN l_eam_res_usage_tbl.FIRST..l_eam_res_usage_tbl.LAST LOOP
1798: IF ( l_eam_res_usage_tbl(i).transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE ) THEN
1799: IF ( l_eam_res_usage_tbl(i).instance_id IS NULL ) THEN
1800: DELETE FROM wip_operation_resource_usage
1801: WHERE wip_entity_id = l_eam_res_usage_tbl(i).wip_entity_id
1802: AND operation_seq_num = l_eam_res_usage_tbl(i).operation_seq_num
1803: AND resource_seq_num = l_eam_res_usage_tbl(i).resource_seq_num
1804: AND instance_id IS NULL

Line 1808: DELETE FROM wip_operation_resource_usage

1804: AND instance_id IS NULL
1805: AND start_date = l_eam_res_usage_tbl(i).old_start_date
1806: AND completion_date = l_eam_res_usage_tbl(i).old_completion_date ;
1807: ELSE
1808: DELETE FROM wip_operation_resource_usage
1809: WHERE wip_entity_id = l_eam_res_usage_tbl(i).wip_entity_id
1810: AND operation_seq_num = l_eam_res_usage_tbl(i).operation_seq_num
1811: AND resource_seq_num = l_eam_res_usage_tbl(i).resource_seq_num
1812: AND instance_id = l_eam_res_usage_tbl(i).instance_id