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 154: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null;

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

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

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

Line 478: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

474: -- Bug 2850566
475: l_rowid ROWID;
476: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
477: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
478: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
479: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
480: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
481: -- End of Bug 2850566
482:

Line 524: update PO_HEADERS_ALL

520: acceptance_due_date = ''
521: where po_release_id = p_po_release_id;
522:
523: ELSIF (p_po_header_id is not null) THEN
524: update PO_HEADERS_ALL
525: set acceptance_required_flag = 'N',
526: acceptance_due_date = ''
527: where po_header_id = p_po_header_id;
528: END IF;

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

566:
567: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_STATUS_CODE';
568: l_api_version CONSTANT NUMBER := 1.0;
569:
570: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
571: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;

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

567: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_STATUS_CODE';
568: l_api_version CONSTANT NUMBER := 1.0;
569:
570: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
571: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;

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

568: l_api_version CONSTANT NUMBER := 1.0;
569:
570: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
571: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

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

569:
570: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
571: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;

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

570: l_cancel_flag PO_HEADERS_ALL.cancel_flag%TYPE := null;
571: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
578: l_cancel_pending_flag VARCHAR2(1) := 'N';

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

571: l_frozen_flag PO_HEADERS_ALL.frozen_flag%TYPE := null;
572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
578: l_cancel_pending_flag VARCHAR2(1) := 'N';
579:

Line 576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

572: l_on_hold_flag PO_HEADERS_ALL.user_hold_flag%TYPE := null;
573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
578: l_cancel_pending_flag VARCHAR2(1) := 'N';
579:
580: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;

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

573: l_accp_reqd_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := null;
574: l_closed_code PO_HEADERS_ALL.closed_code%TYPE := null;
575: l_auth_status PO_HEADERS_ALL.authorization_status%TYPE := null;
576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
578: l_cancel_pending_flag VARCHAR2(1) := 'N';
579:
580: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
581: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;

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

576: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
578: l_cancel_pending_flag VARCHAR2(1) := 'N';
579:
580: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
581: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;
582: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;
583: l_catalog_status VARCHAR2(100) := null;
584: l_return_status VARCHAR2(1) := null;

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

577: l_changed_by PO_HEADERS_ALL.change_requested_by%TYPE := null;
578: l_cancel_pending_flag VARCHAR2(1) := 'N';
579:
580: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
581: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;
582: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;
583: l_catalog_status VARCHAR2(100) := null;
584: l_return_status VARCHAR2(1) := null;
585:

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

578: l_cancel_pending_flag VARCHAR2(1) := 'N';
579:
580: l_ga_flag PO_HEADERS_ALL.GLOBAL_AGREEMENT_flag%TYPE := null;
581: l_authoring_flag PO_HEADERS_ALL.SUPPLIER_AUTH_ENABLED_flag%TYPE := null;
582: l_lock_owner_role PO_HEADERS_ALL.LOCK_OWNER_ROLE%TYPE := null;
583: l_catalog_status VARCHAR2(100) := null;
584: l_return_status VARCHAR2(1) := null;
585:
586: CURSOR l_rel_supplier_cancel_csr IS

Line 667: from PO_HEADERS_all

663: l_changed_by,
664: l_ga_flag,
665: l_authoring_flag,
666: l_lock_owner_role
667: from PO_HEADERS_all
668: where po_header_id = p_po_header_id;
669:
670: END IF;
671:

Line 801: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

797: l_acceptance_required_flag VARCHAR2(1) := null;
798: l_action_type PO_CHANGE_REQUESTS.action_type%TYPE := null;
799:
800: l_revision_num NUMBER := p_revision_num;
801: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
802:
803: l_api_name CONSTANT VARCHAR2(30) := 'GET_PO_STATUS_CODE';
804: l_api_version CONSTANT NUMBER := 1.0;
805:

Line 838: FROM PO_HEADERS_ALL POH

834:
835: ELSIF (p_po_header_id is not null) THEN
836: SELECT POH.revision_num, authorization_status
837: INTO l_revision_num, l_authorization_status
838: FROM PO_HEADERS_ALL POH
839: WHERE POH.po_header_id = p_po_header_id;
840:
841: END IF;
842:

Line 881: PO_HEADERS_ALL POH

877:
878: select PCR.action_type
879: into l_action_type
880: from PO_CHANGE_REQUESTS PCR,
881: PO_HEADERS_ALL POH
882: where pcr.document_line_location_id = P_line_location_id
883: and pcr.document_header_id = p_po_header_id
884: and poh.po_header_id = p_po_header_id
885: and poh.change_requested_by = 'SUPPLIER'

Line 964: from PO_HEADERS_ALL

960:
961: ELSIF (p_po_header_id is not null) THEN
962: select nvl(acceptance_required_flag, 'N')
963: into l_acceptance_required_flag
964: from PO_HEADERS_ALL
965: where po_header_id = p_po_header_id;
966:
967: IF (l_acceptance_required_flag in('D', 'Y')) THEN
968: return 'ACK_REQUIRED';

Line 1041: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

1037: -- Bug 2850566
1038: l_rowid ROWID;
1039: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
1040: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
1041: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1042: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
1043: l_user_id PO_ACCEPTANCES.last_updated_by%TYPE;
1044: -- End of Bug 2850566
1045:

Line 1341: from po_headers_all

1337:
1338: ELSIf (p_po_header_id is not null) THEN
1339: select agent_id
1340: into l_buyer_id
1341: from po_headers_all
1342: where po_header_id = p_po_header_id;
1343:
1344:
1345: -- Bug 2850566 RBAIRRAJ

Line 1560: From PO_CHANGE_REQUESTS pcr, po_headers_all poh

1556: And pa.revision_num = p_revision_num
1557: And pa.po_line_location_id = PLL.line_location_id )
1558: And not exists (
1559: select 1
1560: From PO_CHANGE_REQUESTS pcr, po_headers_all poh
1561: WHERE poh.po_header_id = p_po_header_id
1562: and poh.change_requested_by = 'SUPPLIER'
1563: and pcr.document_header_id = p_po_header_id
1564: AND PCR.document_revision_num = p_revision_num

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

1665:
1666: l_accp_required_flag VARCHAR2(1) := null;
1667: l_ship_accepted_flag VARCHAR2(1) := null;
1668: l_header_accepted_flag VARCHAR2(1) := null;
1669: l_change_requested_by PO_HEADERS_ALL.change_requested_by%TYPE := null; l_revision_num NUMBER;
1670: l_buyer_id NUMBER;
1671:
1672: CURSOR l_rel_ship_accp_csr(rev_num NUMBER) IS
1673: SELECT accepted_flag

Line 1729: FROM PO_HEADERS_ALL

1725: INTO l_buyer_id,
1726: l_revision_num,
1727: l_accp_required_flag,
1728: l_change_requested_by
1729: FROM PO_HEADERS_ALL
1730: WHERE po_header_id = p_po_header_id;
1731:
1732: END IF;
1733: