APPS.AMS_TEMPLATE_ATTR_PVT dependencies on AMS_PROD_TEMPLATE_ATTR

Line 50: SELECT AMS_PROD_TEMPLATE_ATTR_s.NEXTVAL

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

Line 55: FROM AMS_PROD_TEMPLATE_ATTR

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

Line 137: INSERT INTO AMS_PROD_TEMPLATE_ATTR(

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_PROD_TEMPLATE_ATTR(
138: template_attribute_id,
139: template_id,
140: last_update_date,
141: last_updated_by,

Line 253: FROM AMS_PROD_TEMPLATE_ATTR

249: IS
250:
251: CURSOR c_get_template_attr(p_template_attribute_id NUMBER) IS
252: SELECT *
253: FROM AMS_PROD_TEMPLATE_ATTR
254: WHERE template_attribute_id = p_template_attribute_id;
255: -- Hint: Developer need to provide Where clause
256:
257: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Template_Attr';

Line 373: Update AMS_PROD_TEMPLATE_ATTR

369: -- l_template_attr_rec.default_flag := 'Y';
370: --END IF;
371:
372:
373: Update AMS_PROD_TEMPLATE_ATTR
374: SET template_attribute_id = DECODE( l_template_attr_rec.template_attribute_id, FND_API.g_miss_num, template_attribute_id, l_template_attr_rec.template_attribute_id),
375: template_id = DECODE( l_template_attr_rec.template_id, FND_API.g_miss_num, template_id, l_template_attr_rec.template_id),
376: last_update_date = sysdate,
377: last_updated_by = fnd_global.user_id,

Line 423: UPDATE ams_prod_template_attr

419: -- bug 3544835 fix start
420: -- standard who columns should be also modified ,so that the changes
421: -- in the seeded template done by the user,doesn't gets overwritten by the ldts
422:
423: UPDATE ams_prod_template_attr
424: SET parent_select_all = l_template_attr_rec.parent_select_all
425: , last_update_date = sysdate
426: , last_updated_by = fnd_global.user_id
427: , last_update_login = FND_GLOBAL.CONC_LOGIN_ID

Line 554: DELETE FROM AMS_PROD_TEMPLATE_ATTR

550: -- Initialize API return status to SUCCESS
551: x_return_status := FND_API.G_RET_STS_SUCCESS;
552:
553:
554: DELETE FROM AMS_PROD_TEMPLATE_ATTR
555: WHERE TEMPLATE_ATTRIBUTE_ID = p_TEMPLATE_ATTRIBUTE_ID;
556:
557: If (SQL%NOTFOUND) then
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 643: FROM AMS_PROD_TEMPLATE_ATTR

639: l_TEMPLATE_ATTRIBUTE_ID NUMBER;
640:
641: CURSOR c_Template_Attr IS
642: SELECT TEMPLATE_ATTRIBUTE_ID
643: FROM AMS_PROD_TEMPLATE_ATTR
644: WHERE TEMPLATE_ATTRIBUTE_ID = p_TEMPLATE_ATTRIBUTE_ID
645: AND object_version_number = p_object_version
646: FOR UPDATE NOWAIT;
647:

Line 762: 'AMS_PROD_TEMPLATE_ATTR',

758: BEGIN
759: x_return_status := FND_API.g_ret_sts_success;
760: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
761: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
762: 'AMS_PROD_TEMPLATE_ATTR',
763: 'TEMPLATE_ATTRIBUTE_ID = ''' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID ||''''
764: );
765: ELSE
766: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 767: 'AMS_PROD_TEMPLATE_ATTR',

763: 'TEMPLATE_ATTRIBUTE_ID = ''' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID ||''''
764: );
765: ELSE
766: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
767: 'AMS_PROD_TEMPLATE_ATTR',
768: 'TEMPLATE_ATTRIBUTE_ID = ''' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID ||
769: ''' AND TEMPLATE_ATTRIBUTE_ID <> ' || p_template_attr_rec.TEMPLATE_ATTRIBUTE_ID
770: );
771: END IF;

Line 914: FROM ams_prod_template_attr

910: l_return_status VARCHAR2(1);
911:
912: CURSOR c_complete IS
913: SELECT *
914: FROM ams_prod_template_attr
915: WHERE template_attribute_id = p_template_attr_rec.template_attribute_id;
916: l_template_attr_rec c_complete%ROWTYPE;
917: BEGIN
918: x_complete_rec := p_template_attr_rec;