[Home] [Help]
PACKAGE: APPS.PA_CI_TYPE_USAGE_PVT
Source
1 PACKAGE pa_ci_type_usage_pvt AS
2 /* $Header: PACITUVS.pls 120.1 2005/08/19 16:19:07 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_id IN NUMBER,
11 p_ci_type_id IN NUMBER,
12 p_created_by IN NUMBER DEFAULT fnd_global.user_id,
13 p_creation_date IN DATE DEFAULT SYSDATE,
14 p_last_update_login IN NUMBER DEFAULT fnd_global.user_id,
15 x_ci_type_usage_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
16 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
17 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
18 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
19 );
20
21 PROCEDURE update_ci_type_usage (
22 p_api_version IN NUMBER := 1.0,
23 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
24 p_commit IN VARCHAR2 := FND_API.g_false,
25 p_validate_only IN VARCHAR2 := FND_API.g_true,
26 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
27 p_ci_type_usage_id IN NUMBER,
28 p_project_type_id IN NUMBER,
29 p_ci_type_id IN NUMBER,
30 p_last_updated_by IN NUMBER DEFAULT fnd_global.user_id,
31 p_last_update_date IN DATE DEFAULT SYSDATE,
32 p_last_update_login IN NUMBER DEFAULT fnd_global.user_id,
33 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36 ) ;
37
38 PROCEDURE delete_ci_type_usage (
39 p_api_version IN NUMBER := 1.0,
40 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
41 p_commit IN VARCHAR2 := FND_API.g_false,
42 p_validate_only IN VARCHAR2 := FND_API.g_true,
43 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
44 p_ci_type_usage_id IN NUMBER,
45 p_project_type_id IN NUMBER,
46 p_ci_type_id IN NUMBER,
47 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
49 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 );
51
52 END pa_ci_type_usage_pvt;