1 PACKAGE OKS_IMPORT_REPORT AUTHID CURRENT_USER AS
2 -- $Header: OKSPKIMPRPTS.pls 120.0 2007/08/29 14:14:43 vmutyala noship $
3 --+=======================================================================+
4 --| Copyright (c) 2003 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| OKSPKIMPRPTS.pls Created By Vamshi Mutyala |
10 --| |
11 --| DESCRIPTION |
12 --| Service Contracts Import Statistics and Error Report Package |
13 --| |
14 --+========================================================================
15 --=========================
16 -- GLOBALS
17 --=========================
18
19 G_NO_DATA_FOUND_EXC EXCEPTION;
20 --=========================
21 -- PROCEDURES AND FUNCTIONS
22 --=========================
23 --========================================================================
24 -- PROCEDURE : Process_Error_Reporting PUBLIC
25 -- PARAMETERS: X_errbuf out Error message buffer
26 -- X_retcode out Return status code
27 -- P_batch_id IN Batch Id
28 -- P_parent_request_id IN Import Process Request Id
29 -- P_mode IN Validate Only, Import flag
30 -- P_Num_Workers IN Number of workers
31 -- P_commit_size IN Work unit size
32 -- COMMENT : This procedure will report statistics and errors if any in
33 -- output for a batch processed by a parent Import request.
34 --=========================================================================
35
36 PROCEDURE Process_Error_Reporting(X_errbuf OUT NOCOPY VARCHAR2,
37 X_retcode OUT NOCOPY VARCHAR2,
38 P_batch_id IN VARCHAR2,
39 P_parent_request_id IN NUMBER,
40 P_mode IN VARCHAR2,
41 P_Num_Workers IN NUMBER,
42 P_commit_size IN NUMBER);
43 END OKS_IMPORT_REPORT;