[Home] [Help]
PACKAGE: APPS.JTF_AM_FILTER_RESOURCE_PVT
Source
1 PACKAGE JTF_AM_FILTER_RESOURCE_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfamvss.pls 115.1 2003/10/10 21:22:27 sroychou ship $ */
3
4 /* Package variables */
5
6 G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_AM_FILTER_RESOURCE_PVT';
7
8
9 TYPE skill_param_rec IS RECORD
10 (
11 DOCUMENT_TYPE VARCHAR2(30) := NULL,
12 product_id NUMBER := NULL,
13 product_org_id NUMBER := NULL,
14 category_id NUMBER := NULL,
15 problem_code VARCHAR2(30) := NULL,
16 component_id NUMBER := NULL
17 );
18
19 TYPE skill_param_tbl_type IS TABLE OF skill_param_rec
20 INDEX BY BINARY_INTEGER;
21
22 TYPE SR_REC_TYPE IS RECORD (
23 INCIDENT_ID NUMBER,
24 INCIDENT_TYPE_ID NUMBER );
25
26
27 TYPE RESOURCE_REC_TYPE IS RECORD (
28 RESOURCE_ID NUMBER,
29 RESOURCE_TYPE VARCHAR2(90) );
30
31 TYPE RESOURCE_TBL_TYPE IS TABLE OF RESOURCE_REC_TYPE
32 INDEX BY BINARY_INTEGER;
33
34 PROCEDURE SEARCH_SKILL
35 ( p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,
37 p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
38 x_assign_resources_tbl IN OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
39 p_skill_param_tbl IN JTF_AM_FILTER_RESOURCE_PVT.skill_param_tbl_type,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2);
43
44
45 PROCEDURE SERVICE_SECURITY_CHECK
46 ( p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.g_false,
48 p_commit IN VARCHAR2 DEFAULT FND_API.g_false,
49 x_assign_resources_tbl IN OUT NOCOPY JTF_ASSIGN_PUB.AssignResources_tbl_type,
50 p_sr_tbl IN JTF_AM_FILTER_RESOURCE_PVT.sr_rec_type,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55
56 END JTF_AM_FILTER_RESOURCE_PVT;