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_PROCESS_WO_UTIL_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : inserting into po_requisitions_interface_all ..'); END IF;

279:
280: end if;
281:
282:
283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : inserting into po_requisitions_interface_all ..'); END IF;
284:
285: /* Changed for MOAC: Insert org_id as well */
286: insert into po_requisitions_interface_all (
287: interface_source_code,

Line 286: insert into po_requisitions_interface_all (

282:
283: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : inserting into po_requisitions_interface_all ..'); END IF;
284:
285: /* Changed for MOAC: Insert org_id as well */
286: insert into po_requisitions_interface_all (
287: interface_source_code,
288: destination_type_code,
289: authorization_status,
290: preparer_id, -- person id of the user name

Line 600: /Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450/

596: IF(l_req_for_cancel_qty_profile = 'Y') then
597: --13102446 trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
598:
599: BEGIN
600: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
601: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
602: FROM
603: (SELECT SUM(nvl(pria.quantity,0)) req_qty
604: FROM po_requisitions_interface_all pria

Line 604: FROM po_requisitions_interface_all pria

600: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
601: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
602: FROM
603: (SELECT SUM(nvl(pria.quantity,0)) req_qty
604: FROM po_requisitions_interface_all pria
605: WHERE pria.wip_entity_id =l_di_record.wip_entity_id
606: AND pria.destination_organization_id = l_di_record.organization_id
607: AND pria.wip_operation_seq_num = l_di_record.task_number
608: AND pria.item_id is null

Line 656: /Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450/

652:
653: ELSE -- Don't trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
654:
655: BEGIN
656: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
657: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
658: FROM
659: (SELECT SUM(nvl(pria.quantity,0)) req_qty
660: FROM po_requisitions_interface_all pria

Line 660: FROM po_requisitions_interface_all pria

656: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
657: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
658: FROM
659: (SELECT SUM(nvl(pria.quantity,0)) req_qty
660: FROM po_requisitions_interface_all pria
661: WHERE pria.wip_entity_id =l_di_record.wip_entity_id
662: AND pria.destination_organization_id = l_di_record.organization_id
663: AND pria.wip_operation_seq_num = l_di_record.task_number
664: AND pria.item_id is null

Line 717: /Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450/

713: -- trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
714:
715: BEGIN
716:
717: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
718:
719: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
720: FROM
721: (SELECT SUM(nvl(pria.quantity,0)) req_qty

Line 722: FROM po_requisitions_interface_all pria

718:
719: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
720: FROM
721: (SELECT SUM(nvl(pria.quantity,0)) req_qty
722: FROM po_requisitions_interface_all pria
723: WHERE pria.wip_entity_id = l_di_record.wip_entity_id
724: AND pria.destination_organization_id = l_di_record.organization_id
725: AND pria.wip_operation_seq_num = l_di_record.task_number
726: AND pria.item_id = l_di_record.inventory_item_id

Line 776: /Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450/

772:
773: ELSE -- Don't trigger requisition again for the cancelled quantity where the earlier Req/PO was cancelled
774:
775: BEGIN
776: /*Querying table po_requisitions_interface_all also to avoid duplication of requisitions, added for bug #6112450*/
777:
778: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
779: FROM
780: (SELECT SUM(nvl(pria.quantity,0)) req_qty

Line 781: FROM po_requisitions_interface_all pria

777:
778: SELECT SUM(nvl(req_qty,0)) INTO l_total_req_qty
779: FROM
780: (SELECT SUM(nvl(pria.quantity,0)) req_qty
781: FROM po_requisitions_interface_all pria
782: WHERE pria.wip_entity_id = l_di_record.wip_entity_id
783: AND pria.destination_organization_id = l_di_record.organization_id
784: AND pria.wip_operation_seq_num = l_di_record.task_number
785: AND pria.item_id = l_di_record.inventory_item_id