APPS.MSC_CL_PULL dependencies on MSC_CL_REFRESH_S

Line 4425: Select MSC_CL_REFRESH_S.NEXTVAL

4421: pTOTAL_TASK_NUMBER OUT NOCOPY NUMBER)
4422: IS
4423: BEGIN
4424:
4425: Select MSC_CL_REFRESH_S.NEXTVAL
4426: into pREFRESH_ID
4427: from dual;
4428:
4429: pTOTAL_TASK_NUMBER := TOTAL_TASK_NUMBER;

Line 4449: LRID= msc_cl_refresh_s.currval,

4445: UPDATE MSC_APPS_INSTANCES
4446: SET APPS_LRN= pLRN,
4447: LRTYPE= DECODE( pRTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4448: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, 'C', 'I'),
4449: LRID= msc_cl_refresh_s.currval,
4450: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4451: LAST_UPDATE_DATE= SYSDATE,
4452: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4453: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,

Line 4465: LRID= msc_cl_refresh_s.currval,

4461: MSC_UTIL.G_INCREMENTAL, 'I',
4462: MSC_UTIL.G_PARTIAL, 'P',
4463: MSC_UTIL.G_CONT, 'T'),
4464: SO_LRTYPE= DECODE( pSO_RTYPE, MSC_UTIL.SYS_YES, DECODE(pRTYPE,MSC_UTIL.G_INCREMENTAL,'I', 'C'), 'I'),
4465: LRID= msc_cl_refresh_s.currval,
4466: CLEANSED_FLAG= MSC_UTIL.SYS_NO,
4467: LAST_UPDATE_DATE= SYSDATE,
4468: LAST_UPDATED_BY= FND_GLOBAL.USER_ID,
4469: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID,