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.

APPS.PV_ATTR_PRINCIPAL_PVT dependencies on PV_ATTR_PRINCIPALS

Line 51: SELECT PV.PV_Attr_PrincipalS_s.NEXTVAL

47: l_dummy NUMBER;
48: l_Attr_Principal_rec Attr_Principal_rec_type := p_Attr_Principal_rec;
49:
50: CURSOR c_id IS
51: SELECT PV.PV_Attr_PrincipalS_s.NEXTVAL
52: FROM dual;
53:
54: CURSOR c_id_exists (l_id IN NUMBER) IS
55: SELECT 1

Line 56: FROM PV_Attr_PrincipalS

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

Line 158: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Insert_Row)

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

Line 159: PV_Attr_PrincipalS_PKG.Insert_Row(

155: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
156: END IF;
157:
158: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Insert_Row)
159: PV_Attr_PrincipalS_PKG.Insert_Row(
160: px_Attr_Principal_id => l_Attr_Principal_rec.Attr_Principal_id
161: ,p_last_update_date => l_Attr_Principal_rec.last_update_date
162: ,p_last_updated_by => l_Attr_Principal_rec.last_updated_by
163: ,p_creation_date => l_Attr_Principal_rec.creation_date

Line 259: FROM PV_Attr_PrincipalS

255: IS
256:
257: CURSOR c_get_Attr_Principal(cv_Attr_Principal_id NUMBER) IS
258: SELECT *
259: FROM PV_Attr_PrincipalS
260: WHERE Attr_Principal_id = cv_Attr_Principal_id;
261:
262: l_api_name CONSTANT VARCHAR2(30) := 'Update_Attr_Principal';
263: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 380: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Update_Row)

376: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
377: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
378: END IF;
379:
380: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Update_Row)
381: PV_Attr_PrincipalS_PKG.Update_Row(
382: p_Attr_Principal_id => p_Attr_Principal_rec.Attr_Principal_id
383: ,p_last_update_date => SYSDATE
384: ,p_last_updated_by => G_USER_ID

Line 381: PV_Attr_PrincipalS_PKG.Update_Row(

377: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
378: END IF;
379:
380: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Update_Row)
381: PV_Attr_PrincipalS_PKG.Update_Row(
382: p_Attr_Principal_id => p_Attr_Principal_rec.Attr_Principal_id
383: ,p_last_update_date => SYSDATE
384: ,p_last_updated_by => G_USER_ID
385: --,p_creation_date => SYSDATE

Line 515: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Delete_Row)

511: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
512: END IF;
513:
514:
515: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Delete_Row)
516: PV_Attr_PrincipalS_PKG.Delete_Row(
517: p_Attr_Principal_ID => p_Attr_Principal_ID);
518: --
519: -- End of API body

Line 516: PV_Attr_PrincipalS_PKG.Delete_Row(

512: END IF;
513:
514:
515: -- Invoke table handler(PV_Attr_PrincipalS_PKG.Delete_Row)
516: PV_Attr_PrincipalS_PKG.Delete_Row(
517: p_Attr_Principal_ID => p_Attr_Principal_ID);
518: --
519: -- End of API body
520: --

Line 603: FROM PV_Attr_PrincipalS

599: l_Attr_Principal_ID NUMBER;
600:
601: CURSOR c_Attr_Principal IS
602: SELECT Attr_Principal_ID
603: FROM PV_Attr_PrincipalS
604: WHERE Attr_Principal_ID = p_Attr_Principal_ID
605: AND object_version_number = p_object_version
606: FOR UPDATE NOWAIT;
607:

Line 717: 'PV_Attr_PrincipalS',

713: BEGIN
714: x_return_status := FND_API.g_ret_sts_success;
715: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
716: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
717: 'PV_Attr_PrincipalS',
718: 'Attr_Principal_ID = ''' || p_Attr_Principal_rec.Attr_Principal_ID ||''''
719: );
720: ELSE
721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(

Line 722: 'PV_Attr_PrincipalS',

718: 'Attr_Principal_ID = ''' || p_Attr_Principal_rec.Attr_Principal_ID ||''''
719: );
720: ELSE
721: l_valid_flag := PVX_Utility_PVT.check_uniqueness(
722: 'PV_Attr_PrincipalS',
723: 'Attr_Principal_ID = ''' || p_Attr_Principal_rec.Attr_Principal_ID ||
724: ''' AND Attr_Principal_ID <> ' || p_Attr_Principal_rec.Attr_Principal_ID
725: );
726: END IF;

Line 1018: FROM pv_Attr_Principals

1014: l_return_status VARCHAR2(1);
1015:
1016: CURSOR c_complete IS
1017: SELECT *
1018: FROM pv_Attr_Principals
1019: WHERE Attr_Principal_id = p_Attr_Principal_rec.Attr_Principal_id;
1020: l_Attr_Principal_rec c_complete%ROWTYPE;
1021: BEGIN
1022: x_complete_rec := p_Attr_Principal_rec;