PACKAGE: APPS.JTF_TASK_SECURITY_PVT

Source

1 PACKAGE jtf_task_security_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtftktts.pls 115.13 2003/03/07 01:01:26 cjang ship $ */
3 
4   ----
5   -- Constants for Task Data Security
6   -- Added on August 1, 2002 by mmarovic
7   ----
8   TASK_OBJECT    CONSTANT VARCHAR2(30) := 'JTF_TASKS';
9 
10   READ_ROLE      CONSTANT VARCHAR2(30) := 'JTF_TASK_READ_ONLY';
11   FULL_ROLE      CONSTANT VARCHAR2(30) := 'JTF_TASK_FULL_ACCESS';
12 
13   READ_PRIVILEGE CONSTANT VARCHAR2(30) := 'JTF_TASK_READ_ONLY';
14   FULL_PRIVILEGE CONSTANT VARCHAR2(30) := 'JTF_TASK_FULL_ACCESS';
15 
16   RESOURCE_TASKS_SET    CONSTANT VARCHAR2(30) := 'JTF_TASK_RESOURCE_TASKS';
17 
18   ----
19   -- Creted on July 22, 2002 by mmarovic
20   -- This is a wrapper around FND function created to support Java API.
21   -- Please do not use it before ask Milan or Girish.
22   ----
23   PROCEDURE get_privileges (
24    p_api_version         IN  NUMBER,
25    p_object_name         IN  VARCHAR2,
26    p_instance_pk1_value  IN  VARCHAR2 DEFAULT NULL, -- NULL= only chk global gnts
27    p_instance_pk2_value  IN  VARCHAR2 DEFAULT NULL,
28    p_instance_pk3_value  IN  VARCHAR2 DEFAULT NULL,
29    p_instance_pk4_value  IN  VARCHAR2 DEFAULT NULL,
30    p_instance_pk5_value  IN  VARCHAR2 DEFAULT NULL,
31    p_user_name           IN  VARCHAR2 DEFAULT NULL,
32    x_return_status       OUT NOCOPY VARCHAR2,
33    x_privileges          OUT NOCOPY FND_TABLE_OF_VARCHAR2_30
34    );
35 
36    FUNCTION check_privelege_for_task (
37       p_task_id              NUMBER,
38       p_resource_id          NUMBER,
39       p_resource_type   IN   VARCHAR2
40       )
41       RETURN VARCHAR2;
42 
43    FUNCTION get_object_name (p_object_code IN VARCHAR2)
44       RETURN VARCHAR2;
45 
46    FUNCTION get_default_query (
47       profilename        IN   VARCHAR2,
48       p_parameter_name   IN   VARCHAR2
49       )
50       RETURN NUMBER;
51 
52    FUNCTION get_category_id (
53       p_task_id              IN   NUMBER,
54       p_resource_id          IN   NUMBER,
55       p_resource_type_code   IN   VARCHAR2
56       )
57       RETURN NUMBER;
58 
59    FUNCTION check_private_task_privelege (
60       p_task_id              IN   NUMBER,
61       p_resource_id          IN   NUMBER,
62       p_resource_type_code   IN   VARCHAR2
63       )
64       RETURN VARCHAR2;
65 
66    PROCEDURE delete_category (p_category_name IN VARCHAR2);
67 
68    FUNCTION priveleges_from_other_resource (
69       logged_in_resource              IN   NUMBER,
70       priveleges_from_resource_id     IN   NUMBER,
71       priveleges_from_resource_type   IN   VARCHAR2
72       )
73       RETURN VARCHAR2;
74 END;