DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_PVT dependencies on PA_ACTION_SET_LINES

Line 76: ,p_description IN pa_action_set_lines.description%TYPE := NULL

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

Line 77: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%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

Line 78: ,p_action_code IN pa_action_set_lines.action_code%TYPE

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

Line 79: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%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

Line 80: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%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

Line 81: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%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

Line 82: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%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

Line 83: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%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

Line 84: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%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

Line 85: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%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

Line 86: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%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

Line 87: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%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

Line 88: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%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: );

Line 95: (p_action_set_line_id IN pa_action_set_lines.action_set_line_id%TYPE

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

Line 96: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE

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

Line 97: ,p_action_set_line_number IN pa_action_set_lines.action_set_line_number%TYPE := FND_API.G_MISS_NUM

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

Line 98: ,p_description IN pa_action_set_lines.description%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

Line 99: ,p_action_code IN pa_action_set_lines.action_code%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

Line 100: ,p_action_attribute1 IN pa_action_set_lines.action_attribute1%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

Line 101: ,p_action_attribute2 IN pa_action_set_lines.action_attribute2%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

Line 102: ,p_action_attribute3 IN pa_action_set_lines.action_attribute3%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

Line 103: ,p_action_attribute4 IN pa_action_set_lines.action_attribute4%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

Line 104: ,p_action_attribute5 IN pa_action_set_lines.action_attribute5%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

Line 105: ,p_action_attribute6 IN pa_action_set_lines.action_attribute6%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

Line 106: ,p_action_attribute7 IN pa_action_set_lines.action_attribute7%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

Line 107: ,p_action_attribute8 IN pa_action_set_lines.action_attribute8%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

Line 108: ,p_action_attribute9 IN pa_action_set_lines.action_attribute9%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: );

Line 109: ,p_action_attribute10 IN pa_action_set_lines.action_attribute10%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:

Line 116: ,p_record_version_number IN pa_action_set_lines.record_version_number%TYPE

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,

Line 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,

Line 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,