DBA Data[Home] [Help]

APPS.MSC_CL_COLLECTION dependencies on MSC_COLLECTION_S

Line 1016: LCID= MSC_COLLECTION_S.NEXTVAL,

1012: RETCODE := MSC_UTIL.G_SUCCESS ;
1013:
1014: UPDATE MSC_APPS_INSTANCES
1015: SET ST_STATUS= MSC_UTIL.G_ST_COLLECTING,
1016: LCID= MSC_COLLECTION_S.NEXTVAL,
1017: LAST_UPDATE_DATE= v_current_date,
1018: LAST_UPDATED_BY= v_current_user,
1019: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1020: WHERE INSTANCE_ID= pINSTANCE_ID;

Line 1022: SELECT MSC_COLLECTION_S.CURRVAL

1018: LAST_UPDATED_BY= v_current_user,
1019: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1020: WHERE INSTANCE_ID= pINSTANCE_ID;
1021:
1022: SELECT MSC_COLLECTION_S.CURRVAL
1023: INTO v_last_collection_id
1024: FROM DUAL;
1025:
1026: RETURN TRUE;