eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DATATEMPLATE_PKG dependencies on XMLTYPE

Line 8: FUNCTION GET_UDA_HEADER_XML RETURN XMLTYPE;

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;

Line 9: FUNCTION GET_UDA_LINES_XML(p_line_id number) RETURN XMLTYPE;

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;

Line 10: FUNCTION GET_UDA_Line_Locations_XML(p_line_location_id NUMBER) RETURN XMLTYPE;

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;

Line 11: FUNCTION GET_UDA_HEADER_DRAFTS_XML(p_HEADERID NUMBER) RETURN XMLTYPE;

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;

Line 12: FUNCTION GET_UDA_LINES_DRAFTS_XML(p_PO_LINE_ID NUMBER) RETURN XMLTYPE;

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;

Line 13: FUNCTION GET_UDA_LL_DRAFTS_XML(p_LINE_LOCATION_ID NUMBER) 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;

Line 29: FUNCTION GET_LINE_ATTRIBUTE_VAL_XML(p_categoryId NUMBER, p_lineId NUMBER) RETURN XMLType;

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;

Line 30: FUNCTION GET_LINE_ATTR_VAL_DRAFT_XML(p_categoryId NUMBER, p_lineId NUMBER, p_draftId NUMBER) RETURN XMLType;

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;

Line 33: FUNCTION get_req_numbers(p_header_id NUMBER, p_draft_id NUMBER, p_line_id NUMBER) RETURN XMLType;

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;

Line 34: FUNCTION get_bpa_req_numbers(p_auction_header_id NUMBER, p_auction_line_number 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;

Line 35: FUNCTION get_acrns(p_header_id NUMBER, p_draft_id NUMBER, p_line_id 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);

Line 37: FUNCTION get_closeout_uda_details(p_header_id number, p_template_id NUMBER) return XMLType;

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;