APPS.AMS_SCORERESULT_PVT dependencies on AMS_DM_SCORE_LISTS_S

Line 1665: SELECT AMS_DM_SCORE_LISTS_S.NEXTVAL

1661: l_seeded_target BOOLEAN := FALSE;
1662: L_SEEDED_ID_THRESHOLD CONSTANT NUMBER := 10000;
1663:
1664: CURSOR c_scoreListId IS
1665: SELECT AMS_DM_SCORE_LISTS_S.NEXTVAL
1666: FROM dual;
1667: l_insertSql VARCHAR2(1000);
1668: l_scoreListId NUMBER;
1669:

Line 1777: l_insertSql := 'INSERT INTO AMS_DM_SCORE_LISTS(SCORE_LIST_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,';

1773: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1774: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1775: ELSE -- If List Generation is successful then insert into AMS_DM_SCORE_LISTS. kbasavar 1/22/2004 for 3363509
1776:
1777: l_insertSql := 'INSERT INTO AMS_DM_SCORE_LISTS(SCORE_LIST_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,';
1778: l_insertSql := l_insertSql || 'CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SCORE_ID, LIST_HEADER_ID)' ;
1779: l_insertSql := l_insertSql || ' VALUES(AMS_DM_SCORE_LISTS_S.NEXTVAL, SYSDATE, :1, SYSDATE, :2 ' ;
1780: l_insertSql := l_insertSql || ', :3 , 1, :4, :5)';
1781:

Line 1779: l_insertSql := l_insertSql || ' VALUES(AMS_DM_SCORE_LISTS_S.NEXTVAL, SYSDATE, :1, SYSDATE, :2 ' ;

1775: ELSE -- If List Generation is successful then insert into AMS_DM_SCORE_LISTS. kbasavar 1/22/2004 for 3363509
1776:
1777: l_insertSql := 'INSERT INTO AMS_DM_SCORE_LISTS(SCORE_LIST_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,';
1778: l_insertSql := l_insertSql || 'CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SCORE_ID, LIST_HEADER_ID)' ;
1779: l_insertSql := l_insertSql || ' VALUES(AMS_DM_SCORE_LISTS_S.NEXTVAL, SYSDATE, :1, SYSDATE, :2 ' ;
1780: l_insertSql := l_insertSql || ', :3 , 1, :4, :5)';
1781:
1782: IF (AMS_DEBUG_HIGH_ON) THEN
1783: AMS_Utility_PVT.debug_message ('SCORE LISTS SQL = ' || l_insertSql);