APPS.AMS_DM_SCORES_B_PKG dependencies on AMS_DM_SCORES_ALL_B

Line 77: INSERT INTO AMS_DM_scoreS_ALL_B(

73: )
74: IS
75: BEGIN
76:
77: INSERT INTO AMS_DM_scoreS_ALL_B(
78: score_id,
79: last_update_date,
80: last_updated_by,
81: creation_date,

Line 251: Update AMS_DM_scoreS_ALL_B

247: p_attribute15 VARCHAR2
248: )
249: IS
250: BEGIN
251: Update AMS_DM_scoreS_ALL_B
252: SET
253: score_ID = decode( p_score_ID, FND_API.g_miss_num, score_ID, p_score_ID),
254: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.g_miss_date, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
255: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.g_miss_num, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 320: DELETE FROM AMS_DM_scoreS_ALL_B

316: PROCEDURE Delete_Row(
317: p_score_ID NUMBER)
318: IS
319: BEGIN
320: DELETE FROM AMS_DM_scoreS_ALL_B
321: WHERE score_ID = p_score_ID;
322: If (SQL%NOTFOUND) then
323: RAISE NO_DATA_FOUND;
324: End If;

Line 373: FROM AMS_DM_scoreS_ALL_B

369:
370: IS
371: CURSOR C IS
372: SELECT *
373: FROM AMS_DM_scoreS_ALL_B
374: WHERE score_ID = p_score_ID
375: FOR UPDATE of score_ID NOWAIT;
376: Recinfo C%ROWTYPE;
377: BEGIN

Line 499: from AMS_DM_SCORES_ALL_B B

495: begin
496: delete from AMS_DM_SCORES_ALL_TL T
497: where not exists
498: (select NULL
499: from AMS_DM_SCORES_ALL_B B
500: where B.SCORE_ID = T.SCORE_ID
501: );
502:
503: update AMS_DM_SCORES_ALL_TL T set (

Line 632: from ams_dm_scores_all_b

628: l_score_id number;
629:
630: cursor c_obj_verno is
631: select object_version_number
632: from ams_dm_scores_all_b
633: where score_id = x_score_id;
634:
635: cursor c_chk_score_exists is
636: select 'x'

Line 637: from ams_dm_scores_all_b

633: where score_id = x_score_id;
634:
635: cursor c_chk_score_exists is
636: select 'x'
637: from ams_dm_scores_all_b
638: where score_id = x_score_id;
639:
640: cursor c_get_score_id is
641: select ams_dm_scores_all_b_s.nextval

Line 641: select ams_dm_scores_all_b_s.nextval

637: from ams_dm_scores_all_b
638: where score_id = x_score_id;
639:
640: cursor c_get_score_id is
641: select ams_dm_scores_all_b_s.nextval
642: from dual;
643: BEGIN
644: if X_OWNER = 'SEED' then
645: l_user_id := 1;