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_ACKNOWLEDGE_PO_PVT dependencies on PO_HEADERS_ALL

Line 152: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null;

148: l_accepted_flag VARCHAR2(1) := null;
149: l_ship_ack_exist_flag VARCHAR2(1) := null;
150: l_acceptance_required_flag VARCHAR2(1) := null;
151: l_shipment_exist_flag VARCHAR2(1) := null;
152: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
153: l_sign_flag PO_HEADERS_ALL.pending_signature_flag%TYPE := null;
154: l_sup_sign_exist_flag VARCHAR2(1) := null;
155: l_reject_sign_exist_flag VARCHAR2(1) := null;
156: l_arch_revision_num NUMBER := p_revision_num;

Line 153: l_sign_flag PO_HEADERS_ALL.pending_signature_flag%TYPE := null;

149: l_ship_ack_exist_flag VARCHAR2(1) := null;
150: l_acceptance_required_flag VARCHAR2(1) := null;
151: l_shipment_exist_flag VARCHAR2(1) := null;
152: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
153: l_sign_flag PO_HEADERS_ALL.pending_signature_flag%TYPE := null;
154: l_sup_sign_exist_flag VARCHAR2(1) := null;
155: l_reject_sign_exist_flag VARCHAR2(1) := null;
156: l_arch_revision_num NUMBER := p_revision_num;
157:

Line 267: from PO_HEADERS_ALL

263: nvl(pending_signature_flag,'N')
264: into l_acceptance_required_flag,
265: l_change_requested_by,
266: l_sign_flag
267: from PO_HEADERS_ALL
268: where po_header_id = p_po_header_id;
269:
270: /* Check for Signatures */
271:

Line 465: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

461: -- Bug 2850566
462: l_rowid ROWID;
463: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
464: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
465: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
466: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
467: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
468: -- End of Bug 2850566
469:

Line 511: update PO_HEADERS_ALL

507: acceptance_due_date = ''
508: where po_release_id = p_po_release_id;
509:
510: ELSIF (p_po_header_id is not null) THEN
511: update PO_HEADERS_ALL
512: set acceptance_required_flag = 'N',
513: acceptance_due_date = ''
514: where po_header_id = p_po_header_id;
515: END IF;

Line 557: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;

553:
554: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_STATUS_CODE';
555: l_api_version CONSTANT NUMBER := 1.0;
556:
557: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;

Line 558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;

554: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_STATUS_CODE';
555: l_api_version CONSTANT NUMBER := 1.0;
556:
557: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;

Line 559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;

555: l_api_version CONSTANT NUMBER := 1.0;
556:
557: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

Line 560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;

556:
557: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;

Line 561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;

557: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
565: l_cancel_pending_flag VARCHAR2(1) := 'N';

Line 562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;

558: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
565: l_cancel_pending_flag VARCHAR2(1) := 'N';
566:

Line 563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

559: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
565: l_cancel_pending_flag VARCHAR2(1) := 'N';
566:
567: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;

Line 564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;

560: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
561: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
562: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
565: l_cancel_pending_flag VARCHAR2(1) := 'N';
566:
567: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
568: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;

Line 567: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;

563: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
565: l_cancel_pending_flag VARCHAR2(1) := 'N';
566:
567: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
568: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;
569: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;
570: l_catalog_status VARCHAR2(100) := null;
571: l_return_status VARCHAR2(1) := null;

Line 568: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;

564: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
565: l_cancel_pending_flag VARCHAR2(1) := 'N';
566:
567: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
568: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;
569: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;
570: l_catalog_status VARCHAR2(100) := null;
571: l_return_status VARCHAR2(1) := null;
572:

Line 569: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;

565: l_cancel_pending_flag VARCHAR2(1) := 'N';
566:
567: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
568: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;
569: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;
570: l_catalog_status VARCHAR2(100) := null;
571: l_return_status VARCHAR2(1) := null;
572:
573: CURSOR l_rel_supplier_cancel_csr IS

Line 654: from PO_HEADERS_all

650: l_changed_by,
651: l_ga_flag,
652: l_authoring_flag,
653: l_lock_owner_role
654: from PO_HEADERS_all
655: where po_header_id = p_po_header_id;
656:
657: END IF;
658:

Line 788: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

784: l_acceptance_required_flag VARCHAR2(1) := null;
785: l_action_type PO_CHANGE_REQUESTS.action_type%TYPE := null;
786:
787: l_revision_num NUMBER := p_revision_num;
788: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
789:
790: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_STATUS_CODE';
791: l_api_version CONSTANT NUMBER := 1.0;
792:

Line 825: FROM PO_HEADERS_ALL POH

821:
822: ELSIF (p_po_header_id is not null) THEN
823: SELECT POH.revision_num, authorization_status
824: INTO l_revision_num, l_authorization_status
825: FROM PO_HEADERS_ALL POH
826: WHERE POH.po_header_id = p_po_header_id;
827:
828: END IF;
829:

Line 868: PO_HEADERS_ALL POH

864:
865: select PCR.action_type
866: into l_action_type
867: from PO_CHANGE_REQUESTS PCR,
868: PO_HEADERS_ALL POH
869: where pcr.document_line_location_id = P_line_location_id
870: and pcr.document_header_id = p_po_header_id
871: and poh.po_header_id = p_po_header_id
872: and poh.change_requested_by = 'SUPPLIER'

Line 951: from PO_HEADERS_ALL

947:
948: ELSIF (p_po_header_id is not null) THEN
949: select nvl(acceptance_required_flag, 'N')
950: into l_acceptance_required_flag
951: from PO_HEADERS_ALL
952: where po_header_id = p_po_header_id;
953:
954: IF (l_acceptance_required_flag in('D', 'Y')) THEN
955: return 'ACK_REQUIRED';

Line 1028: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

1024: -- Bug 2850566
1025: l_rowid ROWID;
1026: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1027: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1028: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1029: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1030: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1031: -- End of Bug 2850566
1032:

Line 1328: from po_headers_all

1324:
1325: ELSIf (p_po_header_id is not null) THEN
1326: select agent_id
1327: into l_buyer_id
1328: from po_headers_all
1329: where po_header_id = p_po_header_id;
1330:
1331:
1332: -- Bug 2850566 RBAIRRAJ

Line 1547: From PO_CHANGE_REQUESTS pcr, po_headers_all poh

1543: And pa.revision_num = p_revision_num
1544: And pa.po_line_location_id = PLL.line_location_id )
1545: And not exists (
1546: select 1
1547: From PO_CHANGE_REQUESTS pcr, po_headers_all poh
1548: WHERE poh.po_header_id = p_po_header_id
1549: and poh.change_requested_by = 'SUPPLIER'
1550: and pcr.document_header_id = p_po_header_id
1551: AND PCR.document_revision_num = p_revision_num

Line 1656: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null; l_revision_num NUMBER;

1652:
1653: l_accp_required_flag VARCHAR2(1) := null;
1654: l_ship_accepted_flag VARCHAR2(1) := null;
1655: l_header_accepted_flag VARCHAR2(1) := null;
1656: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null; l_revision_num NUMBER;
1657: l_buyer_id NUMBER;
1658:
1659: CURSOR l_rel_ship_accp_csr(rev_num NUMBER) IS
1660: SELECT accepted_flag

Line 1716: FROM PO_HEADERS_ALL

1712: INTO l_buyer_id,
1713: l_revision_num,
1714: l_accp_required_flag,
1715: l_change_requested_by
1716: FROM PO_HEADERS_ALL
1717: WHERE po_header_id = p_po_header_id;
1718:
1719: END IF;
1720: