1 PACKAGE OE_Default_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OEXVDEFS.pls 120.2 2012/01/03 18:57:15 gabhatia ship $ */
3
4
5 --R12 CC Encryption
6 --Global variable to store the instrument id for the credit
7 --card returned by the payments API
8
9 g_default_instrument_id NUMBER DEFAULT NULL;
10 g_default_instr_assignment_id NUMBER DEFAULT NULL;
11
12 ----------------------------------------------------------------
13 -- DEFAULTING FUNCTIONS FOR ATTRIBUTES ON ORDER HEADER
14 ----------------------------------------------------------------
15
16 FUNCTION Get_Tax_Exempt_Number
17 ( p_database_object_name IN VARCHAR2
18 ,p_attribute_code IN VARCHAR2)
19 RETURN VARCHAR2;
20
21 FUNCTION Get_CC_Expiration_Date
22 ( p_database_object_name IN VARCHAR2
23 ,p_attribute_code IN VARCHAR2)
24 RETURN VARCHAR2;
25
26 FUNCTION Get_CC_Holder_Name
27 ( p_database_object_name IN VARCHAR2
28 ,p_attribute_code IN VARCHAR2)
29 RETURN VARCHAR2;
30
31 FUNCTION Get_Credit_Card_Number
32 ( p_database_object_name IN VARCHAR2
33 ,p_attribute_code IN VARCHAR2)
34 RETURN VARCHAR2;
35
36 FUNCTION Get_Tax_Exempt_Reason
37 ( p_database_object_name IN VARCHAR2
38 ,p_attribute_code IN VARCHAR2)
39 RETURN VARCHAR2;
40
41 FUNCTION Get_Tax_Exemption_Details
42 ( p_database_object_name IN VARCHAR2
43 ,p_attribute_code IN VARCHAR2)
44 RETURN VARCHAR2;
45
46 FUNCTION Get_SOB_Currency_Code
47 ( p_database_object_name IN VARCHAR2
48 ,p_attribute_code IN VARCHAR2)
49 RETURN VARCHAR2;
50
51
52 ----------------------------------------------------------------
53 -- DEFAULTING FUNCTIONS FOR ATTRIBUTES ON ORDER LINE
54 ----------------------------------------------------------------
55
56 FUNCTION Get_Tax_Code
57 ( p_database_object_name IN VARCHAR2
58 ,p_attribute_code IN VARCHAR2)
59 RETURN VARCHAR2;
60
61 FUNCTION Get_Commitment_From_Agreement
62 ( p_database_object_name IN VARCHAR2
63 ,p_attribute_code IN VARCHAR2)
64 RETURN NUMBER;
65
66 FUNCTION Get_Accounting_Rule_Duration
67 ( p_database_object_name IN VARCHAR2
68 ,p_attribute_code IN VARCHAR2)
69 RETURN NUMBER;
70
71 -- QUOTING changes
72 -- Returns ID of the primary location with site use of 'SOLD_TO'
73 -- for the customer on order header.
74 -- Used in seeded defaulting rule for 'Customer Location' field
75 FUNCTION Get_Primary_Customer_Location
76 ( p_database_object_name IN VARCHAR2
77 ,p_attribute_code IN VARCHAR2)
78 RETURN VARCHAR2;
79
80 FUNCTION Get_Receipt_Method
81 ( p_database_object_name IN VARCHAR2
82 ,p_attribute_code IN VARCHAR2)
83 RETURN NUMBER;
84
85 -- Bug 3581592
86 -- Default deliver to via the API instead of Related Record rule as there
87 -- is a performance issue with oe_ak_sold_to_orgs_v if primary deliver to
88 -- is fetched via the view.
89 FUNCTION Get_Primary_Deliver_To
90 ( p_database_object_name IN VARCHAR2
91 ,p_attribute_code IN VARCHAR2)
92 RETURN VARCHAR2;
93
94 --added for bug 13088960
95 FUNCTION Get_Latest_Acceptable_Date(
96 P_Database_Object_Name In Varchar2,
97 P_Attribute_Code In Varchar2
98 )
99 RETURN DATE ;
100
101 END OE_Default_Pvt;
102