PACKAGE: APPS.QOT_DEFAULT_PVT

Source

1 PACKAGE QOT_DEFAULT_PVT AS
2 /* $Header: qotvdefs.pls 120.4 2006/09/28 09:00:11 hekumar noship $ */
3 -- Package name     : QOT_DEFAULT_PVT
4 -- Purpose          :
5 -- History          :
6 -- NOTE             :
7 -- End of Comments
8 
9 G_PKG_NAME  CONSTANT    VARCHAR2(30):=  'QOT_DEFAULT_PVT';
10 
11 
12 FUNCTION Get_CustAcct_From_CustParty (
13              P_Database_Object_Name    IN   VARCHAR2,
14              P_Attribute_Code          IN   VARCHAR2
15              ) RETURN NUMBER;
16 
17 FUNCTION Get_PriceList_From_Agreement (
18              P_Database_Object_Name    IN   VARCHAR2,
19              P_Attribute_Code          IN   VARCHAR2
20              ) RETURN NUMBER;
21 
22 FUNCTION Get_PriceList_From_CustAcct (
23              P_Database_Object_Name    IN   VARCHAR2,
24              P_Attribute_Code          IN   VARCHAR2
25              ) RETURN NUMBER;
26 
27 FUNCTION Get_PriceList_From_OrderType (
28              P_Database_Object_Name    IN   VARCHAR2,
29              P_Attribute_Code          IN   VARCHAR2
30              ) RETURN NUMBER;
31 
32 FUNCTION Get_PaymentTerm_From_Agreement (
33              P_Database_Object_Name    IN   VARCHAR2,
34              P_Attribute_Code          IN   VARCHAR2
35              ) RETURN NUMBER;
36 
37 FUNCTION Get_ExpirationDate (
38              P_Database_Object_Name    IN   VARCHAR2,
39              P_Attribute_Code          IN   VARCHAR2
40              ) RETURN DATE;
41 
42 FUNCTION Get_QuoteAddress (
43              P_Database_Object_Name    IN   VARCHAR2,
44              P_Attribute_Code          IN   VARCHAR2
45              ) RETURN NUMBER;
46 
47 FUNCTION Get_QuotePhone (
48              P_Database_Object_Name    IN   VARCHAR2,
49              P_Attribute_Code          IN   VARCHAR2
50              ) RETURN NUMBER;
51 
52 FUNCTION Get_BillAddress (
53              P_Database_Object_Name    IN   VARCHAR2,
54              P_Attribute_Code          IN   VARCHAR2
55              ) RETURN NUMBER;
56 
57 FUNCTION Get_ShipAddress (
58 		   P_Database_Object_Name    IN   VARCHAR2,
59              P_Attribute_Code          IN   VARCHAR2
60              ) RETURN NUMBER;
61 
62 FUNCTION Get_SalesGroup_From_Profile (
63              P_Database_Object_Name    IN   VARCHAR2,
64              P_Attribute_Code          IN   VARCHAR2
65              ) RETURN NUMBER;
66 
67 FUNCTION Get_SalesGroup_From_Salesrep(
68              P_Database_Object_Name    IN   VARCHAR2,
69              P_Attribute_Code          IN   VARCHAR2
70              ) RETURN NUMBER;
71 
72 FUNCTION Get_SalesRep(
73              P_Database_Object_Name    IN   VARCHAR2,
74              P_Attribute_Code          IN   VARCHAR2
75              ) RETURN NUMBER;
76 
77 FUNCTION Get_Currency_From_Pricelist(
78              P_Database_Object_Name    IN   VARCHAR2,
79              P_Attribute_Code          IN   VARCHAR2
80              ) RETURN VARCHAR2;
81 
82 FUNCTION Get_Currency_from_Profile(
83              P_Database_Object_Name    IN   VARCHAR2,
84              P_Attribute_Code          IN   VARCHAR2
85              ) RETURN VARCHAR2;
86 
87 FUNCTION Get_OperatingUnit(
88              P_Database_Object_Name    IN   VARCHAR2,
89              P_Attribute_Code          IN   VARCHAR2
90              ) RETURN NUMBER;
91 
92 FUNCTION Get_OrderType(
93              P_Database_Object_Name    IN   VARCHAR2,
94              P_Attribute_Code          IN   VARCHAR2
95              ) RETURN NUMBER;
96 
97 FUNCTION Get_ContractTemplate(
98              P_Database_Object_Name    IN   VARCHAR2,
99              P_Attribute_Code          IN   VARCHAR2
100              ) RETURN NUMBER;
101 
102 FUNCTION Get_RequestedDateType(
103              P_Database_Object_Name    IN   VARCHAR2,
104              P_Attribute_Code          IN   VARCHAR2
105              ) RETURN VARCHAR2;
106 
107 FUNCTION Get_PaymentTerm_From_Customer(
108              P_Database_Object_Name    IN   VARCHAR2,
109              P_Attribute_Code          IN   VARCHAR2
110              ) RETURN NUMBER;
111 
112 FUNCTION Get_ChargePeriodicity(
113              P_Database_Object_Name    IN   VARCHAR2,
114              P_Attribute_Code          IN   VARCHAR2
115              ) RETURN VARCHAR2;
116 
117 END QOT_DEFAULT_PVT;