1 PACKAGE Inv_Copy_Org_Report_Pub AUTHID CURRENT_USER AS
2 -- $Header: INVVCORS.pls 115.4 2002/05/16 14:40:58 pkm ship $
3
4 --+=======================================================================+
5 --| Copyright (c) 1998 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| INVVCORS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Specification of Inv_Copy_Org_Report |
14 --| |
15 --| HISTORY |
16 --| 10/02/2001 Vincent Chu Created |
17 --+======================================================================*/
18
19
20 /*
21 ** -------------------------------------------------------------------------
22 ** Procedure: purge_interface_data
23 ** Description: Purges the records in the copy organization interface
24 ** table that correspond to a particular group code
25 ** Output:
26 ** x_retcode
27 ** return status indicating success, error, unexpected error
28 ** x_errbuf
29 ** contains the message text, if there are any
30 **
31 ** Input:
32 ** p_group_code
33 ** the group code that corresponds to the records that are to
34 ** be purged from the interface table
35 ** purge_interface
36 ** purges the interface table only if this is set to 'Y'
37 ** --------------------------------------------------------------------------
38 */
39
40 PROCEDURE purge_interface_data( x_retcode OUT VARCHAR2
41 , x_errbuf OUT VARCHAR2
42 , p_group_code IN VARCHAR2
43 , purge_interface IN VARCHAR2
44 );
45
46 /*
47 ** -------------------------------------------------------------------------
48 ** Procedure: purge_reports_data
49 ** Description: Purges the records in the copy organization report
50 ** table that correspond to a particular group code
51 ** Output:
52 ** x_retcode
53 ** return status indicating success, error, unexpected error
54 ** x_errbuf
55 ** contains the message text, if there are any
56 **
57 ** Input:
58 ** p_group_code
59 ** the group code that corresponds to the records that are to
60 ** be purged from the report table
61 ** --------------------------------------------------------------------------
62 */
63
64 PROCEDURE purge_reports_data( x_retcode OUT VARCHAR2
65 , x_errbuf OUT VARCHAR2
66 , p_group_code IN VARCHAR2
67 );
68
69 /*
70 ** -------------------------------------------------------------------------
71 ** Function: clob_to_varchar
72 ** Description: Takes in a CLOB database object and returns the
73 ** corresponding VARCHAR2 object
74 ** Input:
75 ** lobsrc
76 ** The CLOB to be converted into a VARCHAR2 string
77 **
78 ** Returns:
79 ** The VARCHAR2 string that was converted from the passed in CLOB
80 ** --------------------------------------------------------------------------
81 */
82
83 FUNCTION clob_to_varchar ( lobsrc IN CLOB ) return VARCHAR2;
84
85 /*
86 ** -------------------------------------------------------------------------
87 ** Procedure: submit_report_conc_req
88 ** Description: Submits a request to run the copy organization report
89 ** request set, which generates a report and purges the
90 ** corresponding report table and interface table data
91 ** Input:
92 ** p_group_code
93 ** the group code that corresponds to particular run of
94 ** copy organization, for which a report is to be generated
95 ** purge_interface
96 ** purges the interface table only if this is set to 'Y'
97 ** Returns:
98 ** ID of the request that runs the report request set
99 ** --------------------------------------------------------------------------
100 */
101
102 FUNCTION submit_report_conc_req ( p_group_code IN VARCHAR2
103 , purge_interface IN VARCHAR2
104 )
105 RETURN NUMBER;
106
107 END Inv_Copy_Org_Report_Pub;