42: --===================================================================
43:
44: TYPE Attr_Principal_rec_type IS RECORD
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
43:
44: TYPE Attr_Principal_rec_type IS RECORD
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
44: TYPE Attr_Principal_rec_type IS RECORD
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
45: (
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
46: Attr_Principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
47: ,last_update_date DATE := FND_API.G_MISS_DATE
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
48: ,last_updated_by NUMBER := FND_API.G_MISS_NUM
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
56:
49: ,creation_date DATE := FND_API.G_MISS_DATE
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
56:
57:
50: ,created_by NUMBER := FND_API.G_MISS_NUM
51: ,last_update_login NUMBER := FND_API.G_MISS_NUM
52: ,object_version_number NUMBER := FND_API.G_MISS_NUM
53: ,attribute_id NUMBER := FND_API.G_MISS_NUM
54: ,jtf_auth_principal_id NUMBER := FND_API.G_MISS_NUM
55: );
56:
57:
58: g_miss_Attr_Principal_rec Attr_Principal_rec_type;
71: -- Parameters
72: --
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79: --
72: --
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79: --
80: -- OUT
73: -- IN
74: -- p_api_version_number IN NUMBER Required
75: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
79: --
80: -- OUT
81: -- x_return_status OUT VARCHAR2
88: --
89:
90: PROCEDURE Create_Attr_Principal(
91: p_api_version_number IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95:
96: ,x_return_status OUT NOCOPY VARCHAR2
89:
90: PROCEDURE Create_Attr_Principal(
91: p_api_version_number IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95:
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER
90: PROCEDURE Create_Attr_Principal(
91: p_api_version_number IN NUMBER
92: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
93: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
94: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
95:
96: ,x_return_status OUT NOCOPY VARCHAR2
97: ,x_msg_count OUT NOCOPY NUMBER
98: ,x_msg_data OUT NOCOPY VARCHAR2
113: -- Parameters
114: --
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121: --
114: --
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121: --
122: -- OUT
115: -- IN
116: -- p_api_version_number IN NUMBER Required
117: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
118: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
119: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
120: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
121: --
122: -- OUT
123: -- x_return_status OUT VARCHAR2
129: --
130:
131: PROCEDURE Update_Attr_Principal(
132: p_api_version_number IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136:
137: ,x_return_status OUT NOCOPY VARCHAR2
130:
131: PROCEDURE Update_Attr_Principal(
132: p_api_version_number IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136:
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
131: PROCEDURE Update_Attr_Principal(
132: p_api_version_number IN NUMBER
133: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
134: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
135: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
136:
137: ,x_return_status OUT NOCOPY VARCHAR2
138: ,x_msg_count OUT NOCOPY NUMBER
139: ,x_msg_data OUT NOCOPY VARCHAR2
154: -- Parameters
155: --
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_Attribute_Principal_ID IN NUMBER
162: -- p_object_version_number IN NUMBER Optional Default = NULL
155: --
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_Attribute_Principal_ID IN NUMBER
162: -- p_object_version_number IN NUMBER Optional Default = NULL
163: --
156: -- IN
157: -- p_api_version_number IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161: -- p_Attribute_Principal_ID IN NUMBER
162: -- p_object_version_number IN NUMBER Optional Default = NULL
163: --
164: -- OUT
171: --
172:
173: PROCEDURE Delete_Attr_Principal(
174: p_api_version_number IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
172:
173: PROCEDURE Delete_Attr_Principal(
174: p_api_version_number IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_count OUT NOCOPY NUMBER
173: PROCEDURE Delete_Attr_Principal(
174: p_api_version_number IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178:
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_msg_count OUT NOCOPY NUMBER
181: ,x_msg_data OUT NOCOPY VARCHAR2
196: -- Parameters
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204: --
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204: --
205: -- OUT
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_Attribute_Principal_rec IN Attribute_Principal_rec_type Required
204: --
205: -- OUT
206: -- x_return_status OUT VARCHAR2
215: --
216:
217: PROCEDURE Lock_Attr_Principal(
218: p_api_version_number IN NUMBER
219: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
220:
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,x_msg_count OUT NOCOPY NUMBER
223: ,x_msg_data OUT NOCOPY VARCHAR2
236: -- End of Comments
237:
238: PROCEDURE Validate_Attr_Principal(
239: p_api_version_number IN NUMBER
240: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
242: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
243: ,p_Attr_Principal_rec IN Attr_Principal_rec_type
244: ,x_return_status OUT NOCOPY VARCHAR2
237:
238: PROCEDURE Validate_Attr_Principal(
239: p_api_version_number IN NUMBER
240: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
242: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_UPDATE
243: ,p_Attr_Principal_rec IN Attr_Principal_rec_type
244: ,x_return_status OUT NOCOPY VARCHAR2
245: ,x_msg_count OUT NOCOPY NUMBER
258: -- End of Comments
259:
260: PROCEDURE Validate_Attr_Principal_Rec(
261: p_api_version_number IN NUMBER
262: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER
265: ,x_msg_data OUT NOCOPY VARCHAR2
266: ,p_Attr_Principal_rec IN Attr_Principal_rec_type