PACKAGE: APPS.CS_SR_RES_CODE_MAPPING_PKG

Source

1 package CS_SR_RES_CODE_MAPPING_PKG as
2 /* $Header: csxrscds.pls 120.0 2005/12/12 16:10:26 smisra noship $ */
3 
4 TYPE rescode_search_rec IS RECORD (
5    service_request_type_id NUMBER,
6    inventory_item_id NUMBER,
7    organization_id NUMBER,
8    product_category_id NUMBER,
9    problem_code VARCHAR2(30)
10  );
11 
12 PROCEDURE VALIDATE_RESOLUTION_CODE
13 ( p_api_version   	IN 	NUMBER,
14   p_init_msg_list 	IN 	VARCHAR2,
15   p_rescode_criteria_rec  IN CS_SR_RES_CODE_MAPPING_PKG.rescode_search_rec,
16   p_resolution_code   IN  VARCHAR2,
17   x_return_status  OUT NOCOPY    VARCHAR2,
18   x_msg_count      OUT NOCOPY     NUMBER,
19   x_msg_data       OUT NOCOPY    VARCHAR2
20 );
21 
22 
23 
24 TYPE rescode_map_criteria_rec IS RECORD (
25     resolution_map_id NUMBER,
26     service_request_type_id NUMBER,
27     inventory_item_id NUMBER,
28     organization_id NUMBER,
29     product_category_id NUMBER,
30     problem_code varchar2(30),
31     start_date_active DATE,
32     end_date_active DATE
33 );
34 
35 TYPE resolution_codes_rec IS RECORD (
36         resolution_map_detail_id NUMBER,
37         resolution_code varchar2(30),
38         resolution_code_meaning varchar2(80),
39         start_date_active DATE,
40         end_date_active DATE
41 );
42 
43 TYPE resolution_codes_tbl_type IS TABLE OF resolution_codes_rec INDEX BY BINARY_INTEGER;
44 
45 
46 PROCEDURE CREATE_MAPPING_RULES
47 ( p_api_version			  IN         NUMBER,
48   p_init_msg_list		  IN         VARCHAR2 	:= FND_API.G_FALSE,
49   p_commit			      IN         VARCHAR2 	:= FND_API.G_FALSE,
50   p_rescode_map_criteria_rec IN rescode_map_criteria_rec,
51   p_resolution_codes_tbl        IN resolution_codes_tbl_type,
52   x_return_status		  OUT NOCOPY VARCHAR2,
53   x_msg_count			  OUT NOCOPY NUMBER,
54   x_msg_data			  OUT NOCOPY VARCHAR2,
55   x_resolution_map_id        OUT NOCOPY NUMBER
56 );
57 
58 PROCEDURE UPDATE_MAPPING_RULES
59 ( p_api_version			  IN         NUMBER,
60   p_init_msg_list		  IN         VARCHAR2 	:= FND_API.G_FALSE,
61   p_commit			      IN         VARCHAR2 	:= FND_API.G_FALSE,
62   p_rescode_map_criteria_rec  IN rescode_map_criteria_rec,
63   p_resolution_codes_tbl         IN resolution_codes_tbl_type,
64   x_return_status		  OUT NOCOPY VARCHAR2,
65   x_msg_count			  OUT NOCOPY NUMBER,
66   x_msg_data			  OUT NOCOPY VARCHAR2
67 );
68 
69 PROCEDURE PROPAGATE_MAP_CRITERIA_DATES
70 ( p_api_version			  IN         NUMBER,
71   p_init_msg_list		  IN         VARCHAR2 	:= FND_API.G_FALSE,
72   x_return_status		  OUT NOCOPY VARCHAR2,
73   x_msg_count			  OUT NOCOPY NUMBER,
74   x_msg_data			  OUT NOCOPY VARCHAR2
75 ) ;
76 
77 
78 END; -- Package Specification CS_SR_RES_CODE_MAPPING_PKG