PACKAGE: APPS.CAC_SYNC_TASK_CATEGORY

Source

1 PACKAGE cac_sync_task_category AUTHID CURRENT_USER AS
2 /* $Header: cacvstys.pls 120.1 2005/07/02 02:21:47 appldev noship $ */
3 /*======================================================================+
4 |  Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5 |                            All rights reserved.                       |
6 +=======================================================================+
7 | FILENAME                                                              |
8 |          cacvstys.pls                                                 |
9 |                                                                       |
10 | DESCRIPTION                                                           |
11 |          This package is for task categories.                         |
12 |                                                                       |
13 | NOTES                                                                 |
14 |                                                                       |
15 |                                                                       |
16 | Date          Developer        Change                                 |
17 | ------        ---------------  -------------------------------------- |
18 | 12-Nov-2004   sachoudh         created                                |
19 *=======================================================================*/
20 
21    FUNCTION get_category_id (
22       p_category_name   IN  VARCHAR2,
23       p_profile_id      IN  NUMBER
24    ) RETURN NUMBER;
25 
26    PROCEDURE create_category (
27          p_category_name      IN OUT NOCOPY VARCHAR2,
28          p_resource_id        IN     NUMBER
29       );
30 
31    FUNCTION get_profile_id (
32       p_resource_id   IN  NUMBER
33    ) RETURN NUMBER;
34 
35 
36 END cac_sync_task_category;   -- Package spec