1 PACKAGE WSH_ITM_UTIL AUTHID CURRENT_USER AS
2 /* $Header: WSHUTITS.pls 115.3 2003/07/23 06:23:33 ajprabha 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 END WSH_ITM_UTIL;