1 PACKAGE WSH_ITM_OVERRIDE AUTHID CURRENT_USER as
2 /* $Header: WSHITOVS.pls 115.7 2003/11/06 04:43:49 shravisa ship $ */
3 --
4 -- Package: WSH_ITM_OVERRIDE
5 --
6 -- Purpose: To Override the errors encountered during the Adapter Processing.
7 --
8 --
9 -- PRIVATE FUNCTIONS
10 --
11
12 --
13 -- Name
14 --
15 -- ITM_Launch_Override
16 --
17 -- Purpose
18 -- This procedure selects all the eligible records from the tables
19 -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
20 -- and WSH_ITM_RESPONSE_LINES for Override.
21 --
22 -- For every record, it first updates the process_flag in the table
23 -- WSH_ITM_REQUEST_CONTROL to 3, meaning OVERRIDE and calls Application
24 -- specific custom procedure.
25 --
26 -- Arguments
27 -- ERRBUF Required by Concurrent Processing.
28 -- RETCODE Required by Concurrent Processing.
29 -- P_APPLICATION_ID Application ID
30 -- P_OVERRIDE_TYPE Denotes SYSTEM/DATA/UNPROCESSED
31 -- P_ERROR_TYPE Values for Error Type
32 -- P_ERROR_CODE Values for Error Code.
33 -- P_PREFERENCE_ID Reference Number for Integrating Application
34 -- Ex: Order Number for OM.
35 -- P_REFERENCE_LINE_ID Reference Line for Integrating Application
36 -- Ex : Order Line Number for OM.
37 -- P_VENDOR_ID Value for Vendor ID.
38 -- P_PARTY_TYPE Value for Party Type
39 -- P_PARTY_ID Value for Party ID
40 --
41 -- Returns [ for functions ]
42 --
43 -- Notes
44 --
45
46 PROCEDURE ITM_Launch_Override
47 (
48 errbuf OUT NOCOPY VARCHAR2 ,
49 retcode OUT NOCOPY NUMBER ,
50 p_application_id IN NUMBER ,
51 p_override_type IN VARCHAR2 DEFAULT NULL,
52 p_reference_id IN NUMBER DEFAULT NULL,
53 p_dummy IN NUMBER DEFAULT NULL,
54 p_reference_line_id IN NUMBER DEFAULT NULL,
55 p_error_type IN VARCHAR2 DEFAULT NULL,
56 p_error_code IN VARCHAR2 DEFAULT NULL,
57 p_vendor_id IN NUMBER DEFAULT NULL,
58 p_party_type IN VARCHAR2 DEFAULT NULL,
59 p_party_id IN number DEFAULT NULL
60 );
61
62
63 PROCEDURE Call_Custom_API
64 (
65 p_request_control_id IN NUMBER DEFAULT NULL,
66 p_request_set_id IN NUMBER DEFAULT NULL,
67 p_appl_id IN NUMBER,
68 x_return_status OUT NOCOPY VARCHAR2
69 );
70
71 END WSH_ITM_OVERRIDE;