1 PACKAGE PO_MOD_SYNC_PROCESS_PVT AUTHID CURRENT_USER AS
2 /* $Header: PO_MOD_SYNC_PROCESS_PVT.pls 120.4.12020000.2 2013/02/10 18:07:31 vegajula ship $ */
3
4
5 procedure sync_with_award_wf(itemtype in varchar2,
6 itemkey in varchar2,
7 actid in number,
8 funcmode in varchar2,
9 resultout out NOCOPY varchar2);
10
11 procedure sync_with_award(p_draft_id IN NUMBER,
12 p_document_type IN VARCHAR2,
13 p_document_id IN NUMBER,
14 p_reject_if_error IN VARCHAR2,
15 x_return_status OUT NOCOPY VARCHAR2,
16 x_results OUT NOCOPY VARCHAR2);
17
18 PROCEDURE sync_headers(
19 p_draft_id IN NUMBER,
20 p_uda_enabled_flag VARCHAR2,
21 p_ignore_rev_number IN VARCHAR DEFAULT 'N',
22 x_return_status OUT NOCOPY VARCHAR2
23 );
24
25 /*Bug 13541195 : Auto Generation of change description not happening
26 Procedure to check if sgd generation is required */
27
28 PROCEDURE IS_SGD_GENERATION_REQUIRED(itemtype IN VARCHAR2,
29 itemkey IN VARCHAR2,
30 actid IN NUMBER,
31 funcmode IN VARCHAR2,
32 resultout OUT NOCOPY VARCHAR2);
33
34 /*Bug 13541195 : Auto Generation of change description not happening
35 Procedure to check if lock for sgd generation is available */
36
37 PROCEDURE IS_LOCK_FOR_SGD_GEN_AVAILABLE(itemtype IN VARCHAR2,
38 itemkey IN VARCHAR2,
39 actid IN NUMBER,
40 funcmode IN VARCHAR2,
41 resultout OUT NOCOPY VARCHAR2);
42
43 /*Bug 13541195 : Auto Generation of change description not happening
44 Launches SGD concurrent program */
45
46 procedure LAUNCH_SGD_CONCURRENT_PROGRAM (itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout out NOCOPY varchar2 ) ;
51
52 /*Bug 13541195 : Auto Generation of change description not happening
53 releases MOD_SYNC lock when sgd generation is completed*/
54 PROCEDURE RELEASE_SYNC_SGD_LOCK (itemtype IN VARCHAR2,
55 itemkey IN VARCHAR2,
56 actid IN NUMBER,
57 funcmode IN VARCHAR2,
58 resultout OUT NOCOPY VARCHAR2) ;
59
60 /*Bug 13541195 : Auto Generation of change description not happening
61 Acquires MOD_SYNC lock for sgd generation */
62 PROCEDURE ACQUIRE_SYNC_SGD_LOCK (itemtype IN VARCHAR2,
63 itemkey IN VARCHAR2,
64 actid IN NUMBER,
65 funcmode IN VARCHAR2,
66 resultout OUT NOCOPY VARCHAR2) ;
67
68
69 END PO_MOD_SYNC_PROCESS_PVT;
[Home] [Help]