PACKAGE: APPS.CS_SR_PROB_CODE_MAPPING_PKG

Source

1 package CS_SR_PROB_CODE_MAPPING_PKG as
2 /* $Header: csxpbcds.pls 120.0 2005/12/12 16:14:21 smisra noship $ */
3 
4 TYPE probcode_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  );
10 
11 PROCEDURE VALIDATE_PROBLEM_CODE
12 ( p_api_version   	IN 	NUMBER,
13    p_init_msg_list 	IN 	VARCHAR2,
14    p_probcode_criteria_rec  IN CS_SR_PROB_CODE_MAPPING_PKG.probcode_search_rec,
15    p_problem_code   IN  VARCHAR2,
16    x_return_status  OUT NOCOPY    VARCHAR2,
17    x_msg_count      OUT NOCOPY     NUMBER,
18    x_msg_data       OUT NOCOPY    VARCHAR2
19 );
20 
21 
22 
23 
24 TYPE probcode_map_criteria_rec IS RECORD (
25     problem_map_id NUMBER,
26     service_request_type_id NUMBER,
27     inventory_item_id NUMBER,
28     organization_id NUMBER,
29     product_category_id NUMBER,
30     start_date_active DATE,
31     end_date_active DATE
32 );
33 
34 TYPE problem_codes_rec IS RECORD (
35         problem_map_detail_id NUMBER,
36         problem_code varchar2(30),
37         problem_code_meaning varchar2(80),
38         start_date_active DATE,
39         end_date_active DATE
40 );
41 
42 TYPE problem_codes_tbl_type IS TABLE OF problem_codes_rec INDEX BY BINARY_INTEGER;
43 
44 PROCEDURE CREATE_MAPPING_RULES
45 ( p_api_version			  IN         NUMBER,
46   p_init_msg_list		  IN         VARCHAR2 	:= FND_API.G_FALSE,
47   p_commit			      IN         VARCHAR2 	:= FND_API.G_FALSE,
48   p_probcode_map_criteria_rec IN probcode_map_criteria_rec,
49   p_problem_codes_tbl       IN problem_codes_tbl_type,
50   x_return_status		  OUT NOCOPY VARCHAR2,
51   x_msg_count			  OUT NOCOPY NUMBER,
52   x_msg_data			  OUT NOCOPY VARCHAR2,
53   x_problem_map_id        OUT NOCOPY NUMBER
54 );
55 
56 PROCEDURE UPDATE_MAPPING_RULES
57 ( p_api_version			  IN         NUMBER,
58   p_init_msg_list		  IN         VARCHAR2 	:= FND_API.G_FALSE,
59   p_commit			      IN         VARCHAR2 	:= FND_API.G_FALSE,
60   p_probcode_map_criteria_rec IN probcode_map_criteria_rec,
61   p_problem_codes_tbl       IN  problem_codes_tbl_type,
62   x_return_status		  OUT NOCOPY VARCHAR2,
63   x_msg_count			  OUT NOCOPY NUMBER,
64   x_msg_data			  OUT NOCOPY VARCHAR2
65 );
66 
67 PROCEDURE PROPAGATE_MAP_CRITERIA_DATES
68 ( p_api_version			  IN         NUMBER,
69   p_init_msg_list		  IN         VARCHAR2 	:= FND_API.G_FALSE,
70   x_return_status		  OUT NOCOPY VARCHAR2,
71   x_msg_count			  OUT NOCOPY NUMBER,
72   x_msg_data			  OUT NOCOPY VARCHAR2
73 );
74 
75 END; -- Package Specification CS_SR_PROB_CODE_MAPPING_PKG