1 PACKAGE AP_WEB_DB_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdbuts.pls 115.7 2003/10/15 21:26:01 skoukunt noship $ */
3
4 /* FND product installations */
5 ---------------------------------------------------------------------------------------------------
6 SUBTYPE fndProdInst_prodVer IS
7 FND_PRODUCT_INSTALLATIONS.product_version%TYPE;
8
9 SUBTYPE fndApp_appID IS
10 FND_APPLICATION.application_id%TYPE;
11
12 /* Other or Miscellaneous */
13 -- Date format
14 C_DetailedDateFormat CONSTANT VARCHAR2(100) := 'YYYY/MM/DD HH24:MI:SS';
15
16
17 -------------------------------------------------------------------
18 -- Name: RaiseException
19 -- Desc: common routine for handling unrecoverrable(database) errors
20 -- Params: p_calling_squence - the name of the caller function
21 -- p_debug_info - additional error message
22 -- p_set_name - fnd message name
23 -- p_params - fnd message parameters
24 -------------------------------------------------------------------
25 PROCEDURE RaiseException(
26 p_calling_sequence IN VARCHAR2,
27 p_debug_info IN VARCHAR2 DEFAULT '',
28 p_set_name IN VARCHAR2 DEFAULT NULL,
29 p_params IN VARCHAR2 DEFAULT ''
30 );
31
32
33 -------------------------------------------------------------------
34 -- Name: GetSysDate
35 -- Desc: get the current date
36 -- Params: p_sysDate - used to store the current date info
37 -- Returns: true - succeed
38 -- false - fail
39 -------------------------------------------------------------------
40 FUNCTION GetSysDate(
41 p_sysDate OUT NOCOPY VARCHAR2
42 ) RETURN BOOLEAN;
43
44
45 -------------------------------------------------------------------
46 -- Name: GetFormattedSysDate
47 -- Desc: get the current date in the given format
48 -- Params: p_format - the given format for the date info
49 -- p_formatted_date - used to store the formatted date info
50 -- Returns: true - succeed
51 -- false - fail
52 -------------------------------------------------------------------
53 FUNCTION GetFormattedSysDate(
54 p_format IN VARCHAR2,
55 p_formatted_date OUT NOCOPY VARCHAR2
56 ) RETURN BOOLEAN;
57
58
59 -------------------------------------------------------------------
60 -- Name: DayOfWeek
61 -- Desc: get the order of the given date in a week
62 -- Params: p_date - the given date
63 -- p_day_of_week - in what day of the week the given date is in
64 -- Returns: true - succeed
65 -- false - fail
66 -------------------------------------------------------------------
67 FUNCTION DayOfWeek(
68 p_date IN VARCHAR2,
69 p_day_of_week OUT NOCOPY NUMBER
70 ) RETURN BOOLEAN;
71
72 -------------------------------------------------------------------
73 -- Name: GetProductVersion
74 -- Desc: get the version number of the installed product
75 -- Params: p_version - the returned version number of the product
76 -- Returns: true - succeed
77 -- false - fail
78 -------------------------------------------------------------------
79 FUNCTION GetProductVersion(
80 p_version OUT NOCOPY fndProdInst_prodVer
81 ) RETURN BOOLEAN;
82
83 -------------------------------------------------------------------
84 -- Name: GetApplicationID
85 -- Desc: get the applicationID for SQLAP
86 -- Params: None
87 -- Returns: Application ID
88 -------------------------------------------------------------------
89 FUNCTION GetApplicationID RETURN fndApp_appID;
90
91
92 FUNCTION jsPrepString_long(p_string in long,
93 p_alertflag in boolean default FALSE,
94 p_jsargflag in boolean default FALSE) RETURN LONG;
95
96 FUNCTION jsPrepString(p_string in varchar2,
97 p_alertflag in boolean default FALSE,
98 p_jsargflag in boolean default FALSE) RETURN VARCHAR2;
99
100 FUNCTION AtLeastProd16 RETURN BOOLEAN;
101
102 FUNCTION CharToNumber (p_unformatted_amt IN VARCHAR)
103 RETURN NUMBER ;
104
105
106 END AP_WEB_DB_UTIL_PKG;