23: -- Global constant holding the package name
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_PRICE_LIST_Def_Util';
25:
26:
27: g_database_object_name varchar2(30) :='OE_PRICE_LISTS_V';
28:
29:
30: FUNCTION Get_Attr_Val_Varchar2
31: ( p_attr_code IN VARCHAR2
28:
29:
30: FUNCTION Get_Attr_Val_Varchar2
31: ( p_attr_code IN VARCHAR2
32: , p_record IN OE_PRICE_LISTS_V%ROWTYPE
33: ) RETURN VARCHAR2
34: IS
35: BEGIN
36:
71:
72:
73: FUNCTION Get_Attr_Val_Date
74: ( p_attr_code IN VARCHAR2
75: , p_record IN OE_PRICE_LISTS_V%ROWTYPE
76: ) RETURN DATE
77: IS
78: BEGIN
79:
127:
128: ) RETURN NUMBER
129: IS
130: CURSOR cache IS
131: SELECT * FROM OE_PRICE_LISTS_V
132: WHERE PRICE_LIST_ID = p_PRICE_LIST_ID
133: ;
134: BEGIN
135: