[Home] [Help]
PACKAGE: APPS.PA_ACTION_SETS_PVT
Source
1 PACKAGE pa_action_sets_pvt AS
2 /*$Header: PARASPVS.pls 120.1 2005/08/19 16:48:26 mwasowic noship $*/
3 --
4
5 g_line_number_msg_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6 g_info_msg_tbl SYSTEm.pa_varchar2_2000_tbl_type := SYSTEm.pa_varchar2_2000_tbl_type();
7
8 PROCEDURE create_action_set
9 (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
10 ,p_action_set_name IN pa_action_sets.action_set_name%TYPE
11 ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
12 ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
13 ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := NULL
14 ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := NULL
15 ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := NULL
16 ,p_source_action_set_id IN pa_action_sets.source_action_set_id%TYPE := NULL
17 ,p_status_code IN pa_action_sets.status_code%TYPE := NULL
18 ,p_description IN pa_action_sets.description%TYPE := NULL
19 ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := NULL
20 ,p_attribute1 IN pa_action_sets.attribute1%TYPE := NULL
21 ,p_attribute2 IN pa_action_sets.attribute2%TYPE := NULL
22 ,p_attribute3 IN pa_action_sets.attribute3%TYPE := NULL
23 ,p_attribute4 IN pa_action_sets.attribute4%TYPE := NULL
24 ,p_attribute5 IN pa_action_sets.attribute5%TYPE := NULL
25 ,p_attribute6 IN pa_action_sets.attribute6%TYPE := NULL
26 ,p_attribute7 IN pa_action_sets.attribute7%TYPE := NULL
27 ,p_attribute8 IN pa_action_sets.attribute8%TYPE := NULL
28 ,p_attribute9 IN pa_action_sets.attribute9%TYPE := NULL
29 ,p_attribute10 IN pa_action_sets.attribute10%TYPE := NULL
30 ,p_attribute11 IN pa_action_sets.attribute11%TYPE := NULL
31 ,p_attribute12 IN pa_action_sets.attribute12%TYPE := NULL
32 ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
33 ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
34 ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
35 ,x_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
36 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
37 );
38
39 PROCEDURE update_action_set
40 (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
41 ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
42 ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
43 ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
44 ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
45 ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
46 ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
47 ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
48 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
49 ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
50 ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
51 ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
52 ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
53 ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
54 ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
55 ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
56 ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
57 ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
58 ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
59 ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
60 ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
61 ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
62 ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
63 ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
64 ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
65 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66 );
67
68 PROCEDURE delete_action_set
69 (p_action_set_id IN pa_action_sets.action_set_id%TYPE
70 ,p_record_version_number IN pa_action_sets.record_version_number%TYPE := NULL
71 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
72
73 PROCEDURE create_action_set_line
74 (p_action_set_id IN pa_action_sets.action_set_id%TYPE
75 ,p_use_def_description_flag IN VARCHAR2 := 'Y'
76 ,p_description IN pa_action_set_lines.description%TYPE := NULL
77 ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := NULL
78 ,p_action_code IN pa_action_set_lines.action_code%TYPE
79 ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := NULL
80 ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := NULL
81 ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := NULL
82 ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := NULL
83 ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := NULL
84 ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := NULL
85 ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := NULL
86 ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := NULL
87 ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
88 ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
89 ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
90 ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
91 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
92 );
93
94 PROCEDURE update_action_set_line
95 (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
96 ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
97 ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
98 ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
99 ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
100 ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
101 ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
102 ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
103 ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
104 ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
105 ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
106 ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
107 ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
108 ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
109 ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
110 ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl
111 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112 );
113
114 PROCEDURE delete_action_set_line
115 (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
116 ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
117 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
118 );
119
120 FUNCTION get_def_reverse_audit_lines(p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
121 p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_type;
122
123 PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,
124 p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE,
125 p_object_type IN pa_action_sets.object_type%TYPE,
126 p_object_id IN pa_action_sets.object_id%TYPE,
127 p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE,
128 p_status_code IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
130
131 PROCEDURE perform_action_set_line
132 (p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE
133 ,p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
134 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
135 );
136
137 PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,
138 p_line_number_tbl IN pa_action_set_utils.number_tbl_type,
139 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
140
141
142 PROCEDURE bulk_update_condition_date(p_action_line_condition_id_tbl IN pa_action_set_utils.number_tbl_type,
143 p_condition_date_tbl IN pa_action_set_utils.date_tbl_type,
144 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
145
146 PROCEDURE bulk_update_line_status(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,
147 p_line_status_tbl IN pa_action_set_utils.varchar_tbl_type,
148 x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
149
150 END;