DBA Data[Home] [Help]

APPS.ONT_TOL_CUST_ITEM_DEF_UTIL dependencies on OE_AK_TOL_CUST_ITEMS_V

Line 27: g_database_object_name varchar2(30) :='OE_AK_TOL_CUST_ITEMS_V';

23: -- Global constant holding the package name
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_TOL_CUST_ITEM_Def_Util';
25:
26:
27: g_database_object_name varchar2(30) :='OE_AK_TOL_CUST_ITEMS_V';
28:
29:
30: FUNCTION Get_Attr_Val_Varchar2
31: ( p_attr_code IN VARCHAR2

Line 32: , p_record IN OE_AK_TOL_CUST_ITEMS_V%ROWTYPE

28:
29:
30: FUNCTION Get_Attr_Val_Varchar2
31: ( p_attr_code IN VARCHAR2
32: , p_record IN OE_AK_TOL_CUST_ITEMS_V%ROWTYPE
33: ) RETURN VARCHAR2
34: IS
35: BEGIN
36:

Line 93: , p_record IN OE_AK_TOL_CUST_ITEMS_V%ROWTYPE

89:
90:
91: FUNCTION Get_Attr_Val_Date
92: ( p_attr_code IN VARCHAR2
93: , p_record IN OE_AK_TOL_CUST_ITEMS_V%ROWTYPE
94: ) RETURN DATE
95: IS
96: BEGIN
97:

Line 169: SELECT * FROM OE_AK_TOL_CUST_ITEMS_V

165:
166: ) RETURN NUMBER
167: IS
168: CURSOR cache IS
169: SELECT * FROM OE_AK_TOL_CUST_ITEMS_V
170: WHERE CUSTOMER_ID = p_CUSTOMER_ID
171: AND INTERNAL_ITEM_ID = p_INTERNAL_ITEM_ID
172: ;
173: BEGIN