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.PO_NEGOTIATIONS_SV1 dependencies on PO_REQUISITION_HEADERS_ALL

Line 640: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

636:
637: x_result:=-1;
638: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
639: /*
640: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
641: WHERE prh.requisition_header_id = prl.requisition_header_id
642: AND prl.requisition_line_id = t_req_lines(i);
643:
644: fnd_message.set_token('REQ_NUM', x_req_num);

Line 661: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

657: if (SQLCODE=-54)
658: THEN
659: x_result:=-1;
660: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
661: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
662: WHERE prh.requisition_header_id = prl.requisition_header_id
663: AND prl.requisition_line_id = t_req_lines(i);
664:
665: fnd_message.set_token('REQ_NUM', x_req_num);

Line 689: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

685: then
686: /* The req line has been auto created already. */
687: x_result:=-1;
688: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
689: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
690: WHERE prh.requisition_header_id = prl.requisition_header_id
691: AND prl.requisition_line_id = t_req_lines(i);
692:
693: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 711: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

707: elsif (x_cancel_flag = 'Y') then
708: /* The req line has been cancelled. */
709: x_result:=-1;
710: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
711: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
712: WHERE prh.requisition_header_id = prl.requisition_header_id
713: AND prl.requisition_line_id = t_req_lines(i);
714:
715: fnd_message.set_token('REQ_NUM', x_req_num);

Line 727: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

723: elsif (x_closed_code = 'FINALLY CLOSED') then
724: /* The req line has been auto created already. */
725: x_result:=-1;
726: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
727: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
728: WHERE prh.requisition_header_id = prl.requisition_header_id
729: AND prl.requisition_line_id = t_req_lines(i);
730:
731: fnd_message.set_token('REQ_NUM', x_req_num);

Line 776: po_requisition_headers_all prh

772: prl.item_id,
773: prl.category_id,
774: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
775: FROM po_requisition_lines_all prl,
776: po_requisition_headers_all prh
777: WHERE prh.requisition_header_id = prl.requisition_header_id
778: AND prl.requisition_line_id = t_req_lines(i);
779: else
780: FORALL i IN 1..t_req_lines.Count

Line 792: po_requisition_headers_all prh

788: t_neg_lines(i),
789: t_neg_line_num(i),
790: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
791: FROM po_requisition_lines_all prl,
792: po_requisition_headers_all prh
793: WHERE prh.requisition_header_id = prl.requisition_header_id
794: AND prl.requisition_line_id = t_req_lines(i);
795: end if;
796:

Line 934: from po_requisition_headers_all --

930: /* begin
931: x_progress := '006';
932: select segment1
933: into x_req_num
934: from po_requisition_headers_all --
935: where requisition_header_id=x_req_header_id;
936: exception
937: when others then
938: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);

Line 1431: from po_requisition_headers_all prha

1427: or source_type_code = 'INVENTORY'
1428: or NVL(line_location_id, -999) <> -999
1429: or exists
1430: (select 'Req Header auth_status is not approved or contractor_status is pending'
1431: from po_requisition_headers_all prha
1432: where prha.requisition_header_id = prla.requisition_header_id
1433: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
1434: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
1435: THEN null

Line 1464: from po_requisition_headers_all prha

1460: or source_type_code = 'INVENTORY'
1461: or NVL(line_location_id, -999) <> -999
1462: or exists
1463: (select 'Req Header auth_status is not approved or contractor_status is pending'
1464: from po_requisition_headers_all prha
1465: where prha.requisition_header_id = prla.requisition_header_id
1466: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
1467: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
1468: THEN null

Line 1630: from po_requisition_headers_all prha

1626: and source_type_code <> 'INVENTORY'
1627: and NVL(line_location_id, -999) = -999
1628: and not exists
1629: (select 'Req Header auth_status is not approved or contractor_status is pending'
1630: from po_requisition_headers_all prha
1631: where prha.requisition_header_id = prla.requisition_header_id
1632: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
1633: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING'));
1634: --

Line 1656: from po_requisition_headers_all prha

1652: and source_type_code <> 'INVENTORY'
1653: and NVL(line_location_id, -999) = -999
1654: and not exists
1655: (select 'Req Header auth_status is not approved or contractor_status is pending'
1656: from po_requisition_headers_all prha
1657: where prha.requisition_header_id = prla.requisition_header_id
1658: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
1659: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING'));
1660: --

Line 2611: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

2607: if (SQLCODE=-54)
2608: THEN
2609: x_result:=-1;
2610: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
2611: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2612: WHERE prh.requisition_header_id = prl.requisition_header_id
2613: AND prl.requisition_line_id = p_req_line_id;
2614:
2615: fnd_message.set_token('REQ_NUM', x_req_num);

Line 2633: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

2629: then
2630: /* The req line has been auto created already. */
2631: x_result:=-1;
2632: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
2633: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2634: WHERE prh.requisition_header_id = prl.requisition_header_id
2635: AND prl.requisition_line_id = p_req_line_id;
2636:
2637: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2654: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

