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.
PACKAGE: APPS.PO_EDA_DATATEMPLATE_PKG

Source


1 PACKAGE po_eda_datatemplate_pkg AUTHID CURRENT_USER AS
2 /* $Header: POEDADTS.pls 120.11.12020000.3 2013/02/11 00:56:53 vegajula ship $ */
3 
4 FUNCTION DocFilter(p_draft_id NUMBER) RETURN BOOLEAN;
5 FUNCTION ModFilter(p_draft_id NUMBER) RETURN BOOLEAN;
6 function get_ProcurementInstVehicle3(p_auctHeaderId varchar2) return varchar2;
7 function get_PricingArrangementBase(p_clause_type VARCHAR2) return varchar2;
8 function get_AwardFee(ismod varchar2) return varchar2;
9 function get_PerformanceIncentive(ismod varchar2) return varchar2;
10 function get_AddendaAttached return varchar2;
11 FUNCTION AfterPForm RETURN Boolean;
12 FUNCTION set_uda_attributes_header RETURN BOOLEAN;
13 FUNCTION set_uda_attributes_lines RETURN BOOLEAN;
14 FUNCTION set_uda_attrs_line_locations RETURN BOOLEAN;
15 FUNCTION get_contactsxml RETURN CLOB;
16 FUNCTION get_addressxml RETURN CLOB;
17 FUNCTION get_shipaddressxml_base(p_line_location_id number)  return CLOB;
18 FUNCTION get_mod_addressxml(p_operation varchar2) RETURN CLOB;
19 FUNCTION get_drafts_contactsxml(p_headerId NUMBER) RETURN CLOB;
20 FUNCTION get_drafts_addressxml(p_headerId NUMBER) RETURN CLOB;
21 function get_LineItemType(p_line_num_disp VARCHAR2) return varchar2;
22 FUNCTION get_shipaddressxml(p_line_location_id number)  return CLOB;
23 FUNCTION is_contingencyContract(p_doc_id NUMBER,p_doc_type varchar2) RETURN VARCHAR2;
24 FUNCTION is_EmergencyRequestContract(p_doc_id NUMBER,p_doc_type varchar2) RETURN VARCHAR2;
25 FUNCTION get_miscclausetext(p_scn_id NUMBER) RETURN CLOB;
26 FUNCTION get_requirementsdesc(isMod VARCHAR2) RETURN CLOB;
27 FUNCTION getGovtSharePerc(isMod VARCHAR2) RETURN number;
28 FUNCTION getMonetaryAmount(isMod VARCHAR2) RETURN number;
29 FUNCTION getCtMonetaryAmount(isMod VARCHAR2) RETURN number;
30 FUNCTION getDiffAttribute(p_element VARCHAR2,p_column_name VARCHAR2, p_line_id NUMBER:=NULL  ,p_line_location_id NUMBER := NULL ,p_distribution_id NUMBER := NULL  ) RETURN CLOB;
31 FUNCTION getDiffelement(p_element VARCHAR2,p_old_value varchar2, p_new_value varchar2) RETURN CLOB;
32 FUNCTION getElement(p_element VARCHAR2,p_line_id NUMBER:=NULL  ,p_line_location_id NUMBER := NULL ,p_distribution_id NUMBER := NULL) RETURN CLOB;
33 FUNCTION populateAttrDiff RETURN BOOLEAN;
34 FUNCTION getTimezone(p_date DATE) RETURN VARCHAR2;
35 FUNCTION GetVariableValue(p_cat_id number,p_variable_code varchar2,p_variable_value_id varchar2,p_attribute_value_set_id number)  return VARCHAR2;
36 FUNCTION get_miscclausetxt(p_scn_id NUMBER,isMod VARCHAR2) RETURN CLOB ;
37 FUNCTION getOtherAmounts(isMod varchar2, p_amt_type varchar2) RETURN NUMBER;
38 FUNCTION get_currency_xml RETURN CLOB;
39 FUNCTION getattachmentbintext(p_media_id number) RETURN CLOB;
40 FUNCTION get_contract_desc RETURN CLOB;
41 FUNCTION get_charge_acc_comp_val(p_col_name VARCHAR2, p_code_comb_id NUMBER) RETURN VARCHAR2;
42 FUNCTION get_change_line_text_desc_B(p_line_id varchar2) RETURN VARCHAR2;
43 FUNCTION getArticleText(p_article_version_id NUMBER, p_article_id NUMBER) RETURN CLOB ;
44 FUNCTION get_ModificationReason RETURN VARCHAR2;
45 FUNCTION getregulationURLMod(p_docid number, p_draftid number, p_doctype varchar2) RETURN CLOB;
46 FUNCTION getClauseChangeText(p_kartid NUMBER) RETURN CLOB;
47 FUNCTION get_clause_variable_pairs(p_kart_id NUMBER) RETURN CLOB;
48 FUNCTION get_order_mod_identifier(p_header_id NUMBER, p_draft_id NUMBER) RETURN VARCHAR2;
49 FUNCTION get_award_mod_identifier(p_header_id NUMBER, p_draft_id NUMBER) RETURN VARCHAR2;
50 FUNCTION containsNumber(p_string varchar2) return varchar2;
51 
52 CURSOR csr_eda_mapping(attr VARCHAR2,ebs_value varchar) IS
53 SELECT EDA
54 FROM po_eda_mapping
55 WHERE Upper(Grouping) = 'AWARDHEADER'
56 AND Upper(ATTRIBUTE) =  Upper(attr)
57 AND Upper(EBS) =  Upper(ebs_value);
58 
59   P_SYSADMIN VARCHAR2(100);
60   DOCUMENTTYPE VARCHAR2(100);
61   DOCUMENTID NUMBER;
62   DRAFTID NUMBER;
63   ISMOD VARCHAR2(1);
64   SCHEMAVERSION VARCHAR2(10);
65   P_DITPRNUMBER NUMBER;
66   P_DOC_PURPOSE VARCHAR2(30);
67 
68 
69 l_temp_attr VARCHAR2(4000);
70 p_Amount NUMBER;
71 
72 END po_eda_datatemplate_pkg;