74:
75: -- Start of comments
76: -- API name : Create_Job_Role - Private.
77: -- Pre-reqs : None.
78: -- IN : standard params
79: -- p_rec of table rec type
80: -- OUT : standard params
81: -- x_job_role_id
82: -- Version : 1.0
76: -- API name : Create_Job_Role - Private.
77: -- Pre-reqs : None.
78: -- IN : standard params
79: -- p_rec of table rec type
80: -- OUT : standard params
81: -- x_job_role_id
82: -- Version : 1.0
83: --
84: -- End of comments
100:
101: l_newrec job_role_rec_type := p_rec;
102: l_count NUMBER;
103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT Create_Job_Role;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call
103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT Create_Job_Role;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call
109: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
177: end if;
178:
179: cn_job_title_pkg.insert_row(l_newrec);
180:
181: -- Standard check of p_commit.
182: IF FND_API.To_Boolean( p_commit ) THEN
183: COMMIT WORK;
184: END IF;
185:
217:
218: -- Start of comments
219: -- API name : Update_Job_Role - Private.
220: -- Pre-reqs : None.
221: -- IN : standard params
222: -- p_rec of table rec type
223: -- OUT : standard params
224: -- Version : Current version 1.0
225: --
219: -- API name : Update_Job_Role - Private.
220: -- Pre-reqs : None.
221: -- IN : standard params
222: -- p_rec of table rec type
223: -- OUT : standard params
224: -- Version : Current version 1.0
225: --
226: -- End of comments
227:
243: l_count NUMBER;
244: l_old_start DATE;
245: l_old_end DATE;
246: BEGIN
247: -- Standard Start of API savepoint
248: SAVEPOINT Update_Job_Role;
249:
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call
246: BEGIN
247: -- Standard Start of API savepoint
248: SAVEPOINT Update_Job_Role;
249:
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call
252: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: END IF;
342: l_newrec.object_version_number);
343:
344: cn_job_title_pkg.update_row(l_newrec);
345:
346: -- Standard check of p_commit.
347: IF FND_API.To_Boolean( p_commit ) THEN
348: COMMIT WORK;
349: END IF;
350:
381:
382: -- Start of comments
383: -- API name : Delete_Job_Role - Private.
384: -- Pre-reqs : None.
385: -- IN : standard params
386: -- p_job_role_id
387: -- OUT : standard params
388: -- Version : Current version 1.0
389: --
383: -- API name : Delete_Job_Role - Private.
384: -- Pre-reqs : None.
385: -- IN : standard params
386: -- p_job_role_id
387: -- OUT : standard params
388: -- Version : Current version 1.0
389: --
390: -- End of comments
391:
404: l_api_version CONSTANT NUMBER := 1.0;
405: l_count NUMBER;
406:
407: BEGIN
408: -- Standard Start of API savepoint
409: SAVEPOINT Delete_Job_Role;
410:
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call
407: BEGIN
408: -- Standard Start of API savepoint
409: SAVEPOINT Delete_Job_Role;
410:
411: -- Standard call to check for call compatibility.
412: IF NOT FND_API.Compatible_API_Call
413: (l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
437: valid_no_srp(p_job_role_id);
438:
439: cn_job_title_pkg.delete_row(p_job_role_id);
440:
441: -- Standard check of p_commit.
442: IF FND_API.To_Boolean( p_commit ) THEN
443: COMMIT WORK;
444: END IF;
445: