1 package FND_CONC_SSWA AUTHID CURRENT_USER as
2 /* $Header: AFCPSSUS.pls 120.2.12020000.1 2012/06/30 13:10:10 appldev ship $ */
3
4 --
5 -- Package
6 -- FND_CONC_SSWA
7 -- Purpose
8 -- Utilities for the Concurrent Self Service Web Applications
9 -- History
10 --
11 -- PUBLIC VARIABLES
12 --
13
14 -- Exceptions
15
16 -- Exception Pragmas
17
18 --
19 -- PUBLIC FUNCTIONS
20 --
21
22 --
23 -- Name
24 -- get_phase
25 -- Purpose
26 -- Returns a translated phase description.
27 --
28 function get_phase (pcode in char,
29 scode in char,
30 hold in char,
31 enbld in char,
32 stdate in date,
33 rid in number) return varchar2;
34
35 pragma restrict_references (get_phase, WNDS);
36
37 --
38 -- Name
39 -- get_sswa_status
40 -- Purpose
41 -- Returns a status code for sswa.
42 --
43 function get_sswa_status (pcode in char,
44 scode in char,
45 hold in char,
46 enbld in char,
47 stdate in date,
48 rid in number) return varchar2;
49
50 pragma restrict_references (get_sswa_status, WNDS);
51
52 --
53 -- Name
54 -- get_status
55 -- Purpose
56 -- Returns a translated status description for sswa.
57 --
58 function get_status (pcode in char,
59 scode in char,
60 hold in char,
61 enbld in char,
62 stdate in date,
63 rid in number) return varchar2;
64
65 pragma restrict_references (get_status, WNDS);
66
67 --
68 -- Name
69 -- map_attr_to_arg
70 -- Purpose
71 -- Maps the application column name - attribute - in fnd_concurrent requests
72 -- to the enabled arguments of the program's desc flexfield
73 function map_attr_to_arg(attrno in number,
74 reqid in number) return varchar2;
75
76 -- FUnction will return schedule description based on the schedule type
77 -- This function is copied from FNDRSRUN form
78
79 function get_sch_desc( request_id IN number) return varchar2;
80
81 pragma restrict_references(get_sch_desc, WNDS);
82
83
84 -- Function will return 'Y'/'N' value based on program has arguments defined
85 -- or not.
86 function program_has_args( program_name IN varchar2,
87 program_appl_id IN number) return varchar2;
88 pragma restrict_references(program_has_args, WNDS);
89
90 -- function will return elapsed time between two times in 'HH24:MI:SS' format
91 -- First argument should be later time
92 -- It returns varchar2
93 function elapsed_time (end_time in date,
94 begin_time in date) return varchar2;
95 pragma restrict_references(elapsed_time, WNDS);
96
97 -- function will return notification list as concatinated string
98 -- It returns varchar2(2000)
99 function get_notifications(request_id in number) return varchar2;
100 pragma restrict_references(get_notifications, WNDS);
101
102 -- This function will return request diagnostics for a given request_id.
103 -- This is a wrapper on top of fnd_conc.diagnose procedure.
104 function diagnostics( request_id IN number ) return varchar2;
105 -- pragma restrict_references(diagnostics, WNDS);
106
107 -- This function will return Y/N based on the request outfile information
108 -- and request status.
109
110 function get_ofile_status(req_id IN number) return varchar2;
111 pragma restrict_references(get_ofile_status, WNDS);
112
113 --
114 -- Name
115 -- layout_enabled
116 -- Purpose
117 -- Returns true if program contains any data definition in xml publisher
118 -- schema.
119 -- Arguments
120 -- ProgramApplName - Concurrent Program Application Short Name
121 -- ProgramShortName - Concurrent Program Short Name
122 --
123 function layout_enabled ( ProgramApplName varchar2,
124 ProgramShortName varchar2) return boolean;
125
126 --
127 -- Name
128 -- layout_enabled_YN
129 -- Purpose
130 -- calls layout_enabled but returns Y or N instead of boolean
131 -- used for calling from C code
132 --
133 function layout_enabled_YN ( ProgramApplName varchar2,
134 ProgramShortName varchar2) return varchar2;
135
136 --
137 -- Name
138 -- publisher_installed
139 -- Purpose
140 -- Returns true if xml publisher installed otherwise false
141 -- Arguments
142 --
143 function publisher_installed return boolean;
144 end FND_CONC_SSWA;