DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on OE_AK_ORDER_LINES_V

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

23: -- Global constant holding the package name
24: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ONT_LINE_Def_Util';
25:
26:
27: g_database_object_name varchar2(30) :='OE_AK_ORDER_LINES_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_LINES_V%ROWTYPE

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

Line 1906: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

1902:
1903:
1904: FUNCTION Get_Attr_Val_Date
1905: ( p_attr_code IN VARCHAR2
1906: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
1907: ) RETURN DATE
1908: IS
1909: BEGIN
1910:

Line 3780: SELECT * FROM OE_AK_ORDER_LINES_V

3776:
3777: ) RETURN NUMBER
3778: IS
3779: CURSOR cache IS
3780: SELECT * FROM OE_AK_ORDER_LINES_V
3781: WHERE LINE_ID = p_LINE_ID
3782: ;
3783: BEGIN
3784:

Line 3809: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

3805:
3806:
3807: FUNCTION Get_Foreign_Attr_Val_Varchar2
3808: ( p_foreign_attr_code IN VARCHAR2
3809: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
3810: , p_foreign_database_object_name IN VARCHAR2
3811: ) RETURN VARCHAR2
3812:
3813: IS

Line 4409: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE

4405: END Get_Foreign_Attr_Val_Varchar2;
4406:
4407: FUNCTION Get_Foreign_Attr_Val_Date
4408: ( p_foreign_attr_code IN VARCHAR2
4409: , p_record IN OE_AK_ORDER_LINES_V%ROWTYPE
4410: , p_foreign_database_object_name IN VARCHAR2
4411: ) RETURN DATE
4412:
4413: IS

Line 4970: , p_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE

4966: RETURN -1;
4967: END Get_Condition_Index_In_Cache;
4968: FUNCTION Validate_Defaulting_Condition
4969: ( p_condition_id IN NUMBER
4970: , p_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
4971: ) RETURN BOOLEAN
4972: IS
4973: CURSOR CONDNS IS
4974: SELECT condition_id,group_number,attribute_code,

Line 5117: , p_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE

5113:
5114: PROCEDURE Get_Valid_Defaulting_Rules
5115: ( p_attr_code IN VARCHAR2
5116: , p_attr_id IN NUMBER
5117: , p_line_rec IN OE_AK_ORDER_LINES_V%ROWTYPE
5118: , x_rules_start_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
5119: , x_rules_stop_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
5120: ) IS
5121: l_condn_index NUMBER;