APPS.IEX_SCORE_PVT dependencies on IEX_SCORE_HISTORIES

Line 3450: /* UPDATE IEX_SCORE_HISTORIES with the collections score, score_id, and last_score_date */

3446: l_running_score := IEX_SCORE_PVT.G_MAX_SCORE;
3447: end if;
3448:
3449: --dbms_output.put_line('party_id = ' || l_party_id || ' FINAL score = ' || l_running_score);
3450: /* UPDATE IEX_SCORE_HISTORIES with the collections score, score_id, and last_score_date */
3451: /*
3452: SELECT IEX_SCORE_HISTORIES_S.nextval
3453: INTO l_score_history_id
3454: FROM dual;

Line 3452: SELECT IEX_SCORE_HISTORIES_S.nextval

3448:
3449: --dbms_output.put_line('party_id = ' || l_party_id || ' FINAL score = ' || l_running_score);
3450: /* UPDATE IEX_SCORE_HISTORIES with the collections score, score_id, and last_score_date */
3451: /*
3452: SELECT IEX_SCORE_HISTORIES_S.nextval
3453: INTO l_score_history_id
3454: FROM dual;
3455:
3456: IEX_SCORE_HISTORIES_PKG.Insert_Row(X_ROWID => l_rowid,

Line 3456: IEX_SCORE_HISTORIES_PKG.Insert_Row(X_ROWID => l_rowid,

3452: SELECT IEX_SCORE_HISTORIES_S.nextval
3453: INTO l_score_history_id
3454: FROM dual;
3455:
3456: IEX_SCORE_HISTORIES_PKG.Insert_Row(X_ROWID => l_rowid,
3457: P_SCORE_HISTORY_ID => l_score_history_id,
3458: P_OBJECT_VERSION_NUMBER => 1,
3459: P_PROGRAM_ID => 1,
3460: P_LAST_UPDATE_DATE => sysdate,

Line 3480: insert into iex_score_histories(SCORE_HISTORY_ID

3476:
3477: nCount := l_party_tbl.count;
3478:
3479: FORALL n in 1..nCount
3480: insert into iex_score_histories(SCORE_HISTORY_ID
3481: ,OBJECT_VERSION_NUMBER
3482: ,PROGRAM_ID
3483: ,LAST_UPDATE_DATE
3484: ,LAST_UPDATED_BY

Line 3491: values(IEX_SCORE_HISTORIES_S.nextval

3487: ,CREATED_BY
3488: ,SCORE_VALUE
3489: ,SCORE_ID
3490: ,PARTY_ID)
3491: values(IEX_SCORE_HISTORIES_S.nextval
3492: ,1
3493: ,1
3494: ,sysdate
3495: ,FND_GLOBAL.USER_ID