28: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := NULL
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
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
29: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := NULL
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
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: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
30: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := NULL
31: ,p_api_version IN NUMBER := 1.0
32: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
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: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
38: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
39: );
40:
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
40:
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
41: PROCEDURE update_action_set
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
42: (p_action_set_id IN pa_action_sets.action_set_id%TYPE := NULL
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
43: ,p_action_set_name IN pa_action_sets.action_set_name%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
44: ,p_object_type IN pa_action_sets.object_type%TYPE := FND_API.G_MISS_CHAR
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
45: ,p_action_set_type_code IN pa_action_sets.action_set_type_code%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
46: ,p_object_id IN pa_action_sets.object_id%TYPE := FND_API.G_MISS_NUM
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
47: ,p_start_date_active IN pa_action_sets.start_date_active%TYPE := FND_API.G_MISS_DATE
48: ,p_end_date_active IN pa_action_sets.end_date_active%TYPE := FND_API.G_MISS_DATE
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
49: ,p_action_set_template_flag IN pa_action_sets.action_set_template_flag%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
50: ,p_status_code IN pa_action_sets.status_code%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
51: ,p_description IN pa_action_sets.description%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
52: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
53: ,p_attribute_category IN pa_action_sets.attribute_category%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
54: ,p_attribute1 IN pa_action_sets.attribute1%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
55: ,p_attribute2 IN pa_action_sets.attribute2%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
56: ,p_attribute3 IN pa_action_sets.attribute3%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
57: ,p_attribute4 IN pa_action_sets.attribute4%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
58: ,p_attribute5 IN pa_action_sets.attribute5%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
59: ,p_attribute6 IN pa_action_sets.attribute6%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
60: ,p_attribute7 IN pa_action_sets.attribute7%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
61: ,p_attribute8 IN pa_action_sets.attribute8%TYPE := FND_API.G_MISS_CHAR
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
62: ,p_attribute9 IN pa_action_sets.attribute9%TYPE := FND_API.G_MISS_CHAR
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
63: ,p_attribute10 IN pa_action_sets.attribute10%TYPE := FND_API.G_MISS_CHAR
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64: ,p_attribute11 IN pa_action_sets.attribute11%TYPE := FND_API.G_MISS_CHAR
65: ,p_attribute12 IN pa_action_sets.attribute12%TYPE := FND_API.G_MISS_CHAR
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
66: ,p_attribute13 IN pa_action_sets.attribute13%TYPE := FND_API.G_MISS_CHAR
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
67: ,p_attribute14 IN pa_action_sets.attribute14%TYPE := FND_API.G_MISS_CHAR
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
75: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
68: ,p_attribute15 IN pa_action_sets.attribute15%TYPE := FND_API.G_MISS_CHAR
69: ,p_api_version IN NUMBER := 1.0
70: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
71: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
72: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
73: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
75: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
76: );
81: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
85: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
88: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
82: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
85: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
88: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
90: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
83: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
84: ,p_api_version IN NUMBER := 1.0
85: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
86: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
87: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
88: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
89: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
90: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
91: );
107: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := NULL
108: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
109: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
110: ,p_api_version IN NUMBER := 1.0
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
114: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
108: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := NULL
109: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
110: ,p_api_version IN NUMBER := 1.0
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
114: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
109: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
110: ,p_api_version IN NUMBER := 1.0
111: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
112: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
113: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
114: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
115: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
116: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
117: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
119:
120: PROCEDURE update_action_set_line
121: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
122: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
123: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
124: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
125: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
121: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE
122: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
123: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
124: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
125: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
122: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE
123: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
124: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
125: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
123: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM
124: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
125: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
124: ,p_use_def_description_flag IN VARCHAR2 := 'Y'
125: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
125: ,p_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
126: ,p_action_code IN pa_action_set_lines.action_code%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
127: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
128: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
129: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
130: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138: ,p_api_version IN NUMBER := 1.0
131: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138: ,p_api_version IN NUMBER := 1.0
139: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
132: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
133: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
134: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138: ,p_api_version IN NUMBER := 1.0
139: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138: ,p_api_version IN NUMBER := 1.0
139: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
141: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
142: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
136: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138: ,p_api_version IN NUMBER := 1.0
139: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
141: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
142: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
144: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
137: ,p_condition_tbl IN pa_action_set_utils.action_line_cond_tbl_type
138: ,p_api_version IN NUMBER := 1.0
139: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
140: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
141: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
142: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
143: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
144: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
145: );
148: PROCEDURE delete_action_set_line
149: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
150: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
151: ,p_api_version IN NUMBER := 1.0
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
149: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE := NULL
150: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
151: ,p_api_version IN NUMBER := 1.0
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
150: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE := NULL
151: ,p_api_version IN NUMBER := 1.0
152: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
153: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
154: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
157: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158: );
162: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
163: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
164: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165: ,p_api_version IN NUMBER := 1.0
166: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
169: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
163: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
164: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165: ,p_api_version IN NUMBER := 1.0
166: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
169: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
164: ,p_perform_action_set_flag IN VARCHAR2 := 'N'
165: ,p_api_version IN NUMBER := 1.0
166: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
167: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
168: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
169: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
170: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
171: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
172: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
186: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
180: ,p_record_version_number IN pa_action_sets.record_version_number%TYPE
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
186: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
181: ,p_new_action_set_id IN pa_action_sets.action_set_id%TYPE
182: ,p_api_version IN NUMBER := 1.0
183: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
184: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
185: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
186: ,x_new_action_set_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
187: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
189: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
194: ,p_action_set_type_code IN pa_action_set_types.action_set_type_code%TYPE := NULL
195: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
196: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
197: ,p_api_version IN NUMBER := 1.0
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
201: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
195: ,p_object_type IN pa_action_sets.object_type%TYPE := NULL
196: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
197: ,p_api_version IN NUMBER := 1.0
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
201: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
203: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
196: ,p_object_id IN pa_action_sets.object_id%TYPE := NULL
197: ,p_api_version IN NUMBER := 1.0
198: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
199: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
200: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
201: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
202: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
203: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
204: );
238: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := NULL
239: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
240: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
241: ,p_api_version IN NUMBER := 1.0
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
243: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
245: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
239: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := NULL
240: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
241: ,p_api_version IN NUMBER := 1.0
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
243: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
245: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
240: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := NULL
241: ,p_api_version IN NUMBER := 1.0
242: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
243: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
244: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
245: ,x_action_set_line_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
246: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
247: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
248: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
250:
251: PROCEDURE update_line_single_cond
252: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
253: ,p_record_version_number IN NUMBER := NULL
254: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
255: ,p_action_code IN pa_action_set_lines.action_code%TYPE
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
252: (p_action_set_line_id IN pa_action_sets.action_set_id%TYPE
253: ,p_record_version_number IN NUMBER := NULL
254: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
255: ,p_action_code IN pa_action_set_lines.action_code%TYPE
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
253: ,p_record_version_number IN NUMBER := NULL
254: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
255: ,p_action_code IN pa_action_set_lines.action_code%TYPE
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
254: ,p_action_description IN pa_action_set_lines.description%TYPE := FND_API.G_MISS_CHAR
255: ,p_action_code IN pa_action_set_lines.action_code%TYPE
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
255: ,p_action_code IN pa_action_set_lines.action_code%TYPE
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
256: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
257: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
258: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
259: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%TYPE := FND_API.G_MISS_CHAR
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
260: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
261: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
262: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%TYPE := FND_API.G_MISS_CHAR
263: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
264: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
265: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
266: ,p_condition_description IN pa_action_set_line_cond.description%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
267: ,p_condition_code IN pa_action_set_line_cond.condition_code%TYPE
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
268: ,p_condition_attribute1 IN pa_action_set_line_cond.condition_attribute1%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
269: ,p_condition_attribute2 IN pa_action_set_line_cond.condition_attribute2%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
270: ,p_condition_attribute3 IN pa_action_set_line_cond.condition_attribute3%TYPE := FND_API.G_MISS_CHAR
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
271: ,p_condition_attribute4 IN pa_action_set_line_cond.condition_attribute4%TYPE := FND_API.G_MISS_CHAR
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
279: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
272: ,p_condition_attribute5 IN pa_action_set_line_cond.condition_attribute5%TYPE := FND_API.G_MISS_CHAR
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
279: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
280: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
273: ,p_condition_attribute6 IN pa_action_set_line_cond.condition_attribute6%TYPE := FND_API.G_MISS_CHAR
274: ,p_condition_attribute7 IN pa_action_set_line_cond.condition_attribute7%TYPE := FND_API.G_MISS_CHAR
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
279: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
280: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
281: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
275: ,p_condition_attribute8 IN pa_action_set_line_cond.condition_attribute8%TYPE := FND_API.G_MISS_CHAR
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
279: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
280: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
281: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
276: ,p_condition_attribute9 IN pa_action_set_line_cond.condition_attribute9%TYPE := FND_API.G_MISS_CHAR
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
279: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
280: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
281: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
284: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
277: ,p_condition_attribute10 IN pa_action_set_line_cond.condition_attribute10%TYPE := FND_API.G_MISS_CHAR
278: ,p_api_version IN NUMBER := 1.0
279: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
280: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
281: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
282: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
283: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
284: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
285: );