DBA Data[Home] [Help]

APPS.ONT_LINE_PAYMENT_DEF_UTIL dependencies on OE_AK_LINE_PAYMENTS_V

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

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

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

Line 352: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE

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

Line 676: SELECT * FROM OE_AK_LINE_PAYMENTS_V

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

Line 711: , p_record IN OE_AK_LINE_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_LINE_PAYMENTS_V%ROWTYPE
712: , p_foreign_database_object_name IN VARCHAR2
713: ) RETURN VARCHAR2
714:
715: IS

Line 745: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE

741: END Get_Foreign_Attr_Val_Varchar2;
742:
743: FUNCTION Get_Foreign_Attr_Val_Date
744: ( p_foreign_attr_code IN VARCHAR2
745: , p_record IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
746: , p_foreign_database_object_name IN VARCHAR2
747: ) RETURN DATE
748:
749: IS

Line 790: , p_line_payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE

786: RETURN -1;
787: END Get_Condition_Index_In_Cache;
788: FUNCTION Validate_Defaulting_Condition
789: ( p_condition_id IN NUMBER
790: , p_line_payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
791: ) RETURN BOOLEAN
792: IS
793: CURSOR CONDNS IS
794: SELECT condition_id,group_number,attribute_code,

Line 937: , p_line_payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE

933:
934: PROCEDURE Get_Valid_Defaulting_Rules
935: ( p_attr_code IN VARCHAR2
936: , p_attr_id IN NUMBER
937: , p_line_payment_rec IN OE_AK_LINE_PAYMENTS_V%ROWTYPE
938: , x_rules_start_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
939: , x_rules_stop_index_tbl OUT OE_GLOBALS.NUMBER_TBL_Type
940: ) IS
941: l_condn_index NUMBER;