1 package FND_REQUEST_SET as
2 /* $Header: AFRSSUBS.pls 120.2 2005/08/12 04:38:39 ktanneru ship $ */
3
4
5 -- Name
6 -- STANDARD_STAGE_EVALUATION
7 --
8 -- Purpose
9 -- Standard evaluation function for Request Set Stages.
10 -- Returns 'E' if any errors occurred in the stage requests.
11 -- Returns 'W' if there were any Warnings and no Errors in the
12 -- stage requests.
13 -- Returns 'S' if all requests were sucessfull.
14 -- Will also return 'S' if there are no requests to evaluate.
15 --
16 function standard_stage_evaluation return varchar2;
17
18 --
19 -- These values can be used to tune the amount of time the standard
20 -- stage evaluation function will wait on running requests
21 -- stage_looptimes = the number of times it will loop, waiting for the request to finish
22 -- stage_sleeptime = the number of seconds it will sleep
23 -- Set these values higher if you are experiencing requests that take a longer time to complete.
24 --
25 stage_looptimes integer := 5;
26 stage_sleeptime integer := 10;
27
28
29 -- Name
30 -- STAGE_REQUEST_INFO
31 --
32 -- Purpose
33 -- Cursor to be used in stage functions to retrieve
34 -- info about the critical requests in the stage.
35 --
36 cursor stage_request_info is
37 select
38 r.request_id,
39 a.application_short_name program_appl_short_name,
40 p.concurrent_program_name program_short_name,
41 decode(r.status_code, 'C', 'S', 'G', 'W', 'R', 'R', 'E') exit_status,
42 r.post_request_status,
43 r.req_information request_data
44 from fnd_concurrent_requests r,
45 fnd_application a,
46 fnd_concurrent_programs p
47 where r.program_application_id = a.application_id
48 and r.program_application_id = p.application_id
49 and r.concurrent_program_id = p.concurrent_program_id
50 and r.parent_request_id = fnd_global.conc_request_id
51 and r.critical = 'Y'
52 order by request_id;
53
54
55 -- Name
56 -- GET_STAGE_PARAMETER
57 --
58 -- Purpose
59 -- Used by stage functions to retrieve parameter
60 -- values for the current stage.
61 --
62 function get_stage_parameter(name in varchar2) return varchar2;
63
64
65 -- Name
66 -- FNDRSSUB
67 -- Purpose
68 -- Request set master program. Submit request set
69 -- stages and collect results.
70 --
71 -- Arguments
72 -- errbuff - Completion message.
73 -- retcode - 0 = Success, 1 = Waring, 2 = Failure
74 -- appl_id - Set Application ID
75 -- set_id - Request Set ID
76
77 procedure fndrssub(
78 errbuf out nocopy varchar2,
79 retcode out nocopy number,
80 appl_id in number,
81 set_id in number);
82
83
84 -- Name
85 -- FNDRSSTG
86 -- Purpose
87 -- Request set stage master program. Submit request set
88 -- programs and collect results.
89 --
90 -- Arguments
91 -- errbuff - Completion message.
92 -- retcode - 0 = Success, 1 = Waring, 2 = Failure
93 -- appl_id - Set Application ID
94 -- set_id - Request Set ID
95 -- stage_id - Request Set Stage ID
96
97 procedure fndrsstg(
98 errbuf out nocopy varchar2,
99 retcode out nocopy number,
100 appl_id in number,
101 set_id in number,
102 stage_id in number,
103 parent_id in number,
104 restart_flag in number default 0);
105
106 end FND_REQUEST_SET;