APPS.AMS_DMPERFORMANCE_PUB dependencies on AMS_DM_PERFORMANCE

Line 562: SELECT ams_dm_performance_s.NEXTVAL

558:
559: l_dummy NUMBER;
560:
561: CURSOR c_perf_id IS
562: SELECT ams_dm_performance_s.NEXTVAL
563: FROM dual;
564:
565: CURSOR c_id_exists (p_performance_id IN NUMBER) IS
566: SELECT 1

Line 569: FROM ams_dm_performance

565: CURSOR c_id_exists (p_performance_id IN NUMBER) IS
566: SELECT 1
567: FROM dual
568: WHERE EXISTS (SELECT 1
569: FROM ams_dm_performance
570: WHERE performance_id = p_performance_id)
571: ;
572: BEGIN
573: -- Initialize API return status to SUCCESS

Line 615: ams_dm_performance_pkg.insert_row (

611: -- note: the private api contains
612: -- savepoint and rollbacks, which
613: -- cannot be used in a distributed
614: -- transaction.
615: ams_dm_performance_pkg.insert_row (
616: px_performance_id => l_performance_id,
617: p_last_update_date => SYSDATE,
618: p_last_updated_by => FND_GLOBAL.user_id,
619: p_creation_date => SYSDATE,