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: BEGIN
124: d_progress :=0;

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: BEGIN
124: d_progress :=0;
125: IF (PO_LOG.d_proc) THEN

Line 167: FROM po_headers_all

163: SELECT nvl(global_agreement_flag,'N'),
164: type_lookup_code
165: INTO l_global_agreement_flag,
166: l_document_subtype
167: FROM po_headers_all
168: WHERE po_header_id=p_source_id_int_1;
169: d_progress :=50;
170: IF(l_document_subtype ='STANDARD')THEN
171: d_progress :=60;