1 PACKAGE PO_DOC_MANAGER_PUB AUTHID CURRENT_USER as
2 /* $Header: POXWAPIS.pls 115.4 2002/11/23 01:20:22 sbull ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: PO_DOC_MANAGER_PUB
6
7 DESCRIPTION: Contains the record type to be used for calls
8 between the workflow engine and the doc manager.
9 Defines the procedure that will call the doc manager
10
11
12 CLIENT/SERVER: Server
13
14 LIBRARY NAME NONE
15
16 OWNER: Raj Bhakta
17
18 PROCEDURES/FUNCTIONS: CALL_DOC_MANAGER
19
20 ============================================================================*/
21
22 -- Defining the record type to be used
23 -- The definitions of what each component of the record
24 -- does is in POXDORAS.pls
25
26 TYPE DM_CALL_REC_TYPE IS RECORD
27 (
28 Action VARCHAR2(60),
29 Document_Type VARCHAR2(25),
30 Document_Subtype VARCHAR2(25),
31 Document_Id NUMBER,
32 Line_Id NUMBER,
33 Shipment_Id NUMBER,
34 Distribution_Id NUMBER,
35 Employee_id NUMBER ,
36 New_Document_Status VARCHAR2(25),
37 Offline_Code VARCHAR2(1),
38 --<UTF-8 FPI START>
39 --Note VARCHAR2(480),
40 Note PO_ACTION_HISTORY.NOTE%TYPE,
41 --<UTF-8 FPI END>
42 Approval_Path_Id NUMBER,
43 Forward_To_Id NUMBER,
44 Action_date Date,
45 Override_funds VARCHAR2(1),
46 Info_Request VARCHAR2(25),
47 Document_Status VARCHAR2(240),
48 Online_Report_Id NUMBER,
49 Return_Code VARCHAR2(25),
50 Error_Msg VARCHAR2(2000),
51 Return_Value NUMBER);
52
53 /*===========================================================================
54 PROCEDURE NAME: CALL_DOC_MANAGER()
55
56 DESCRIPTION: Accepts a record as input and calls
57 po_document_actions_sv.po_request_action which in turn
58 calls the Document Manager using dbms_pipe
59
60 PARAMETERS: X_DM_CALL_REC IN OUT PO_DOC_MANAGER_PUB.DM_CALL_REC_TYPE
61
62 DESIGN REFERENCES:
63
64 ALGORITHM:
65
66 NOTES:
67
68 OPEN ISSUES:
69
70 CLOSED ISSUES:
71
72 CHANGE HISTORY: Raj Bhakta 06/18/97 Created
73 ===========================================================================*/
74
75 PROCEDURE CALL_DOC_MANAGER(X_DM_CALL_REC IN OUT NOCOPY PO_DOC_MANAGER_PUB.DM_CALL_REC_TYPE);
76
77 END PO_DOC_MANAGER_PUB;
78