APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SET_UTILS

Line 89: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type

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:

Line 110: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type := pa_action_set_utils.l_empty_condition_tbl

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

Line 121: p_reason IN VARCHAR2) RETURN pa_action_set_utils.insert_audit_lines_tbl_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,

Line 123: PROCEDURE bulk_insert_audit_lines(p_audit_lines_tbl IN pa_action_set_utils.insert_audit_lines_tbl_type,

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,

Line 137: PROCEDURE bulk_update_line_number(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_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:

Line 138: p_line_number_tbl IN pa_action_set_utils.number_tbl_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,

Line 142: PROCEDURE bulk_update_condition_date(p_action_line_condition_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,

Line 143: p_condition_date_tbl IN pa_action_set_utils.date_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,

Line 146: PROCEDURE bulk_update_line_status(p_action_set_line_id_tbl IN pa_action_set_utils.number_tbl_type,

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;

Line 147: p_line_status_tbl IN pa_action_set_utils.varchar_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;