1 PACKAGE GMO_CBR_GRP AS
2 /* $Header: GMOGCBRS.pls 120.2 2006/06/13 22:10:34 srpuri noship $ */
3
4 /**********************************************************************************
5 ** This Procedure is to concurrent request to enable control batch recording.
6 **
7 ** OUT Parameter
8 ** Concurrent Program default parameters
9 ** RETCODE
10 ** ERRBUF
11 **
12 ***********************************************************************************/
13
14 PROCEDURE ENABLE_CBR (ERRBUF OUT NOCOPY VARCHAR2,RETCODE OUT NOCOPY VARCHAR2);
15
16 /**********************************************************************************
17 ** This Procedure is to update batch progression row with event date and new status
18 **
19 ** IN Parameters:
20 ** P_ERECORD_ID number -- E-record ID
21 ** P_BATCH_PROGRESSION_ID number -- Batch Progression ID
22 ** P_EVENT_DATE DATE -- Event Date
23 ** P_STATUS VARCHAR2 -- Event Status
24 **
25 ***********************************************************************************/
26
27 PROCEDURE UPDATE_EVENT (P_ERECORD_ID NUMBER, P_BATCH_PROGRESSION_ID NUMBER,P_EVENT_DATE DATE, P_STATUS VARCHAR2 );
28
29 /**********************************************************************************
30 ** This Procedure is to process event in CBR Subscriptions
31 **
32 ** IN Parameters:
33 ** P_SUBSCRIPTION_GUID Subscription GUID
34 ** P_EVENT Workflow Event Object
35 ***********************************************************************************/
36
37 FUNCTION PROCESS_EVENT (P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2;
38
39 /**********************************************************************************
40 ** This Procedure is to insert new batch progression row
41 **
42 ** IN Parameters:
43 ** P_BATCH_PROG_REC GMO_BATCH_PROGRESSION Row Type
44 ** P_BATCH_PROGRESSION_ID NUMBER
45 ***********************************************************************************/
46
47 PROCEDURE INSERT_EVENT(P_BATCH_PROG_REC GMO_BATCH_PROGRESSION%ROWTYPE, P_BATCH_PROGRESSION_ID OUT NOCOPY NUMBER);
48
49 /**********************************************************************************
50 ** This Procedure is to process batch progression rows before CBR XML generation.
51 **
52 ** IN Parameters:
53 ** p_BATCH_ID number -- Batch ID
54 ***********************************************************************************/
55
56 PROCEDURE CBR_PREPROCESS (P_BATCH_ID IN NUMBER);
57
58 /**********************************************************************************
59 ** This Procedure is to insert default batch progression rows when batch is
60 ** created.
61 ** IN Parameters:
62 ** p_BATCH_ID number -- Batch ID
63 ***********************************************************************************/
64
65 PROCEDURE INSERT_BATH_EVENTS(P_BATCH_ID IN NUMBER);
66 /**********************************************************************************
67 ** This Procedure is to process Instruction Set event in CBR Subscriptions
68 ** IN Parameters:
69 ** P_SUBSCRIPTION_GUID Subscription GUID
70 ** P_EVENT Workflow Event Object
71 ***********************************************************************************/
72
73 FUNCTION PROCESS_INSTANCE_INSTR_SET(P_SUBSCRIPTION_GUID IN RAW, P_EVENT IN OUT NOCOPY WF_EVENT_T) RETURN VARCHAR2;
74
75 /**********************************************************************************
76 ** This Procedure is to delete batch progression row
77 ** Usage:
78 ** 1. Send BATCH_PROGRESSION_ID alone deletes progression row with the given
79 ** Batch Progression Row Identifier
80 ** 2. You send ERECORD_ID alone deletes progression row with the given ERecord_ID
81 ** 3. Send Evnet and Evnet Key. Deletes all batch progression rows for the
82 ** given event and event Key.
83 **
84 ** NOTE: If Batch Progression id is passed then other parameters will be ignored
85 ** If Batch Progression id is null and if ERecordID passed then
86 ** Event information will be ignored
87 ** If Both Batch Progression id and E-Record ID are null then Event information
88 ** is used for deletion.
89 **
90 ** IN Parameters:
91 ** P_ERECORD_ID number -- E-record ID
92 ** P_BATCH_PROGRESSION_ID number -- Batch Progression ID
93 ** P_EVENT VARCHAR2 -- Event
94 ** P_EVENT_KEY VARCHAR2 -- Event Key
95 ** OUT Parameters:
96 ** X_RETURN_STATUS VARCHAR2 -- Deletion Status
97 ** x_msg_count number
98 ** x_msg_data varchar2
99 ***********************************************************************************/
100
101 PROCEDURE DELETE_PROGRESSION_ROW (P_BATCH_PROGRESSION_ID NUMBER DEFAULT Null,
102 P_ERECORD_ID NUMBER DEFAULT Null,
103 P_EVENT VARCHAR2 DEFAULT Null,
104 P_EVENT_KEY VARCHAR2 DEFAULT Null,
105 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
106 X_MSG_COUNT OUT NOCOPY NUMBER,
107 X_MSG_DATA OUT NOCOPY VARCHAR2);
108
109
110
111
112
113 END GMO_CBR_GRP;