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
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
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
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
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
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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,
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,
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,