APPS.PV_GE_PARTY_NOTIF_PVT dependencies on PV_GE_PARTY_NOTIFICATIONS

Line 97: SELECT pv_ge_party_notifications_s.NEXTVAL

93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_party_notification_id NUMBER;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT pv_ge_party_notifications_s.NEXTVAL
98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1

Line 102: FROM PV_GE_PARTY_NOTIFICATIONS

98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1
102: FROM PV_GE_PARTY_NOTIFICATIONS
103: WHERE party_notification_id = l_id;
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT create_ge_party_notif_pvt;

Line 334: FROM PV_GE_PARTY_NOTIFICATIONS

330:
331:
332: CURSOR c_get_ge_party_notif(party_notification_id NUMBER) IS
333: SELECT *
334: FROM PV_GE_PARTY_NOTIFICATIONS
335: WHERE party_notification_id = p_pgp_notif_rec.party_notification_id;
336: -- Hint: Developer need to provide Where clause
337:
338:

Line 848: 'pv_ge_party_notifications',

844: IF p_validation_mode = JTF_PLSQL_API.g_create
845: AND p_pgp_notif_rec.party_notification_id IS NOT NULL
846: THEN
847: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
848: 'pv_ge_party_notifications',
849: 'party_notification_id = ''' || p_pgp_notif_rec.party_notification_id ||''''
850: );
851: END IF;
852:

Line 1031: FROM pv_ge_party_notifications

1027: l_return_status VARCHAR2(1);
1028:
1029: CURSOR c_complete IS
1030: SELECT *
1031: FROM pv_ge_party_notifications
1032: WHERE party_notification_id = p_pgp_notif_rec.party_notification_id;
1033: l_pgp_notif_rec c_complete%ROWTYPE;
1034: BEGIN
1035: x_complete_rec := p_pgp_notif_rec;