APPS.PO_DRILLDOWN_PUB_PKG dependencies on PO_REQUISITION_HEADERS_ALL

Line 123: l_federal_flag po_requisition_headers_all.FEDERAL_FLAG%type;

119: d_progress NUMBER;
120: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
121: l_document_subtype PO_HEADERS_ALL.type_lookup_code%type;
122: l_bpa_header_id PO_RELEASES_ALL.po_header_id%type;
123: l_federal_flag po_requisition_headers_all.FEDERAL_FLAG%type;
124: BEGIN
125: d_progress :=0;
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_begin(d_module_base);

Line 163: FROM po_requisition_headers_all

159: d_progress :=35;
160: Begin
161: SELECT nvl(FEDERAL_FLAG,'N')
162: INTO l_federal_flag
163: FROM po_requisition_headers_all
164: WHERE requisition_header_id = p_source_id_int_1;
165: Exception
166: WHEN NO_DATA_FOUND Then
167: l_federal_flag := 'N';