APPS.ONT_HEADER_DEF_UTIL dependencies on OE_AK_ORDER_HEADERS_V

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

23: -- Global constant holding the package name
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_HEADER_Def_Util';
25:
26:
27: g_database_object_name varchar2(30) :='OE_AK_ORDER_HEADERS_V';
28:
29: TYPE Condition_Rec_Type IS RECORD (
30: condition_id NUMBER,
31: group_number NUMBER,

Line 45: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

41:
42:
43: FUNCTION Get_Attr_Val_Varchar2
44: ( p_attr_code IN VARCHAR2
45: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
46: ) RETURN VARCHAR2
47: IS
48: BEGIN
49:

Line 994: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

990:
991:
992: FUNCTION Get_Attr_Val_Date
993: ( p_attr_code IN VARCHAR2
994: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
995: ) RETURN DATE
996: IS
997: BEGIN
998:

Line 1956: SELECT * FROM OE_AK_ORDER_HEADERS_V

1952:
1953: ) RETURN NUMBER
1954: IS
1955: CURSOR cache IS
1956: SELECT * FROM OE_AK_ORDER_HEADERS_V
1957: WHERE HEADER_ID = p_HEADER_ID
1958: ;
1959: BEGIN
1960:

Line 1985: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

1981:
1982:
1983: FUNCTION Get_Foreign_Attr_Val_Varchar2
1984: ( p_foreign_attr_code IN VARCHAR2
1985: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
1986: , p_foreign_database_object_name IN VARCHAR2
1987: ) RETURN VARCHAR2
1988:
1989: IS

Line 2560: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE

2556: END Get_Foreign_Attr_Val_Varchar2;
2557:
2558: FUNCTION Get_Foreign_Attr_Val_Date
2559: ( p_foreign_attr_code IN VARCHAR2
2560: , p_record IN OE_AK_ORDER_HEADERS_V%ROWTYPE
2561: , p_foreign_database_object_name IN VARCHAR2
2562: ) RETURN DATE
2563:
2564: IS

Line 3093: , p_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE

3089: RETURN -1;
3090: END Get_Condition_Index_In_Cache;
3091: FUNCTION Validate_Defaulting_Condition
3092: ( p_condition_id IN NUMBER
3093: , p_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
3094: ) RETURN BOOLEAN
3095: IS
3096: CURSOR CONDNS IS
3097: SELECT condition_id,group_number,attribute_code,

Line 3240: , p_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE

3236:
3237: PROCEDURE Get_Valid_Defaulting_Rules
3238: ( p_attr_code IN VARCHAR2
3239: , p_attr_id IN NUMBER
3240: , p_header_rec IN OE_AK_ORDER_HEADERS_V%ROWTYPE
3241: , x_rules_start_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
3242: , x_rules_stop_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
3243: ) IS
3244: l_condn_index NUMBER;