1 PACKAGE fnd_cp_opp_req AUTHID CURRENT_USER AS
2 /* $Header: AFCPOPRS.pls 120.2.12000000.3 2007/10/06 07:17:21 ddhulla ship $ */
3
4
5 -- POST_REQUEST_STATUS status codes
6 PP_PENDING constant varchar2(1) := 'P';
7 PP_COMPLETE constant varchar2(1) := 'C';
8 PP_TIMEOUT constant varchar2(1) := 'T';
9 PP_ERROR constant varchar2(1) := 'E';
10
11 --------------------------------------------------------------------------------
12
13
14 --
15 -- published_request
16 --
17 -- Given a request id, determine if this request has publishing actions
18 --
19 function published_request(reqid in number) return boolean ;
20
21
22
23 -- ============================
24 -- OPP service procedures
25 -- ============================
26
27 -- Added for bug Bug 6275963
28 --
29 -- published_request
30 --
31 -- Used to determine whether the request is a published request. If the request is a
32 -- simple reprint request of a published request in that case parent request id is passed
33 -- as the published request in the out parameter pub_req_id
34 --
35 -- reqid - Concurrent request id
36 -- is_published - boolean variable to return whether the request is a published request
37 -- pub_reqid - Request id of the published request. Incase the request passed as reqid
38 -- is a simple reprint of a published request then the parent request id
39 -- will be passed as pub_reqid else it will be same as reqid
40
41 procedure published_request (reqid in number,
42 is_published out NOCOPY boolean,
43 pub_req_id out NOCOPY number);
44
45
46 --
47 -- update_actions_table
48 --
49 -- Used by the OPP service to update the FND_CONC_PP_ACTIONS table
50 -- The table is only updated if it has not been previously updated by another process
51 --
52 -- reqid - Concurrent request id
53 -- procid - Concurrent process id of the service. FND_CONC_PP_ACTIONS.PROCESSOR_ID will be updated
54 -- with this value for all pp actions for this request
55 -- success - Y if the table was updated, N if the table has already been updated.
56 --
57 procedure update_actions_table(reqid in number, procid in number,
58 success out NOCOPY varchar2);
59
60
61
62
63 -- =======================================
64 -- Request-Processing Manager procedures
65 -- =======================================
66
67 --
68 -- select_postprocessor
69 --
70 -- Looks for a post-processor service to post-process a request
71 -- First uses the same node name the manager is running on.
72 -- If a PP service is running there, it returns that node name.
73 -- If one is not found, it picks a random PP service.
74 -- Errcode will be 0 if a post-processor was found.
75 -- If no post-processor is available, or an error occurs, errcode
76 -- will be < 0.
77 --
78 -- Note: Can only be called from a concurrent manager
79 --
80 procedure select_postprocessor(opp_name out NOCOPY varchar2,
81 errcode out NOCOPY number,
82 requestid in number);
83
84
85 --
86 -- postprocess
87 --
88 -- Post-process a request
89 -- Used by request-processing managers to submit a request to the post-processor
90 --
91 -- reqid - Request id to postprocess
92 -- groupid - Group to send request to
93 -- success_flag - Y if request was postprocessed successfully, N otherwise
94 -- errmsg - Reason for failure
95 --
96 procedure postprocess(reqid in number,
97 groupid in varchar2,
98 success_flag out NOCOPY varchar2,
99 errmsg out NOCOPY varchar2);
100
101
102
103
104 -- ============================
105 -- Reprint procedures
106 -- ============================
107
108
109 --
110 -- adjust_outfile
111 --
112 -- Used by the Republish/Reprint program to properly set its output file for
113 -- republishing and/or reprinting
114 --
115 -- cur_reqid - Current request id
116 -- prev_reqid - Request to reprint/republish
117 -- success_flag - Y if output file updated, N otherwise
118 -- errmsg - Reason for failure
119 --
120 procedure adjust_outfile(cur_reqid in number,
121 prev_reqid in number,
122 success_flag out NOCOPY varchar2,
123 errmsg out NOCOPY varchar2);
124
125
126
127 END fnd_cp_opp_req;