PACKAGE: APPS.PO_COMM_FPDSNG_PVT

Source

1 PACKAGE PO_COMM_FPDSNG_PVT AS
2 /* $Header: POXFPDSNGS.pls 120.3 2008/01/08 12:51:20 lgoyal noship $ */
3 
4 ----------------------------------------------------
5 PROCEDURE SUBMIT_REQUEST(itemtype	IN VARCHAR2,
6 						itemkey		IN VARCHAR2,
7 						actid		IN NUMBER,
8 						funcmode	IN VARCHAR2,
9 						resultout	OUT NOCOPY VARCHAR2);
10 
11 ----------------------------------------------------
12 FUNCTION START_PROCESS( p_document_id NUMBER,
13 						p_release_num NUMBER,
14 						p_revision_num NUMBER)
15 RETURN CLOB;
16 
17 ----------------------------------------------------
18 FUNCTION FPDSNGXMLGEN(	p_document_id NUMBER,
19 						p_release_num NUMBER,
20 						p_revision_num NUMBER)
21 RETURN clob;
22 
23 ----------------------------------------------------
24 FUNCTION getFPDSNGFileName(	p_document_type varchar2,
25 							p_orgid number,
26 							p_document_id varchar2,
27 							p_revision_num number,
28 							p_release_num number,
29 							p_language_code varchar2)
30 RETURN varchar2;
31 
32 ----------------------------------------------------
33 PROCEDURE Store_Blob(	p_document_id		IN number,
34 						p_revision_number	IN number ,
35 						p_document_type		IN varchar2,
36 						p_file_name			IN varchar2,
37 						p_result			IN BLOB,
38 						p_media_id			OUT NOCOPY number);
39 
40 ----------------------------------------------------
41 FUNCTION clob_to_blob(p_ClobData IN CLOB )
42 RETURN BLOB;
43 
44 ----------------------------------------------------
45 FUNCTION blob_to_clob (p_BlobData IN BLOB)
46 RETURN CLOB;
47 
48 ----------------------------------------------------
49 FUNCTION getDocumentId RETURN NUMBER;
50 
51 ----------------------------------------------------
52 FUNCTION getReleaseId RETURN NUMBER;
53 
54 ----------------------------------------------------
55 FUNCTION getRevisionNum RETURN NUMBER;
56 
57 ----------------------------------------------------
58 FUNCTION Replace_Clob_String (
59 	p_ClobData IN CLOB,
60 	p_str_to_replace IN VARCHAR2,
61 	p_replace_with IN VARCHAR2)
62 RETURN CLOB;
63 
64 ----------------------------------------------------
65 PROCEDURE Communicate(	p_document_id IN NUMBER,
66 						p_revision_number IN VARCHAR2,
67 						p_document_type  IN VARCHAR2,
68 						p_request_id OUT NOCOPY NUMBER);
69 
70 
71 END PO_COMM_FPDSNG_PVT;