23: -- Global constant holding the package name
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_CUST_ITEM_Def_Util';
25:
26:
27: g_database_object_name varchar2(30) :='OE_AK_MTL_CUST_ITEMS_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_AK_MTL_CUST_ITEMS_V%ROWTYPE
33: ) RETURN VARCHAR2
34: IS
35: BEGIN
36:
59:
60:
61: FUNCTION Get_Attr_Val_Date
62: ( p_attr_code IN VARCHAR2
63: , p_record IN OE_AK_MTL_CUST_ITEMS_V%ROWTYPE
64: ) RETURN DATE
65: IS
66: BEGIN
67:
103:
104: ) RETURN NUMBER
105: IS
106: CURSOR cache IS
107: SELECT * FROM OE_AK_MTL_CUST_ITEMS_V
108: WHERE CUSTOMER_ITEM_ID = p_CUSTOMER_ITEM_ID
109: ;
110: BEGIN
111: