APPS.OKC_TERMS_MIGRATE_GRP dependencies on PO_HEADERS_ALL

Line 31: G_PO_STATUS_CODE PO_HEADERS_ALL.STATUS_LOOKUP_CODE%TYPE;

27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
28: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
29: G_CURRENT_ORG_ID NUMBER := -99;
30: G_ORG_ID NUMBER ;
31: G_PO_STATUS_CODE PO_HEADERS_ALL.STATUS_LOOKUP_CODE%TYPE;
32: G_DIR_NAME VARCHAR2(2000);
33:
34: G_ENABLE_DELIVERABLES VARCHAR2(1) := 'N';
35: G_COPY_DELIVERABLES VARCHAR2(1) := 'N';

Line 117: l_po_status_code PO_HEADERS_ALL.STATUS_LOOKUP_CODE%TYPE;

113: x_msg_data OUT NOCOPY Varchar2,
114: x_msg_count OUT NOCOPY Number)
115: IS
116: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Document';
117: l_po_status_code PO_HEADERS_ALL.STATUS_LOOKUP_CODE%TYPE;
118: l_po_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
119:
120:
121:

Line 118: l_po_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

114: x_msg_count OUT NOCOPY Number)
115: IS
116: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Document';
117: l_po_status_code PO_HEADERS_ALL.STATUS_LOOKUP_CODE%TYPE;
118: l_po_type_code PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
119:
120:
121:
122: CURSOR l_doc_type_csr IS

Line 139: FROM PO_HEADERS_ALL

135: SELECT TYPE_LOOKUP_CODE,
136: STATUS_LOOKUP_CODE,
137: ORG_ID,
138: SEGMENT1
139: FROM PO_HEADERS_ALL
140: WHERE po_header_id = p_document_id;
141:
142: CURSOR l_so_doc_csr IS
143: SELECT org_id,

Line 571: po_headers_all poh

567: CURSOR l_bus_doc_ver_csr IS
568: SELECT nvl(poh.revision_num,-99)
569: FROM
570: po_headers_archive_all poa,
571: po_headers_all poh
572: WHERE poh.po_header_id = poa.po_header_id
573: AND poh.revision_num = poa.revision_num
574: AND poh.po_header_id = p_document_id;
575:

Line 1296: po_headers_all poh

1292: CURSOR l_bus_doc_ver_csr IS
1293: SELECT nvl(poh.revision_num,-99)
1294: FROM
1295: po_headers_archive_all poa,
1296: po_headers_all poh
1297: WHERE poh.po_header_id = poa.po_header_id
1298: AND poh.revision_num = poa.revision_num
1299: AND poh.po_header_id = p_document_id;
1300: