1 PACKAGE PO_ERECORDS_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVEVRS.pls 115.1 2003/10/07 01:54:18 rbairraj noship $
3
4 /* -- Public Record Type Declaration */
5
6 TYPE params_rec IS RECORD (Param_Name VARCHAR2(80),
7 Param_Value VARCHAR2(4000),Param_displayname varchar2(240));
8
9 TYPE Params_tbl_type IS TABLE of PO_ERECORDS_PVT.params_rec INDEX by Binary_INTEGER;
10
11 -- Calls the APIs given by eRecords product team to store the signature details
12 PROCEDURE CAPTURE_SIGNATURE (
13 p_api_version IN NUMBER,
14 p_init_msg_list IN VARCHAR2,
15 p_commit IN VARCHAR2,
16 p_psig_xml IN CLOB,
17 p_psig_document IN CLOB,
18 p_psig_docFormat IN VARCHAR2,
19 p_psig_requester IN VARCHAR2,
20 p_psig_source IN VARCHAR2,
21 p_event_name IN VARCHAR2,
22 p_event_key IN VARCHAR2,
23 p_wf_notif_id IN NUMBER,
24 p_doc_parameters_tbl IN Params_tbl_type,
25 p_user_name IN VARCHAR2,
26 p_original_recipient IN VARCHAR2,
27 p_overriding_comment IN VARCHAR2,
28 p_evidenceStore_id IN NUMBER,
29 p_user_response IN VARCHAR2,
30 p_sig_parameters_tbl IN Params_tbl_type,
31 x_document_id OUT NOCOPY NUMBER,
32 x_signature_id OUT NOCOPY NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2);
36
37
38 -- Creates an acknowledgement for an erecord in the
39 -- evidence store. This acknowledgement would say whether
40 -- the business transaction for which the erecord was
41 -- created, completed successfully or not.
42
43 PROCEDURE SEND_ACKN
44 ( p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
46 p_event_name IN VARCHAR2,
47 p_event_key IN VARCHAR2,
48 p_erecord_id IN NUMBER,
49 p_trans_status IN VARCHAR2,
50 p_ackn_by IN VARCHAR2 DEFAULT NULL,
51 p_ackn_note IN VARCHAR2 DEFAULT NULL,
52 p_autonomous_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2);
56
57 -- If eRecords patch is applied and Erecords is enabled
58 -- returns 'Y' else returns 'N'
59
60 PROCEDURE ERECORDS_ENABLED
61 (x_erecords_enabled OUT NOCOPY VARCHAR2);
62
63 END PO_ERECORDS_PVT;