PACKAGE: APPS.PO_DATATEMPLATE_PKG

Source

1 PACKAGE PO_DATATEMPLATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: PO_DATATEMPLATE_PKG.pls 120.10.12020000.5 2013/03/28 11:28:27 vpeddi ship $ */
3 
4   FUNCTION LineLocation_Filter(p_type VARCHAR2, complex_work_po VARCHAR2 ) RETURN Boolean;
5   FUNCTION LineDelivery_Filter(p_type VARCHAR2, complex_work_po VARCHAR2 ) RETURN Boolean;
6   FUNCTION get_location_id(t_orgid NUMBER) RETURN NUMBER;
7   FUNCTION get_location_name(t_orgid NUMBER) RETURN VARCHAR2;
8   FUNCTION GET_UDA_HEADER_XML RETURN XMLTYPE;
9   FUNCTION GET_UDA_LINES_XML(p_line_id number) RETURN XMLTYPE;
10   FUNCTION GET_UDA_Line_Locations_XML(p_line_location_id NUMBER) RETURN XMLTYPE;
11   FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_HEADERID NUMBER) RETURN XMLTYPE;
12   FUNCTION GET_UDA_LINES_DRAFTS_XML(p_PO_LINE_ID NUMBER) RETURN XMLTYPE;
13   FUNCTION GET_UDA_LL_DRAFTS_XML(p_LINE_LOCATION_ID NUMBER) RETURN XMLTYPE;
14   FUNCTION get_contactsxml RETURN CLOB;
15   FUNCTION get_addressxml RETURN CLOB;
16   FUNCTION get_addressxml(p_headerId NUMBER) RETURN CLOB;
17   FUNCTION get_drafts_contactsxml(p_headerId NUMBER) RETURN CLOB;
18   FUNCTION get_drafts_addressxml(p_headerId NUMBER) RETURN CLOB;
19   FUNCTION get_header_amount_ordered(p_header_id NUMBER, p_draft_id NUMBER) RETURN NUMBER;
20   FUNCTION get_line_amount_ordered(p_line_id NUMBER, p_draft_id NUMBER) RETURN NUMBER;
21   FUNCTION get_without_opt_amount_ordered(p_header_id NUMBER, p_draft_id NUMBER) RETURN NUMBER;
22   FUNCTION get_shipaddressxml(p_line_location_id number)  return CLOB;
23   FUNCTION get_mod_shipaddressxml(p_line_location_id number)  return CLOB;
24   FUNCTION get_vendor_address_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB;
25   FUNCTION get_vendor_contact_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB;
26   FUNCTION get_bilateral_indicator(p_header_id IN NUMBER, p_draft_id IN NUMBER, p_auth_status IN VARCHAR2, p_bil_indicator IN VARCHAR2)
27   RETURN VARCHAR2;
28   FUNCTION get_inv_office_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN VARCHAR2;
29   FUNCTION GET_LINE_ATTRIBUTE_VAL_XML(p_categoryId NUMBER, p_lineId NUMBER) RETURN XMLType;
30   FUNCTION GET_LINE_ATTR_VAL_DRAFT_XML(p_categoryId NUMBER, p_lineId NUMBER, p_draftId NUMBER) RETURN XMLType;
31   FUNCTION AfterPForm RETURN Boolean;
32   FUNCTION get_fob_lookup_code RETURN BOOLEAN;
33   FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;
34   FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number NUMBER) RETURN XMLType;
35   FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;
36   FUNCTION calc_award_enc_amt(p_header_id NUMBER) RETURN NUMBER;
37   FUNCTION get_closeout_uda_details(p_header_id number, p_template_id NUMBER) return XMLType;
38   function set_business_classification return boolean;
39   P_ATTR_GROUP_COL_LIST VARCHAR2(4000);
40   headerId NUMBER;
41   draftId NUMBER;
42   include_sgd VARCHAR2(20);
43   is_doc_mod VARCHAR2(20);
44   p_fob_value_dest varchar2(4000);
45   p_fob_value_origin varchar2(4000);
46   pt_headerId NUMBER;
47   p_fp_of347_small varchar2(10);
48   p_fp_of347_other varchar2(10);
49   p_fp_of347_disadv varchar2(10);
50   p_fp_of347_women varchar2(10);
51   p_fp_of347_hubzone varchar2(10);
52   p_fp_of347_SDVO varchar2(10);
53   p_fp_of347_WOSB varchar2(10);
54   p_fp_of347_EDWOSB varchar2(10);
55   exhibitCode VARCHAR2(10);
56 END;
57