DBA Data[Home] [Help]

APPS.ONT_HEADER_PAYMENT_DEF_UTIL dependencies on OE_AK_HEADER_PAYMENTS_V

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

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

Line 45: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

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

Line 352: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

348:
349:
350: FUNCTION Get_Attr_Val_Date
351: ( p_attr_code IN VARCHAR2
352: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
353: ) RETURN DATE
354: IS
355: BEGIN
356:

Line 676: SELECT * FROM OE_AK_HEADER_PAYMENTS_V

672:
673: ) RETURN NUMBER
674: IS
675: CURSOR cache IS
676: SELECT * FROM OE_AK_HEADER_PAYMENTS_V
677: WHERE PAYMENT_NUMBER = p_PAYMENT_NUMBER
678: AND HEADER_ID = p_HEADER_ID
679: AND LINE_ID = p_LINE_ID
680: ;

Line 711: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

707:
708:
709: FUNCTION Get_Foreign_Attr_Val_Varchar2
710: ( p_foreign_attr_code IN VARCHAR2
711: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
712: , p_foreign_database_object_name IN VARCHAR2
713: ) RETURN VARCHAR2
714:
715: IS

Line 735: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

731: END Get_Foreign_Attr_Val_Varchar2;
732:
733: FUNCTION Get_Foreign_Attr_Val_Date
734: ( p_foreign_attr_code IN VARCHAR2
735: , p_record IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
736: , p_foreign_database_object_name IN VARCHAR2
737: ) RETURN DATE
738:
739: IS

Line 771: , p_header_payment_rec IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

767: RETURN -1;
768: END Get_Condition_Index_In_Cache;
769: FUNCTION Validate_Defaulting_Condition
770: ( p_condition_id IN NUMBER
771: , p_header_payment_rec IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
772: ) RETURN BOOLEAN
773: IS
774: CURSOR CONDNS IS
775: SELECT condition_id,group_number,attribute_code,

Line 918: , p_header_payment_rec IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE

914:
915: PROCEDURE Get_Valid_Defaulting_Rules
916: ( p_attr_code IN VARCHAR2
917: , p_attr_id IN NUMBER
918: , p_header_payment_rec IN OE_AK_HEADER_PAYMENTS_V%ROWTYPE
919: , x_rules_start_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
920: , x_rules_stop_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
921: ) IS
922: l_condn_index NUMBER;