APPS.AMS_SCORERESULT_PUB dependencies on AMS_DM_SCORE_RESULTS

Line 538: SELECT ams_dm_score_results_s.NEXTVAL

534:
535: l_dummy NUMBER;
536:
537: CURSOR c_result_id IS
538: SELECT ams_dm_score_results_s.NEXTVAL
539: FROM dual;
540:
541: CURSOR c_id_exists (p_result_id IN NUMBER) IS
542: SELECT 1

Line 545: FROM ams_dm_score_results

541: CURSOR c_id_exists (p_result_id IN NUMBER) IS
542: SELECT 1
543: FROM dual
544: WHERE EXISTS (SELECT 1
545: FROM ams_dm_score_results
546: WHERE score_result_id = p_result_id)
547: ;
548: BEGIN
549: -- Standard Start of API savepoint

Line 596: ams_dm_score_results_pkg.insert_row (

592: EXIT WHEN l_dummy IS NULL;
593: END LOOP;
594:
595: -- call the table handler
596: ams_dm_score_results_pkg.insert_row (
597: PX_SCORE_RESULT_ID => l_score_result_id,
598: P_LAST_UPDATE_DATE => SYSDATE,
599: P_LAST_UPDATED_BY => FND_GLOBAL.user_id,
600: P_CREATION_DATE => SYSDATE,