1 PACKAGE PO_SIGNATURE_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGSIGS.pls 115.2 2004/03/09 22:02:27 bao noship $ */
3
4 -- Read the profile option that enables/disables the debug log
5 g_fnd_debug CONSTANT VARCHAR2(1) :=
6 NVL (FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7
8 -- other
9 g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SIGNATURE_GRP';
10 g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.'||g_pkg_name||'.';
11
12
13 ---------------------------------------------------------------------------------
14 -- Updates the PO tables
15 ---------------------------------------------------------------------------------
16 PROCEDURE Update_Po_Details(p_api_version IN NUMBER, -- bug3488839
17 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18 p_po_header_id IN NUMBER,
19 p_status IN VARCHAR2,
20 p_action_code IN VARCHAR2,
21 p_object_type_code IN VARCHAR2,
22 p_object_subtype_code IN VARCHAR2,
23 p_employee_id IN NUMBER,
24 p_revision_num IN NUMBER,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2);
28
29 ---------------------------------------------------------------------------------
30 -- To create Item key for the Document Signature Process
31 ---------------------------------------------------------------------------------
32 PROCEDURE Get_Item_Key(p_api_version IN NUMBER, -- bug3488839
33 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34 p_po_header_id IN NUMBER,
35 p_revision_num IN NUMBER,
36 p_document_type IN VARCHAR2,
37 x_itemkey OUT NOCOPY VARCHAR2,
38 x_result OUT NOCOPY VARCHAR2,
39 x_return_status OUT NOCOPY VARCHAR2,
40 x_msg_count OUT NOCOPY NUMBER,
41 x_msg_data OUT NOCOPY VARCHAR2);
42
43 ---------------------------------------------------------------------------------
44 -- Returns item key of the active Document Signature Process
45 ---------------------------------------------------------------------------------
46 PROCEDURE Find_Item_Key(p_api_version IN NUMBER, -- bug3488839
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 p_po_header_id IN NUMBER,
49 p_revision_num IN NUMBER,
50 p_document_type IN VARCHAR2,
51 x_itemkey OUT NOCOPY VARCHAR2,
52 x_result OUT NOCOPY VARCHAR2,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2);
56
57 ---------------------------------------------------------------------------------
58 -- To Abort Document Signature Process after Signatures are completed
59 ---------------------------------------------------------------------------------
60 PROCEDURE Abort_Doc_Sign_Process(p_api_version IN NUMBER, -- bug3488839
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_itemkey IN VARCHAR2,
63 x_result OUT NOCOPY VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2);
67
68 ---------------------------------------------------------------------------------
69 -- To check if eRecords is installed and enabled or not
70 ---------------------------------------------------------------------------------
71 PROCEDURE Erecords_Enabled(p_api_version IN NUMBER, -- bug3488839
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 x_erecords_enabled OUT NOCOPY VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2);
77
78 END PO_SIGNATURE_GRP;