1 PACKAGE CSFW_SIGNATURE_PVT AUTHID CURRENT_USER as
2 /* $Header: csfwsigs.pls 115.1 2003/10/29 02:27:07 pgiri noship $ */
3 /*
4 --Start of Comments
5 Package name : CSFW_SIGNATURE_PVT
6 Purpose : to upload signature associated with Debrief
7 History :
8 NOTE : Please see the function details for additional information
9
10 UPDATE NOTES
11 | Date Developer Change
12 |------ --------------- --------------------------------------
13 08-06-2003 MMERCHAN Created
14
15
16 --End of Comments
17 */
18
19 /*
20 Procedure to insert signature, name and date to Server
21 p_description is composed of --l_signed_date||' '||l_signed_by,
22 */
23
24 PROCEDURE UPLOAD_SIGNATURE
25 (p_debrief_header_id NUMBER,
26 p_task_assignment_id NUMBER,
27 p_description VARCHAR2,
28 p_file_data BLOB,
29 p_error_msg OUT NOCOPY VARCHAR2,
30 x_return_status IN OUT NOCOPY VARCHAR2
31 );
32 END CSFW_SIGNATURE_PVT;