APPS.AMS_TEMPLATE_RES_PVT dependencies on AMS_TEMPL_RESPONSIBILITY

Line 50: SELECT AMS_TEMPL_RESPONSIBILITY_s.NEXTVAL

46: l_TEMPL_RESPONSIBILITY_ID NUMBER;
47: l_dummy NUMBER;
48:
49: CURSOR c_id IS
50: SELECT AMS_TEMPL_RESPONSIBILITY_s.NEXTVAL
51: FROM dual;
52:
53: CURSOR c_id_exists (l_id IN NUMBER) IS
54: SELECT 1

Line 55: FROM AMS_TEMPL_RESPONSIBILITY

51: FROM dual;
52:
53: CURSOR c_id_exists (l_id IN NUMBER) IS
54: SELECT 1
55: FROM AMS_TEMPL_RESPONSIBILITY
56: WHERE TEMPL_RESPONSIBILITY_ID = l_id;
57:
58: BEGIN
59: -- Standard Start of API savepoint

Line 137: INSERT INTO AMS_TEMPL_RESPONSIBILITY(

133: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
134: RAISE FND_API.G_EXC_ERROR;
135: END IF;
136:
137: INSERT INTO AMS_TEMPL_RESPONSIBILITY(
138: templ_responsibility_id,
139: template_id,
140: responsibility_id,
141: last_update_date,

Line 244: FROM AMS_TEMPL_RESPONSIBILITY

240: IS
241:
242: CURSOR c_get_template_res(p_templ_responsibility_id NUMBER) IS
243: SELECT *
244: FROM AMS_TEMPL_RESPONSIBILITY
245: WHERE templ_responsibility_id = p_templ_responsibility_id;
246: -- Hint: Developer need to provide Where clause
247:
248: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_template_res';

Line 350: Update AMS_TEMPL_RESPONSIBILITY

346: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;
349:
350: Update AMS_TEMPL_RESPONSIBILITY
351: SET templ_responsibility_id = DECODE( p_template_res_rec.templ_responsibility_id, FND_API.g_miss_num, templ_responsibility_id, p_template_res_rec.templ_responsibility_id),
352: template_id = DECODE( p_template_res_rec.template_id, FND_API.g_miss_num, template_id, p_template_res_rec.template_id),
353: responsibility_id = DECODE( p_template_res_rec.responsibility_id, FND_API.g_miss_num, responsibility_id, p_template_res_rec.responsibility_id),
354: last_update_date = sysdate,

Line 475: DELETE FROM AMS_TEMPL_RESPONSIBILITY

471:
472: -- Initialize API return status to SUCCESS
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: DELETE FROM AMS_TEMPL_RESPONSIBILITY
476: WHERE TEMPL_RESPONSIBILITY_ID = p_TEMPL_RESPONSIBILITY_ID;
477:
478: If (SQL%NOTFOUND) then
479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 564: FROM AMS_TEMPL_RESPONSIBILITY

560: l_TEMPL_RESPONSIBILITY_ID NUMBER;
561:
562: CURSOR c_template_res IS
563: SELECT TEMPL_RESPONSIBILITY_ID
564: FROM AMS_TEMPL_RESPONSIBILITY
565: WHERE TEMPL_RESPONSIBILITY_ID = p_TEMPL_RESPONSIBILITY_ID
566: AND object_version_number = p_object_version
567: FOR UPDATE NOWAIT;
568:

Line 683: 'AMS_TEMPL_RESPONSIBILITY',

679: BEGIN
680: x_return_status := FND_API.g_ret_sts_success;
681: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
682: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
683: 'AMS_TEMPL_RESPONSIBILITY',
684: 'TEMPL_RESPONSIBILITY_ID = ''' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID ||''''
685: );
686: ELSE
687: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 688: 'AMS_TEMPL_RESPONSIBILITY',

684: 'TEMPL_RESPONSIBILITY_ID = ''' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID ||''''
685: );
686: ELSE
687: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
688: 'AMS_TEMPL_RESPONSIBILITY',
689: 'TEMPL_RESPONSIBILITY_ID = ''' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID ||
690: ''' AND TEMPL_RESPONSIBILITY_ID <> ' || p_template_res_rec.TEMPL_RESPONSIBILITY_ID
691: );
692: END IF;

Line 695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPL_RESPONSIBILITY_ID_DUPLICATE');

691: );
692: END IF;
693:
694: IF l_valid_flag = FND_API.g_false THEN
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_TEMPL_RESPONSIBILITY_ID_DUPLICATE');
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;
698: END IF;
699:

Line 837: FROM ams_templ_responsibility

833: l_return_status VARCHAR2(1);
834:
835: CURSOR c_complete IS
836: SELECT *
837: FROM ams_templ_responsibility
838: WHERE templ_responsibility_id = p_template_res_rec.templ_responsibility_id;
839: l_template_res_rec c_complete%ROWTYPE;
840: BEGIN
841: x_complete_rec := p_template_res_rec;