APPS.PO_FBO_PKG dependencies on PO_HEADERS_ALL

Line 14: FUNCTION GET_NAICS_CODE(p_document_id po_headers_all.po_header_id %type)

10: ---------------------------------------------------------------------------
11: -- Private functions to get NAICS node and classification code.
12: ---------------------------------------------------------------------------
13:
14: FUNCTION GET_NAICS_CODE(p_document_id po_headers_all.po_header_id %type)
15: RETURN VARCHAR2;
16:
17: FUNCTION GET_CLASSIFICATION_CODE(p_document_id po_headers_all.po_header_id %type)
18: RETURN VARCHAR2;

Line 17: FUNCTION GET_CLASSIFICATION_CODE(p_document_id po_headers_all.po_header_id %type)

13:
14: FUNCTION GET_NAICS_CODE(p_document_id po_headers_all.po_header_id %type)
15: RETURN VARCHAR2;
16:
17: FUNCTION GET_CLASSIFICATION_CODE(p_document_id po_headers_all.po_header_id %type)
18: RETURN VARCHAR2;
19:
20:
21: -------------------------------------------------------------------------------

Line 96: l_document_id po_headers_all.po_header_id%TYPE;

92:
93: l_has_associated_solicitation varchar2(1):='N';
94: l_solicitation_no VARCHAR2(100):=NULL;
95: l_solicitation_title VARCHAR2(100):=NULL;
96: l_document_id po_headers_all.po_header_id%TYPE;
97: x_progress VARCHAR2(300);
98:
99:
100: BEGIN

Line 152: l_document_id po_headers_all.po_header_id%TYPE;

148:
149:
150: x_progress VARCHAR2(300);
151: l_request_id number;
152: l_document_id po_headers_all.po_header_id%TYPE;
153: submission_error exception;
154:
155: BEGIN
156:

Line 310: FROM po_headers_all_ext_b phae,

306: NULL,NULL,
307: ''Government Agency URL'') "desc")
308: "link"
309: )
310: FROM po_headers_all_ext_b phae,
311: ego_fnd_dsc_flx_ctx_ext ego,
312: po_lookup_codes plc,
313: po_vendors pv
314: WHERE phae.po_header_id = pha.po_header_id

Line 435: from po_headers_all pha

431: || ', ' || l_query3
432: ||', decode( ''' || p_notice_type || ''',
433: ''FED_JA'',' || l_attach_query
434: || ', null) )))
435: from po_headers_all pha
436: where pha.po_header_id = ' || p_document_id;
437:
438: EXECUTE immediate l_xml_query INTO l_result;
439:

Line 486: FUNCTION GET_CLASSIFICATION_CODE(p_document_id po_headers_all.po_header_id %type)

482: -- FSC/PSC code
483: --End of Comments
484: -------------------------------------------------------------------------------
485:
486: FUNCTION GET_CLASSIFICATION_CODE(p_document_id po_headers_all.po_header_id %type)
487: RETURN VARCHAR2
488: IS
489:
490: l_class_cod VARCHAR2(10);

Line 531: FROM po_headers_all_ext_b phae,

527: NULL,
528: Substr(c_ext_attr1, 1, 2),
529: Substr(c_ext_attr1, 1, 1))
530: INTO l_class_cod
531: FROM po_headers_all_ext_b phae,
532: ego_fnd_dsc_flx_ctx_ext ego
533: WHERE phae.po_header_id = p_document_id
534: AND phae.draft_id = -1
535: AND phae.attr_group_id = ego.attr_group_id

Line 572: FUNCTION GET_NAICS_CODE(p_document_id po_headers_all.po_header_id %type)

568: -- Naics code
569: --End of Comments
570: -------------------------------------------------------------------------------
571:
572: FUNCTION GET_NAICS_CODE(p_document_id po_headers_all.po_header_id %type)
573: RETURN VARCHAR2
574: IS
575:
576: l_naics VARCHAR2(100);

Line 608: FROM po_headers_all_ext_b phae,

604: BEGIN
605: -- Check at header level (case :IDV without lines)
606: SELECT phae.C_EXT_ATTR4
607: INTO l_naics
608: FROM po_headers_all_ext_b phae,
609: ego_fnd_dsc_flx_ctx_ext ego,
610: po_lookup_codes plc
611: WHERE phae.po_header_id = p_document_id
612: AND phae.draft_id = -1