1 PACKAGE PON_PRICE_ELEMENTS_PKG AUTHID CURRENT_USER as
2 /* $Header: PONPETPS.pls 120.1 2006/04/13 09:53:46 sapandey noship $ */
3
4
5 PROCEDURE insert_price_element(p_type_id IN NUMBER,
6 p_code IN VARCHAR2,
7 p_name IN VARCHAR2,
8 p_description IN VARCHAR2,
9 p_enabledFlag IN VARCHAR2,
10 p_partyId IN NUMBER,
11 p_source_language IN VARCHAR2,
12 p_pricingBasis IN VARCHAR2,
13 p_contactId IN NUMBER,
14 p_result OUT NOCOPY NUMBER,
15 p_err_code OUT NOCOPY VARCHAR2,
16 p_err_msg OUT NOCOPY VARCHAR2);
17
18
19 PROCEDURE update_price_element(p_typeId IN NUMBER,
20 p_code IN VARCHAR2,
21 p_name IN VARCHAR2,
22 p_description IN VARCHAR2,
23 p_enabledFlag IN VARCHAR2,
24 p_partyId IN NUMBER,
25 p_language IN VARCHAR2,
26 p_pricingBasis IN VARCHAR2,
27 p_contactId IN NUMBER,
28 p_lastUpdate IN DATE,
29 p_result OUT NOCOPY NUMBER,
30 p_err_code OUT NOCOPY VARCHAR2,
31 p_err_msg OUT NOCOPY VARCHAR2);
32
33 -- ======================================================================
34 -- PROCEDURE : ADD_LANGUAGE
35 -- COMMENT : Used to popluate the PON_PRICE_ELEMENT_TYPES_TL table when
36 -- a new language is added. It is called from sql/PONNLINS.sql
37 -- ======================================================================
38 PROCEDURE ADD_LANGUAGE;
39
40 end PON_PRICE_ELEMENTS_PKG;
[Home] [Help]