APPS.AMS_PROD_TEMPLATE_PVT dependencies on AMS_PROD_TEMPLATES_B

Line 51: SELECT AMS_PROD_TEMPLATES_B_s.NEXTVAL

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

Line 56: FROM AMS_PROD_TEMPLATES_B

52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1
56: FROM AMS_PROD_TEMPLATES_B
57: WHERE TEMPLATE_ID = l_id;
58:
59: CURSOR c_get_prod_attr
60: IS

Line 166: INSERT INTO AMS_PROD_TEMPLATES_B(

162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:
165:
166: INSERT INTO AMS_PROD_TEMPLATES_B(
167: template_id,
168: last_update_date,
169: last_updated_by,
170: creation_date,

Line 409: FROM AMS_PROD_TEMPLATES_B

405: IS
406:
407: CURSOR c_get_prod_template(p_template_id NUMBER) IS
408: SELECT *
409: FROM AMS_PROD_TEMPLATES_B
410: WHERE template_id =p_template_id;
411: -- Hint: Developer need to provide Where clause
412:
413: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Prod_Template';

Line 515: Update AMS_PROD_TEMPLATES_B

511: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514:
515: Update AMS_PROD_TEMPLATES_B
516: SET template_id = DECODE( p_prod_template_rec.template_id, FND_API.g_miss_num, template_id, p_prod_template_rec.template_id),
517: last_update_date = sysdate,
518: last_updated_by = fnd_global.user_id,
519: object_version_number = p_prod_template_rec.object_version_number +1,

Line 673: DELETE FROM AMS_PROD_TEMPLATES_B

669: END IF;
670: RAISE FND_API.g_exc_error;
671: END IF;
672:
673: DELETE FROM AMS_PROD_TEMPLATES_B
674: WHERE TEMPLATE_ID = p_TEMPLATE_ID
675: AND object_version_number = p_object_version_number;
676:
677: IF (SQL%NOTFOUND) THEN

Line 790: FROM AMS_PROD_TEMPLATES_B

786: l_TEMPLATE_ID NUMBER;
787:
788: CURSOR c_Prod_Template IS
789: SELECT TEMPLATE_ID
790: FROM AMS_PROD_TEMPLATES_B
791: WHERE TEMPLATE_ID = p_TEMPLATE_ID
792: AND object_version_number = p_object_version
793: FOR UPDATE NOWAIT;
794:

Line 927: 'AMS_PROD_TEMPLATES_B',

923: BEGIN
924: x_return_status := FND_API.g_ret_sts_success;
925: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
926: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
927: 'AMS_PROD_TEMPLATES_B',
928: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||''''
929: );
930: ELSE
931: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 932: 'AMS_PROD_TEMPLATES_B',

928: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||''''
929: );
930: ELSE
931: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
932: 'AMS_PROD_TEMPLATES_B',
933: 'TEMPLATE_ID = ''' || p_prod_template_rec.TEMPLATE_ID ||
934: ''' AND TEMPLATE_ID <> ' || p_prod_template_rec.TEMPLATE_ID
935: );
936: END IF;

Line 1097: FROM ams_prod_templates_b

1093: l_return_status VARCHAR2(1);
1094:
1095: CURSOR c_complete IS
1096: SELECT *
1097: FROM ams_prod_templates_b
1098: WHERE template_id = p_prod_template_rec.template_id;
1099: l_prod_template_rec c_complete%ROWTYPE;
1100: BEGIN
1101: x_complete_rec := p_prod_template_rec;