DBA Data[Home] [Help]

APPS.ONT_SOLD_TO_ORG_DEF_UTIL dependencies on OE_AK_SOLD_TO_ORGS_V

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

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

Line 32: , p_record IN OE_AK_SOLD_TO_ORGS_V%ROWTYPE

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

Line 183: , p_record IN OE_AK_SOLD_TO_ORGS_V%ROWTYPE

179:
180:
181: FUNCTION Get_Attr_Val_Date
182: ( p_attr_code IN VARCHAR2
183: , p_record IN OE_AK_SOLD_TO_ORGS_V%ROWTYPE
184: ) RETURN DATE
185: IS
186: BEGIN
187:

Line 349: SELECT * FROM OE_AK_SOLD_TO_ORGS_V

345:
346: ) RETURN NUMBER
347: IS
348: CURSOR cache IS
349: SELECT * FROM OE_AK_SOLD_TO_ORGS_V
350: WHERE ORGANIZATION_ID = p_ORGANIZATION_ID
351: AND ORG_ID = p_ORG_ID
352: ;
353: BEGIN