eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PV_ATTRIBUTE_USAGE_PVT dependencies on PV_ATTRIBUTE_USAGES

Line 51: SELECT PV_ATTRIBUTE_USAGES_s.NEXTVAL

47: l_dummy NUMBER;
48: l_attribute_usage_rec attribute_usage_rec_type := p_attribute_usage_rec;
49:
50: CURSOR c_id IS
51: SELECT PV_ATTRIBUTE_USAGES_s.NEXTVAL
52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1

Line 56: FROM PV_ATTRIBUTE_USAGES

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

Line 159: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Insert_Row)

155: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
156: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
157: END IF;
158:
159: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Insert_Row)
160: PV_ATTRIBUTE_USAGES_PKG.Insert_Row(
161: px_attribute_usage_id => l_attribute_usage_rec.attribute_usage_id
162: ,p_last_update_date => l_attribute_usage_rec.last_update_date
163: ,p_last_updated_by => l_attribute_usage_rec.last_updated_by

Line 160: PV_ATTRIBUTE_USAGES_PKG.Insert_Row(

156: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
157: END IF;
158:
159: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Insert_Row)
160: PV_ATTRIBUTE_USAGES_PKG.Insert_Row(
161: px_attribute_usage_id => l_attribute_usage_rec.attribute_usage_id
162: ,p_last_update_date => l_attribute_usage_rec.last_update_date
163: ,p_last_updated_by => l_attribute_usage_rec.last_updated_by
164: ,p_creation_date => l_attribute_usage_rec.creation_date

Line 266: FROM PV_ATTRIBUTE_USAGES

262: IS
263:
264: CURSOR c_get_attribute_usage(cv_attribute_usage_id NUMBER) IS
265: SELECT *
266: FROM PV_ATTRIBUTE_USAGES
267: WHERE attribute_usage_id = cv_attribute_usage_id;
268:
269: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attribute_Usage';
270: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 387: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Update_Row)

383: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
384: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
385: END IF;
386:
387: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Update_Row)
388: PV_ATTRIBUTE_USAGES_PKG.Update_Row(
389: p_attribute_usage_id => p_attribute_usage_rec.attribute_usage_id
390: ,p_last_update_date => SYSDATE
391: ,p_last_updated_by => G_USER_ID

Line 388: PV_ATTRIBUTE_USAGES_PKG.Update_Row(

384: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
385: END IF;
386:
387: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Update_Row)
388: PV_ATTRIBUTE_USAGES_PKG.Update_Row(
389: p_attribute_usage_id => p_attribute_usage_rec.attribute_usage_id
390: ,p_last_update_date => SYSDATE
391: ,p_last_updated_by => G_USER_ID
392: --,p_creation_date => SYSDATE

Line 528: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Delete_Row)

524: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
525: END IF;
526:
527:
528: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Delete_Row)
529: PV_ATTRIBUTE_USAGES_PKG.Delete_Row(
530: p_ATTRIBUTE_USAGE_ID => p_ATTRIBUTE_USAGE_ID);
531: --
532: -- End of API body

Line 529: PV_ATTRIBUTE_USAGES_PKG.Delete_Row(

525: END IF;
526:
527:
528: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Delete_Row)
529: PV_ATTRIBUTE_USAGES_PKG.Delete_Row(
530: p_ATTRIBUTE_USAGE_ID => p_ATTRIBUTE_USAGE_ID);
531: --
532: -- End of API body
533: --

Line 616: FROM PV_ATTRIBUTE_USAGES

612: l_ATTRIBUTE_USAGE_ID NUMBER;
613:
614: CURSOR c_Attribute_Usage IS
615: SELECT ATTRIBUTE_USAGE_ID
616: FROM PV_ATTRIBUTE_USAGES
617: WHERE ATTRIBUTE_USAGE_ID = p_ATTRIBUTE_USAGE_ID
618: AND object_version_number = p_object_version
619: FOR UPDATE NOWAIT;
620:

Line 730: 'PV_ATTRIBUTE_USAGES',

726: BEGIN
727: x_return_status := FND_API.g_ret_sts_success;
728: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
729: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
730: 'PV_ATTRIBUTE_USAGES',
731: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||''''
732: );
733: ELSE
734: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

Line 735: 'PV_ATTRIBUTE_USAGES',

731: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||''''
732: );
733: ELSE
734: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
735: 'PV_ATTRIBUTE_USAGES',
736: 'ATTRIBUTE_USAGE_ID = ''' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID ||
737: ''' AND ATTRIBUTE_USAGE_ID <> ' || p_attribute_usage_rec.ATTRIBUTE_USAGE_ID
738: );
739: END IF;

Line 1090: FROM pv_attribute_usages

1086: l_return_status VARCHAR2(1);
1087:
1088: CURSOR c_complete IS
1089: SELECT *
1090: FROM pv_attribute_usages
1091: WHERE attribute_usage_id = p_attribute_usage_rec.attribute_usage_id;
1092: l_attribute_usage_rec c_complete%ROWTYPE;
1093: BEGIN
1094: x_complete_rec := p_attribute_usage_rec;