[Home] [Help]
PACKAGE: APPS.PA_PROJECT_SETS_PKG
Source
1 PACKAGE pa_project_sets_pkg AUTHID CURRENT_USER AS
2 /*$Header: PAPPSPKS.pls 120.1 2005/08/19 16:43:37 mwasowic noship $*/
3 --+
4
5 PROCEDURE insert_row
6 ( p_project_set_name IN pa_project_sets_tl.name%TYPE
7 ,p_party_id IN pa_project_sets_b.party_id%TYPE
8 ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
9 ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
10 ,p_access_level IN pa_project_sets_b.access_level%TYPE
11 ,p_description IN pa_project_sets_tl.description%TYPE
12 ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
13 ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
14 ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
15 ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
16 ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
17 ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
18 ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
19 ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
20 ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
21 ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
22 ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
23 ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
24 ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
25 ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
26 ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
27 ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
28 ,x_project_set_id OUT NOCOPY pa_project_sets_b.project_set_id%TYPE --File.Sql.39 bug 4440895
29 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30 );
31
32
33 PROCEDURE update_row
34 ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
35 ,p_project_set_name IN pa_project_sets_tl.name%TYPE
36 ,p_party_id IN pa_project_sets_b.party_id%TYPE
37 ,p_effective_start_date IN pa_project_sets_b.effective_start_date%TYPE
38 ,p_effective_end_date IN pa_project_sets_b.effective_end_date%TYPE
39 ,p_access_level IN pa_project_sets_b.access_level%TYPE
40 ,p_description IN pa_project_sets_tl.description%TYPE
41 ,p_attribute_category IN pa_project_sets_b.attribute_category%TYPE
42 ,p_attribute1 IN pa_project_sets_b.attribute1%TYPE
43 ,p_attribute2 IN pa_project_sets_b.attribute2%TYPE
44 ,p_attribute3 IN pa_project_sets_b.attribute3%TYPE
45 ,p_attribute4 IN pa_project_sets_b.attribute4%TYPE
46 ,p_attribute5 IN pa_project_sets_b.attribute5%TYPE
47 ,p_attribute6 IN pa_project_sets_b.attribute6%TYPE
48 ,p_attribute7 IN pa_project_sets_b.attribute7%TYPE
49 ,p_attribute8 IN pa_project_sets_b.attribute8%TYPE
50 ,p_attribute9 IN pa_project_sets_b.attribute9%TYPE
51 ,p_attribute10 IN pa_project_sets_b.attribute10%TYPE
52 ,p_attribute11 IN pa_project_sets_b.attribute11%TYPE
53 ,p_attribute12 IN pa_project_sets_b.attribute12%TYPE
54 ,p_attribute13 IN pa_project_sets_b.attribute13%TYPE
55 ,p_attribute14 IN pa_project_sets_b.attribute14%TYPE
56 ,p_attribute15 IN pa_project_sets_b.attribute15%TYPE
57 ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
58 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
59 );
60
61
62 PROCEDURE delete_row
63 ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
64 ,p_record_version_number IN pa_project_sets_b.record_version_number%TYPE
65 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 );
67
68 PROCEDURE insert_row_lines
69 ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
70 ,p_project_id IN pa_project_set_lines.project_id%TYPE
71 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
72 );
73
74
75 PROCEDURE delete_row_lines
76 ( p_project_set_id IN pa_project_set_lines.project_set_id%TYPE
77 ,p_project_id IN pa_project_set_lines.project_id%TYPE
78 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
79 );
80
81 procedure ADD_LANGUAGE;
82
83 end PA_PROJECT_SETS_PKG;