2650: elsif (x_cancel_flag = 'Y') then
2651: /* The req line has been cancelled. */
2652: x_result:=-1;
2653: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
2654: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2655: WHERE prh.requisition_header_id = prl.requisition_header_id
2656: AND prl.requisition_line_id = p_req_line_id;
2657:
2658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2675: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl

2671: elsif (x_closed_code = 'FINALLY CLOSED') then
2672: /* The req line has been auto created already. */
2673: x_result:=-1;
2674: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
2675: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2676: WHERE prh.requisition_header_id = prl.requisition_header_id
2677: AND prl.requisition_line_id = p_req_line_id;
2678:
2679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2709: po_requisition_headers_all prh

2705: prl.item_id,
2706: prl.category_id,
2707: decode (prl.purchase_basis , 'TEMP LABOR' , prl.assignment_start_date , prl.need_by_date )
2708: FROM po_requisition_lines_all prl,
2709: po_requisition_headers_all prh
2710: WHERE prh.requisition_header_id = prl.requisition_header_id
2711: AND prl.requisition_line_id = p_req_line_id;
2712:
2713:

Line 3224: SELECT uda_template_id INTO l_req_uda_temp_id FROM po_requisition_headers_all WHERE REQUISITION_HEADER_ID= l_req_header_id;

3220:
3221: BEGIN
3222: SELECT requisition_header_id INTO l_req_header_id FROM po_requisition_lines_all WHERE requisition_line_id = l_req_line_id;
3223: SELECT uda_template_id INTO l_sol_uda_temp_id FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;
3224: SELECT uda_template_id INTO l_req_uda_temp_id FROM po_requisition_headers_all WHERE REQUISITION_HEADER_ID= l_req_header_id;
3225:
3226: EXCEPTION WHEN OTHERS THEN
3227: l_req_header_id := NULL;
3228: l_sol_uda_temp_id := NULL;

Line 3546: from po_requisition_headers_all prha

3542: or source_type_code = 'INVENTORY'
3543: or NVL(line_location_id, -999) <> -999
3544: or exists
3545: (select 'Req Header auth_status is not approved or contractor_status is pending'
3546: from po_requisition_headers_all prha
3547: where prha.requisition_header_id = prla.requisition_header_id
3548: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
3549: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
3550: THEN null

Line 3623: from po_requisition_headers_all prha

3619: or source_type_code = 'INVENTORY'
3620: or NVL(line_location_id, -999) <> -999
3621: or exists
3622: (select 'Req Header auth_status is not approved or contractor_status is pending'
3623: from po_requisition_headers_all prha
3624: where prha.requisition_header_id = prla.requisition_header_id
3625: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
3626: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
3627: THEN null

Line 3737: from po_requisition_headers_all prha

3733: or source_type_code = 'INVENTORY'
3734: or NVL(line_location_id, -999) <> -999
3735: or exists
3736: (select 'Req Header auth_status is not approved or contractor_status is pending'
3737: from po_requisition_headers_all prha
3738: where prha.requisition_header_id = prla.requisition_header_id
3739: and (NVL(prha.authorization_status,'INCOMPLETE') <> 'APPROVED'
3740: or NVL(prha.contractor_status,'NOT_APPLICABLE') = 'PENDING')))
3741: THEN null