PACKAGE: APPS.PO_XML_FPDSNG_PKG

Source

1 PACKAGE PO_XML_FPDSNG_PKG AUTHID CURRENT_USER AS
2 /* $Header: PODTFPDS.pls 120.1.12020000.2 2013/02/10 17:12:47 vegajula ship $ */
3 
4   FUNCTION get_location_id(t_orgid NUMBER) RETURN NUMBER;
5   FUNCTION get_location_name(t_orgid NUMBER) RETURN VARCHAR2;
6   FUNCTION GET_UDA_HEADER_XML RETURN XMLTYPE;
7   FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_HEADERID NUMBER) RETURN XMLTYPE;
8   FUNCTION get_contactsxml RETURN CLOB;
9   FUNCTION get_addressxml RETURN CLOB;
10   FUNCTION get_drafts_contactsxml(p_headerId NUMBER) RETURN CLOB;
11   FUNCTION get_drafts_addressxml(p_headerId NUMBER) RETURN CLOB;
12   FUNCTION get_header_amount_ordered(p_header_id NUMBER, p_draft_id NUMBER) RETURN NUMBER;
13   FUNCTION get_line_amount_ordered(p_line_id NUMBER, p_draft_id NUMBER) RETURN NUMBER;
14   FUNCTION get_without_opt_amount_ordered(p_header_id NUMBER, p_draft_id NUMBER) RETURN NUMBER;
15   FUNCTION get_vendor_address_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB;
16   FUNCTION get_vendor_contact_details(uda_template_id NUMBER, p_header_id NUMBER, p_draft_id NUMBER) RETURN CLOB;
17   function get_issuing_off_loc_code(p_header_id number, p_draft_id number) return varchar2;
18   P_ATTR_GROUP_COL_LIST VARCHAR2(4000);
19   HEADERID NUMBER;
20   p_draft_id NUMBER;
21   carId NUMBER;
22   include_sgd VARCHAR2(20);
23   is_doc_mod VARCHAR2(20);
24 END;
25