1 PACKAGE EDR_ISIGN_CHECKLIST_PVT AS
2 /* $Header: EDRVISCS.pls 120.0.12000000.1 2007/01/18 05:56:24 appldev ship $ */
3
4 -- --------------------------------------
5 -- API name : IS_CHECKLIST_REQUIRED
6 -- Type : Private
7 -- Pre-reqs : None
8 -- procedue : return Y/N based on checklsit steup and if Y, returns checlist name and checklist version
9 -- Parameters
10 -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
11 -- p_event_key VARCHAR2 event key, eg ItemNo3125
12 -- OUT : x_isRequired_checklist VARCHAR2 Checklist status
13 -- OUT : x_checklist_name VARCHAR2 Checklist Name
14 -- OUT : x_checklist_ver VARCHAR2 Checklist Version
15
16 -- ---------------------------------------
17
18
19 PROCEDURE IS_CHECKLIST_REQUIRED (
20 p_event_name IN varchar2,
21 p_event_key IN varchar2,
22 x_isRequired_checklist OUT NOCOPY VARCHAR2,
23 x_checklist_name OUT NOCOPY VARCHAR2,
24 x_checklist_ver OUT NOCOPY VARCHAR2);
25
26 -- --------------------------------------
27 -- API name : IS_CHECKLIST_PRESENT
28 -- Type : Private
29 -- Pre-reqs : None
30 -- procedue : Procedure will notify if checklist is availalb for a given file_id
31 -- Parameters
32 -- IN : p_file_id NUMBER file_id of iSign
33 -- OUT : x_checklist_status VARCHAR2 Checklist Status
34 -- Y - Checklist Present
35 -- N - Checklist not avalable
36 -- ---------------------------------------
37
38
39 PROCEDURE IS_CHECKLIST_PRESENT (
40 p_file_id IN NUMBER,
41 x_checklist_Status OUT NOCOPY VARCHAR2);
42
43
44 -- --------------------------------------
45 -- API name : ATTACH_CHECKLIST
46 -- Type : Public
47 -- Pre-reqs : None
48 -- procedue : Procedure to Attach checklist to evidence store entity if available
49 -- Parameters
50 -- IN : p_file_id NUMBER file_id of iSign
51 -- OUT : x_return_status VARCHAR2 Attachment Status
52 -- S - Successful
53 -- E - Error
54 -- ---------------------------------------
55
56
57 PROCEDURE ATTACH_CHECKLIST (
58 p_file_id IN NUMBER,
59 x_return_Status OUT NOCOPY VARCHAR2);
60
61
62 -- --------------------------------------
63 -- API name : DELETE_CHECKLIST
64 -- Type : Public
65 -- Pre-reqs : None
66 -- procedue : Procedure to delete checklist attachemtn for a given iSign File
67 -- Parameters
68 -- IN : p_file_id NUMBER file_id of iSign
69 -- OUT : x_return_status VARCHAR2 Delete Status
70 -- S - Successful
71 -- E - Error
72 -- ---------------------------------------
73
74
75 PROCEDURE DELETE_CHECKLIST (
76 p_file_id IN NUMBER,
77 x_return_Status OUT NOCOPY VARCHAR2);
78
79
80
81 END EDR_ISIGN_CHECKLIST_PVT;
82