APPS.PO_DRILLDOWN_PUB_PKG dependencies on PO_HEADERS_ALL

Line 120: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;

116: l_document_id NUMBER;
117: l_module_name CONSTANT VARCHAR2(100) := 'DRILLDOWN';
118: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);
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

Line 121: l_document_subtype PO_HEADERS_ALL.type_lookup_code%type;

117: l_module_name CONSTANT VARCHAR2(100) := 'DRILLDOWN';
118: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base( D_PACKAGE_BASE, l_module_name);
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;

Line 186: FROM po_headers_all

182: SELECT nvl(global_agreement_flag,'N'),
183: type_lookup_code
184: INTO l_global_agreement_flag,
185: l_document_subtype
186: FROM po_headers_all
187: WHERE po_header_id=p_source_id_int_1;
188: d_progress :=50;
189: IF(l_document_subtype ='STANDARD')THEN
190: d_progress :=60;