1 PACKAGE WSH_ITM_UTIL AUTHID CURRENT_USER AS
2 /* $Header: WSHUTITS.pls 120.0.12010000.3 2009/09/23 12:39:00 gbhargav ship $*/
3 -- Package
4 -- WSH_ITM_UTIL
5 --
6 -- Purpose
7 -- Spec of package WSH_ITM_UTIL. This package is used to determine the
8 -- services defined for a Master Organization,their additional country
9 -- codes and supports combination flag.
10 -- History
11 --
12 --
13
14 TYPE CONTROL_ID_LIST IS TABLE OF NUMBER;
15
16 -- Name (RECORD TYPE )
17 -- Service_Rec_Type
18 -- Purpose
19 -- This record type stores three flags for dp, em and ld
20 -- indicating whether they are required for a combination of
21 -- appication Id and Master Organization.
22 -- The addl_country_code columns will store the country codes
23 -- against which the check for the particular service has to be
24 -- done additionally.
25
26
27 TYPE Service_Rec_Type IS RECORD (
28 service_type_code WSH_ITM_VENDOR_SERVICES.SERVICE_TYPE%TYPE,
29 addl_country_code varchar2(5));
30
31
32 TYPE Service_Tbl_Type IS TABLE OF Service_Rec_Type INDEX BY BINARY_INTEGER;
33
34 -- Name
35 -- GET_SERVICE_DETAILS
36 -- Purpose
37 -- On passing the p_application_id, p_master_organization_id and
38 -- p_organization_id this procedure returns the services defined for
39 -- user and the additional country codes for all the services.
40 -- Arguments
41 -- p_application_id p_application_id of a request
42 -- p_master_organization_id p_master_organization_id of a request
43 -- p_organization_id p_organization_id of a request
44 -- x_service_tbl service types and addl_country_codes
45 -- returned as a PLSQL table Service_Rec_Type
46 -- x_supports_combination_flag A flag indicating whether a combined
47 -- request for all the services returned
48 -- by x_service_types_rec is supported or
49 -- not.
50 -- x_return_status Return Status
51 -- Notes
52 -- Refer the record T_SERVICE_TYPES_REC
53
54
55 PROCEDURE GET_SERVICE_DETAILS (
56 p_application_id IN NUMBER,
57 p_master_organization_id IN NUMBER,
58 p_organization_id IN NUMBER,
59 x_service_tbl OUT NOCOPY Service_Tbl_Type,
60 x_supports_combination_flag OUT NOCOPY VARCHAR2,
61 x_return_status OUT NOCOPY VARCHAR2);
62
63
64 -- Name
65 -- UPDATE_PROCESS_FLAG
66 -- Purpose
67 -- To update the process_flag of a request.
68 -- Arguments
69 -- p_request_control_id p_request_control_id of a request
70 -- p_process_flag process_flag value
71 -- x_return_status Return Status
72
73 PROCEDURE UPDATE_PROCESS_FLAG (
74 p_control_id_list IN CONTROL_ID_LIST,
75 p_process_flag IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 -- Name
79 -- get vendor
80 -- Purpose
81 -- To get the Vendor name from the Request Control ID
82 -- Arguments
83 -- p_request_control_id p_request_control_id of a request
84 -- x_service_provider VendorName
85 PROCEDURE GET_SERVICE_PROVIDER(
86 p_request_control_id IN NUMBER,
87 x_service_provider OUT NOCOPY VARCHAR2);
88
89 --Added in Bug 8916313
90 --===================================================================================================
91 -- Start of comments
92 --
93 -- API Name : GET_COMPLIANCE_STATUS
94 -- Type : Public
95 -- Purpose : Called by OM to get the ITM request control compliance status.
96 -- Pre-reqs : None
97 -- Function : This API can be used to get the compliance status of the ITM request control lines
98 -- In case if multiple request lines are present this will only return the first record
99 -- found with the matching i/p criteria
100 --
101 -- PARAMETERS : p_appliciation_id i/p Appliciation id
102 -- p_original_sys_reference i/p Original system reference
103 -- p_original_sys_line_reference i/p Original system line reference
104 -- x_process_flag o/p compliance status.
105 -- x_request_control_id o/p request_control_id ,
106 -- x_request_set_id o/p request_set_id ,
107 -- x_return_status o/p return status
108 -- VERSION : current version 1.0
109 -- initial version 1.0
110 -- End of comments
111 --===================================================================================================
112
113 PROCEDURE GET_COMPLIANCE_STATUS ( p_appliciation_id IN NUMBER,
114 p_original_sys_reference IN NUMBER,
115 p_original_sys_line_reference IN NUMBER,
116 x_process_flag OUT NOCOPY NUMBER,
117 x_request_control_id OUT NOCOPY NUMBER,
118 x_request_set_id OUT NOCOPY NUMBER,
119 x_return_status OUT NOCOPY VARCHAR2);
120
121
122 END WSH_ITM_UTIL;