1 PACKAGE WSH_ITM_RESUBMIT AUTHID CURRENT_USER as
2 /* $Header: WSHITRSS.pls 115.8 2003/11/05 07:29:50 shravisa ship $ */
3 --
4 -- Package: WSH_ITM_RESUBMIT
5 --
6 -- Purpose: To Override the errors encountered during the Adapter Processing.
7 --
8 --
9 -- PRIVATE FUNCTIONS
10 --
11
12 --
13 -- Name
14 -- Resubmit_Requests
15 -- Purpose
16 -- This procedure selects all the eligible records from the tables
17 -- WSH_ITM_REQUEST_CONTROL, WSH_ITM_RESPONSE_HEADERS
18 -- and WSH_ITM_RESPONSE_LINES for Resubmit.
19 -- For every record, it first updates the process_flag in the table
20 -- WSH_ITM_REQUEST_CONTROL to 0, meaning RESUBMIT and calls the
21 -- Application specific API to update the workflow.
22 --
23 -- Arguments
24 -- ERRBUF Required by Concurrent Processing.
25 -- RETCODE Required by Concurrent Processing.
26 -- P_APPLICATION_ID Application ID
27 -- P_RESUBMIT_TYPE Denotes SYSTEM/DATA
28 -- P_ERROR_TYPE Values for Error Type
29 -- P_ERROR_CODE Values for Error Code.
30 -- P_PREFERENCE_ID Reference Number for Integrating Application
31 -- Ex: Order Number for OM.
32 -- P_REFERENCE_LINE_ID Reference Line for Integrating Application
33 -- Ex : Order Line Number for OM.
34 -- P_VENDOR_ID Value for Vendor ID.
35 -- P_PARTY_TYPE Value for Party Type
36 -- P_PARTY_ID Value for Party ID
37 --
38 -- Returns [ for functions ]
39 --
40 -- Notes
41 --
42
43 PROCEDURE ITM_Resubmit_Requests
44 (
45 errbuf OUT NOCOPY VARCHAR2,
46 retcode OUT NOCOPY NUMBER,
47 p_application_id IN NUMBER,
48 p_resubmit_type IN VARCHAR2 DEFAULT NULL,
49 p_dummy IN NUMBER DEFAULT NULL,
50 p_reference_id IN NUMBER DEFAULT NULL,
51 p_error_type IN VARCHAR2 DEFAULT NULL,
52 p_error_code IN VARCHAR2 DEFAULT NULL,
53 p_vendor_id IN NUMBER DEFAULT NULL,
54 p_reference_line_id IN NUMBER DEFAULT NULL,
55 p_party_type IN VARCHAR2 DEFAULT NULL,
56 p_party_id IN NUMBER DEFAULT NULL
57 );
58
59 END WSH_ITM_RESUBMIT;