[Home] [Help]
PACKAGE: APPS.PA_CI_TYPE_USAGE_PUB
Source
1 PACKAGE pa_ci_type_usage_pub AS
2 /* $Header: PACITUPS.pls 120.1 2005/08/19 16:18:51 mwasowic noship $ */
3
4 PROCEDURE create_ci_type_usage (
5 p_api_version IN NUMBER := 1.0,
6 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
7 p_commit IN VARCHAR2 := FND_API.g_false,
8 p_validate_only IN VARCHAR2 := FND_API.g_true,
9 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
10 p_project_type IN VARCHAR2 := NULL,
11 p_project_type_id IN NUMBER := NULL,
12 p_ci_type_name IN VARCHAR2 := NULL,
13 p_ci_type_id IN NUMBER := NULL,
14 p_created_by IN NUMBER DEFAULT fnd_global.user_id,
15 p_creation_date IN DATE DEFAULT SYSDATE,
16 p_last_update_login IN NUMBER DEFAULT fnd_global.login_id,
17 x_ci_type_usage_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
19 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
20 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
21 );
22
23 PROCEDURE update_ci_type_usage (
24 p_api_version IN NUMBER := 1.0,
25 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26 p_commit IN VARCHAR2 := FND_API.g_false,
27 p_validate_only IN VARCHAR2 := FND_API.g_true,
28 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29 p_ci_type_usage_id IN NUMBER,
30 p_project_type IN VARCHAR2 := NULL,
31 p_project_type_id IN NUMBER := NULL,
32 p_ci_type_name IN VARCHAR2 := NULL,
33 p_ci_type_id IN NUMBER := NULL,
34 p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id,
35 p_last_update_date IN DATE DEFAULT SYSDATE,
36 p_last_update_login IN NUMBER DEFAULT fnd_global.user_id,
37 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
38 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
39 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40 );
41
42 PROCEDURE delete_ci_type_usage (
43 p_api_version IN NUMBER := 1.0,
44 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
45 p_commit IN VARCHAR2 := FND_API.g_false,
46 p_validate_only IN VARCHAR2 := FND_API.g_true,
47 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
48 p_ci_type_usage_id IN NUMBER,
49 p_project_type IN VARCHAR2 := NULL,
50 p_project_type_id IN NUMBER := NULL,
51 p_ci_type_name IN VARCHAR2 := NULL,
52 p_ci_type_id IN NUMBER := NULL,
53 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
54 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
55 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
56 );
57
58 END pa_ci_type_usage_pub;